Hello @whymath  Given the way  this format work, in my opinion, the appropriate approach would be to request SAS for the features as you expect it to have at SAS Product Suggestions - SAS Support Communities ... View more

Hello @Gigiwen  Please consider the following example code. This should work for you. It works with the datasets you attached. Make changes as needed. The code here create one dataset for each date value in your datelist dataset This is for illustration only. You can create only one dataset which is recreated in each iteration. I have commented out your code. %macro outPhi(raw); %do i=1 %to 6; /* proc sql ; select Date into :Date from DateList where n=&i; quit; */ /* Create a temporary dataset to hold date value. The code here create one dataset for each date value. This is for illustration only. You can create only one dataset which is recreated in each iteration*/ */ data temp_&i.; set DateList; if _n_=&i. then output; run; /* Step 1: Read Chop the sample and estimate it */ /*data temp; set &raw; if date < &Date; run; */ /* Select what you need*/ proc sql; create table temp&i. as select a.* from &raw as a, temp_&i. b where a.date < b .date; quit; /* Step 2: Run regression - omitted */ %end; %mend; %outPhi(OneStock); ... View more

Hello @whymath  I see what you are asking about. BESTDw.p simply aligns the digit as pointed by @ballardw . BESTDw.p documentation describes p as precision, but I don't see it doing that. What one would have expected is to\hat the format would round off the value at the pth position from decimal. (https://simple.wikipedia.org/wiki/Arithmetic_precision ). May be somebody from SAS can elaborate on this. ... View more

Hello @Martin_Bryant  In addition to the many suggestions above, I  suggest  the following: 1.The program needs to be run multiple times and not sure how many times to run,  Convert your program to a stored process with prompts as needed.  The stored process can be be run as and when needed  and the parameter input. In addition the stored process can be invoked as using http request (post or get as needed) / REST API. 2.The program has to be run at predetermined intervals  Use a scheduler for example to run the job. The parameter value can be stored in a text file and the job reads it. ... View more

Hello @SASUserRocks  Please have a look at the following https://communities.sas.com/t5/SAS-Communities-Library/How-to-send-email-using-SAS/ta-p/746523#odsfmt https://communities.sas.com/t5/SAS-Programming/send-email-from-SAS-add-reports-and-text-in-body-of-email/td-p/851803 These should help. ... View more

Hello @J111  Try running only this code in SAS Studio title "WOW"; proc sgplot data=sashelp.class; series x=weight y=height / group=sex ; run; ... View more

Hello @J111  It should work. Make sure this resolves "GPATH=&sasworklocation" You can test by using %put &=sasworklocation; in your code. and check the log.   ... View more

Hello @SAS_1001  "well, it's working in PC SAS but in SAS Studio its giving numbers.  Tried other solutions as well but no luck yet." I tested the code in SAS Studio itself - SAS on Demand for Academics and posted the results. I repeat what you need to do  - use dbms=XLSX . ... View more

Hello @SAS_1001  As advised by @Kurt_Bremser try changing the DBMS to xlsx. I tried your code after changing DBMS=XLSX and everything is as you wanted.   ... View more

At the minimum username and password AND the hostname of the SAS server. That should be sufficient. The rest keep defaults. ... View more

Hello @aalborz-ema  "My specific issue is that in the SAS Management Console I don't see anything. It's all blank, so I can't add any users." Did you create profile to connect to the Metadata server? ... View more

Hello @alepage  Your question is  "Is there a Unix command that I can use in SAS to get the file extension." Well there is . Assume that the file has an extension then use the following command to get the extension. Note filename is the variable holding the name of the file. ${filename##*.} The following example shows the usage   ... View more

Hello @blueskyxyz  Please have a look at the following. They are relevant to your question. The first one a interesting forum discussion. The last one shows the use of Amazon cli for data transfer. SAS and AWS S3 - Page 2 - SAS Support Communities  57091 - File transfers using the Amazon Simple Storage Service (Amazon S3) (sas.com) Command Line Interface - AWS CLI - AWS (amazon.com) ... View more

Hello @UttamKumar  How does PROC S3 perform in  data transfer between local storage to Amazon S3 storage? Can one create a library reference (using libname) using PROC S3  and use it in a local SAS program executing locally? ... View more

Hello @SatishR  Your infrastructure needs an upgrade, in addition to the storage RAM is also on a lower side. ... View more