topic Re: Sas mainframe data filename older rec deletion in SAS Programming

Sas mainframe data filename older rec deletion

rohitkrishna — Mon, 28 Sep 2020 11:46:48 GMT

DATA ML1;                 
INFILE CARDS;             
INPUT @1 FILENAME $CHAR10.
      @12 REFDT YYMMDD8.; 
CARDS;                    
LOAN_CREA 20/09/20        
LOAN_UPDT 18/09/20        
LOAN_MAIN 19/09/20        
 ;                         
RUN;      
DATA DEL;                                                    
SET ML1;                                                     
PUT @1 ' DELETE ' FILENAME;                                  
RUN;

Hi All plz look above code i am facing one issue i want to delete older filename not recent one kindly find below my requirement

My Req is :

LOAN_UPDT
LOAN_MAIN

Thanks & Regards

Rohit

Re: Sas mainframe data filename older rec deletion

Kurt_Bremser — Mon, 28 Sep 2020 12:02:30 GMT

How do you derive the cutoff date?

Re: Sas mainframe data filename older rec deletion

rohitkrishna — Mon, 28 Sep 2020 12:23:47 GMT

Hi Kurtbremser,

Thanks for the quick response , as per below conversation i tried with one statement but it didn't work plz find below code

IF REFDT LE INTNX('DAY', TODAY(),-180) THEN DELETE;

kindly share some solution for the above code issue

Thanks & Regards

Rohit

Re: Sas mainframe data filename older rec deletion

PaigeMiller — Mon, 28 Sep 2020 12:28:02 GMT

What happened to make you say it didn't work? Please explain further. SHOW US what is wrong.

If there is an error in the log, please show us the entire log for the DATA step, including code in the log, and all NOTEs, WARNINGs and ERRORs. Please paste the log as text into the window that appears when you click on the </> icon.

Re: Sas mainframe data filename older rec deletion

Kurt_Bremser — Mon, 28 Sep 2020 12:40:53 GMT

I would simplify it, and use a subsetting IF:

if refdt gt today() - 180;