May I ask you a question, please!    How did you calculate the date of birth for only sixth grader ?    Thank you in advance for your time.  ... View more

Yes, I ended up contacting SAS admin at our site. He was able to get into the server and delete the folder for me.   Thank you for time and continuous ideas. I appreciate it!!   Thanks, Ramesh  ... View more

@Ramesh_165 wrote: Yes I have close to 100 XLS workbook, and each workbook atleast has couple hundred worksheets. So looking for more of an automatic solution.   Thanks, Ramesh Do the names of the sheets in the XLS files follow a pattern?  If so then you should be able to write a program to read all of the sheet by using the pattern to generate the sheet names.  If you have a pattern (or think there might be a pattern) but cannot figure out how to make the code post enough information to explain the pattern and you can get some help creating the code. ... View more

@Urban_Science wrote: ...   The biggest challenge with using Dev/Test/Prod environments is not the SAS program file references, instead it is library references for where SAS data sets are saved to.  When using Dev/Test/Prod environments, the last thing you want to do is overwrite a file in production when you are currently trying to develop something.  My solution to this is to add a config file/process settings file to the beginning of the EG flow and then to update that file with the path to save/reference data sets.    ... This problem can be partially solved by using different levels / configurations for each environment. Additionally developers should not have any access rights to production environments, preventing unwanted changes of data or code. Unfortunately all steps i can think of, aren't capable of solving all issues, e.g. if you are using libraries defined in metadata and multiple developers are working on the same project, i can see no way to prevent conflicts without using different library names and having to rename (edit code) before the project is moved to test/prod. ... View more

Try this.   %macro process(); data output (keep=PatientID ep_st ep_end); format PatientID $CHAR13. ep_st mmddyy8. ep_end mmddyy8.; set test; /*Your input file*/ %do i = 1 %to 8; if (episode_start_&i. ne . and episode_end_&i. ne .) then do; ep_st = episode_start_&i.; ep_end = episode_end_&i.; output; end; %end; run; %mend; %process; ... View more