If we follow the data presented now, we can achieve this with the following code. proc sort data=have out=next; by client orderDate ordernumber; run; data want; set next; by client orderDate ordernumber; length NextElegibilityDate 8 isElegible $3; format NextElegibilityDate ddmmyy10.; retain nextdt; if first.client then do; isElegible='Yes'; NextElegibilityDate=orderDate; nextdt=orderDate+daysTowait; end; else do; NextElegibilityDate=nextdt; if not(first.orderDate) then do; isElegible='Yes'; if last.orderDate then do; nextdt=orderDate+daysTowait; NextElegibilityDate=nextdt; end; end; else if orderDate>NextElegibilityDate then do; isElegible='Yes'; end; else do; isElegible='No'; end; end; drop nextdt; run; The point about daysTowait is excluded. ... View more

I don't have enough information, so please check.   First of all, isn't the waiting period from 1/1 to 1/10 9 days? If we treat this as 10 days, then from 1/25 (NextElegibilityDate with client=1, ordernumber =4) to 2/4, the waiting time will be 11 days. Then, the orderDate of ordernumber =3 and ordernumber =4 in client=1 is the same day, does it mean that the second one is treated as elegible for the same order date?   Also, in client=1, ordernumber =4, the elegible is determined first, not as a result of comparing NextElegibilityDate(2/4) and orderDate(1/25), is this correct?   ... View more

You may find this post helpful. https://communities.sas.com/t5/ODS-and-Base-Reporting/Using-ODS-to-password-protect-file/td-p/509182   By the way, I have done the process of adding passwords using 7zip in a Windows environment, as shown in the url posted by reeza. ... View more

It depends on what kind of data you currently have and what purpose you want to use the data for, but in general, normalized data is easier to work with. Therefore, it is better to use table3. It is easy to extract monthly data. ... View more

Before you can create a macro program, you need to create a program that works manually. Have you already created it? If you have a program, we can advise you on how to make a macro.   Also, is XXXX a sequential number? This can be done by recording the numbers in an external file or permanent data set. Each time you run the program, you can read the number and overwrite it with +1. For example, the following program will store a sequential number starting from 0001 in the macro variable "XXXX" every time it is executed. %if %sysfunc(exist(lib.covid))=0 %then %do; data lib.covid; cnt=0; run; %end; data lib.covid; set lib.covid; cnt=cnt+1; call symputx('XXXX',put(cnt,z4.)); run;   The last step is to execute the program in batches. If you are using Windows, you can register the following command in the task scheduler. "C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -sysin "C:\temp\yourprogram.sas" -sysin is the command to batch submit.   ... View more

Please check if you are able to access the site successfully via FTP. You should be able to login and get the root directory with the following code. If you are using a router, don't forget to specify passive mode. filename dir ftp '' ls user="&user" host="&host" pass="&pass"; data _null_; infile dir; input; put _INFILE_; run; If you simply want to upload the file to ftp, you can use command prompt or powershell script to upload and run it with x command.   ... View more

From which data source did you create the table and how? I don't think you can change it directly in model studio, so you will need to modify the data table itself that you are currently referring to.   ... View more

Wow, I think it was working fine about a month ago. All the results are the same even if I change the Time Range now. ... View more

If you can't provide any data, explain your evaluation method or what you want to do, you can't get any advice. ... View more