Hi, I am new to SAS SPDS server. I have been using SAS Base servers in my previous organisations. Now I have been hearing about SAS SPDS sever. I googled but couldn't get the actual purpose of it. Please help me in understanding in this area. Thanks in advance.  ... View more

Hi, I am currently using SAS Data step.  Data test1; /* loading approx 17 lakhs records */    Set source (keep=var1 var2 var3); /* source data set has 322596778 obs */ where DATEPART(START_from_dtm)="31JAN2020"D <=datepart(START_to_dtm); run; The above data step is running for 25 minutes. Is there any solution to execute the query faster. START_from_dtm has index on it. So tried by keeping only START_from_dtm column but same time. I am using the same query multiple times and the execution is increasing.  Thanks in advance.  ... View more

Hi, I want to use intnx on my date variable which is in the dateampm format. My date variable has the value of "31Dec14:00:00:00" I want to use the below code example. Data _null_;    set callsymput('date1',put(intnx('month',today(),-1,'same'),date9.);  Run; but when I use on my dataset date variable as mentioned below date>"&date1". resulting 0 records even if there are records. Reason, it is in date time format. Can someone help me how to use call symput on datetime variables Thanks 🙂 ... View more