About gbrad

gbrad · ‎02-19-2015

Thanks for responding. All the obs read from the backup are being appended to the delfil, instead of the just the ones that are older than 30 days. I'm trying to get the where date= clause to work. THERE WERE 17597253 OBSERVATIONS READ FROM THE DATA SET BACKUP.DSNSIZDT WHERE DATE>'20JAN2015'D; 17597253 OBSERVATIONS ADDED. THE DATA SET DELFIL.DSNSIZDT HAS 51563302 OBSERVATIONS AND 8 VARIABLES.

gbrad · ‎02-19-2015

On z/OS 2.1 runing SAS 9.3 I'm attempting to age or delete any obs that are greater than 30 days old off of a sasdb backup file. I've tried using both proc append & proc dataset to accomplish the task, with no positive results. Here's the code using proc dataset. //SASDB DD DISP=OLD,DSN=STRG.RMMRPT.DSNSIZDT.SASDB //BACKUP DD DISP=OLD,DSN=STRG.RMMRPT.DSNSIZDT.SASDB.BACKUP //DELFIL DD DISP=OLD,DSN=STRG.RMMRPT.DSNSIZDT.SASDB.BACKUP.DELFILE //SASLIST DD SYSOUT=* //SYSIN DD * OPTIONS SOURCE SOURCE2; OPTIONS NOCENTER LS=250; PROC CONTENTS DATA=BACKUP.DSNSIZDT; PROC CONTENTS DATA=DELFIL.DSNSIZDT; DATA _NULL_ ; CALL SYMPUT ('DT',PUT(TODAY()-30,DATE9.)) ; PROC DATASETS; LIBNAME BACKUP 'STRG.RMMRPT.DSNSIZDT.SASDB.BACKUP' DISP=OLD; LIBNAME DELFIL 'STRG.RMMRPT.DSNSIZDT.SASDB.BACKUP.DELFILE' DISP=OLD; APPEND BASE=DELFIL.DSNSIZDT DATA=BACKUP.DSNSIZDT ; WHERE DATE GT "'&DT'"D;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Aging old obs off a sas dataset

Aging old obs off a sas dataset

Re: Aging old obs off a sas dataset

Aging old obs off a sas dataset