Recently in the SAS Community Library: SAS' @BethEbersole reveals 4 steps to stop money laundering, solve law-enforcement cases, find missing children and more with SAS Visual Investigator.
Hello,
I am running an interaction but need to reorder the x axis variables from how it is displayed below to PRISm, GOLD 0 - GOLD 4. Additionally, I need to change the legend diabetes_P1 to 'diabetes at baseline' and the Title to 'Change in FEV1pp'.
Proc GLM data=working4 (rename=(change_fev1pp = Change));
class finalgold_P1 (ref='GOLD 0') diabetes_p1 (ref="No");
model Change = finalgold_P1 diabetes_p1 finalgold_p1*diabetes_p1;
lsmeans diabetes_p1 finalgold_P1/ pdiff;
format finalgold_p1 Baseline_GOLD_Stage. diabetes_p1 diabetes_baseline. diabetes_P3 diabetes_final.;
label Change ='Change in FEV1pp';
run;
Output:
I've tried:
1. Using rename for diabetes_P1. This does not work, I think due to the formatting of diabetes_P1 to diabetes_baseline.
2. I tried adding Title = 'Change in FEV1pp Over 10 Years' into the code. There are no errors, but it doesn't change the title.
Someone suggested I use ODS but I am unfamiliar with using that code. Is there an easy way to incorporate what I need into this code?
... View more
In proc reg command, When we use 'selection=' option to select the best regression model based on various criteria (e.g. aic, cp, bic, rsquare and etc..) How does SAS come up with a single best model when it needs to consider the criteria all together simultaneously? I'm curious about this because I think different criteria may rank a model differently. c.f) proc reg data = /name of data/; model Y = X1 -- Xn / selection = adjrsq mse aic bic cp best = 1; run;quit;
... View more
Hi I have a file uploaded to a big data platform showing correct d.p but somehow when our clients see the same file via ODBC, the decimal place change from 4 to 2, how did that happen? Do I need to setup schema for showing data via ODBC or there is specific settings required dealing with?
... View more
Hi experts.
I am trying to use the example at https://developers.sas.com/rest-apis/folders-v5?operation=getFolderItem to get info, such as the folder ID, about a specific folder (in a specific path such as /public/projectA). I do not understand how to use this API. Tried several options but none worked.
Anyone has a working example of this?
By the way, is the API documentation referenced above the same for Viya 4 and Viya 3.5?
... View more
How to create a tabulated report based on data:
Column CATEGORY in H means a horizontal report. TITLE_LEVELS indicate how many levels of title there are. TITLE_LEVEL1 is the main header, TITLE_LEVEL2 is the sub-header of TITLE_LEVEL1, and TITLE_LEVEL3 is the sub-header of TITLE_LEVEL2.
All columns are Character data type
proc tabulate data=datset;
class TITLE_LEVEL1 TITLE_LEVEL2 TITLE_LEVEL3 Column1 ;
table TITLE_LEVEL1*
TITLE_LEVEL2*TITLE_LEVEL3;
run;
i have data
i want
PFA
... View more