In proc reg command,   When we use 'selection' option to select the best regression model in terms of different critieria (e.g. aic, cp, bic, rsquare and etc..)   How does SAS come up with one best model when the command 'best=1' is given.    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

Hi, can anyone guide me regarding the steps related to email settings at the SAS level, i.e.  how to send emails using the SAS  enterprise guide and e-mail SMTP Setup with Microsoft Office 365?   ... View more