@PaigeMiller You can also build in the single quotes that Oracle requires.   proc format; picture dateora low-high ='''%0d-%b-%y''' (datatype=date); run; data TEST; DATE='01JAN2024'd; putlog DATE= dateora. ; run; DATE='01-Jan-24'   ... View more

Thank  you Tom!     It worked.   I was missing the smallest detail.       ... View more

Very interesting! Thanks.    - Dr. Abhijeet Safai ... View more

hi, I am too late for this   PROC SORT DATA = your_data; BY Customer_Number Transaction_Amount currency_key;RUN; data alerts; set your_data; format alert_date date9.; /* Check for transactions in the last 7 days with the same amount and currency */ by Customer_Number Transaction_Amount currency_key; retain count; if first.Customer_Number then count = 0; if date_key >= intnx('day', today(), -10) and lag(Transaction_Amount) = Transaction_Amount and lag(currency_key) = currency_key then do; count + 1; if count >= 4 then do; alert_date = today(); output; end; end; else count = 0; drop count; run;  but one can try   PROC SORT DATA = your_data; BY Customer_Number Transaction_Amount currency_key;RUN; data alerts; set your_data; format alert_date date9.; /* Check for transactions in the last 7 days with the same amount and currency */ by Customer_Number Transaction_Amount currency_key; retain count; if first.Customer_Number then count = 0; if date_key >= intnx('day', today(), -10) and lag(Transaction_Amount) = Transaction_Amount and lag(currency_key) = currency_key then do; count + 1; if count >= 4 then do; alert_date = today(); output; end; end; else count = 0; drop count; run; PROC SORT DATA = your_data; BY Customer_Number Transaction_Amount currency_key;RUN; data alerts; set your_data; format alert_date date9.; /* Check for transactions in the last 7 days with the same amount and currency */ by Customer_Number Transaction_Amount currency_key; retain count; if first.Customer_Number then count = 0; if date_key >= intnx('day', today(), -10) and lag(Transaction_Amount) = Transaction_Amount and lag(currency_key) = currency_key then do; count + 1; if count >= 4 then do; alert_date = today(); output; end; end; else count = 0; drop count; run;   ... View more

Thank you All!     ... View more

Don't overcomplicate things: data _null_; c_mth = intnx('month',today(),-1)); call symputx('RMTH',put(c_mth,,monname3.)); call symputx('REP_MTH',lowcase(put(c_mth,monyy7.))); call symputx('ACT_MTH',lowcase(put(c_mnth,monname3.))!!PUT(c_mth,year2.)); call symputx('PERIOD',put(c_mth,yymmddn6.)); call symputx('RUN_DAYS',put(day(intnx('month',c_mth,0,'e')),z2.)); run; CALL SYMPUTX will automatically strip the second argument. INTNX with a third argument of 0 will result in the same value ("beginning" alignment). ... View more

Try a different variable name.  USER is normally a reserved word in SQL code. ... View more

Hi Patrick, Thank you for your quick response!! I will modify my code and follow the above. Regards, Santosh ... View more

We are creating the Temp tables (Volatile tables(Teradata) ) and calculating the required variables and outputting it to SAS (.lst file)    ... I tried creating the datasets, as we are dealing with huge sales transactions the creation of datasets is taking longer than anticipated hence trying to do the calculations on the fly.   None of us really knows what you are doing, what calculations you are doing, what report you are going to be creating. So its really hard to be more specific.    Some SAS procedures can work "in the database" rather than work in SAS, and so many of the calculations (depending on what calculations you need) could be done that way, and this could be a lot faster than whatever you are doing. For example, PROC SUMMARY/PROC MEANS docs say    In-Database Processing for PROC MEANS When large data sets are stored in an external database, the transfer of the data sets to computers that run SAS can be impacted by performance, security, and resource management issues. SAS in-database processing can greatly reduce data transfer by having the database perform the initial data aggregation. ... View more

Show what SAS code you are trying to create to get help with making a macro that will create that code.   First question is what does this mean datasets for every month falling under a quarter A quarter consists of three months.  Do you want to make one dataset that has the data for all three months in that quarter?  Or do you want to make three datasets, one for each month in the quarter? ... View more

Hi Ballard, Thank you for your time and suggestions. I was able to import the file into SAS using Proc import fixed width.now I can create or keep the required variables. Regards, Santosh ... View more