Hi Guys, So I am using a master file that contains about 6 %include statements calling my bigger sas programs. %include(C:\program1.sas); %include(C:\program2.sas); %include(C:\program3.sas); %include(C:\program4.sas); %include(C:\program5.sas); %include(C:\program6.sas); etc. Problem is that when I run this master file SAS stops working after the first few programs and just ignores the rest of the file.... no errors are seen in the log either... How can I fix this problem? ... View more

Hi Guys, I have a dataset with ~70,000 + rows. My version of excel cannot handle this amount but I still need to have the dataset exported to excel. Is there any way / code that I can use to get sas to split the data output across multple sheets in exel after it hits row limit? ... View more

Hi Guys, I am wondering if there is any code I can use / incorporate into my sas program which will email me at a specific email address if errors occur or if the program fails? Thanks! ... View more

Hi Guys, I have created an automation SAS file that calls/runs another SAS file in a specific directory. Here is my question: File1.SAS --> This is my automation file that contains a few macros for directory locations. I use the following include statement in this file: %include "&driv.\&path1.\&mth.File2.sas"; File2.SAS --> This is the main SAS file I run using File1.SAS. It also contains a few macros that need to be updated before running. My Question: If I move the macros from File2.SAS to File1.SAS will it cause any problems? The main reason I want to do this is because I want to update my macros only in 1 file and not open 2 seperate files each month to update. Thanks! ... View more

Hi guys, I have some fairly large data sets that are created on a monthly basis. I was wondering if you have any tips on data compression techniqes to speed up the time SAS takes to create these data sets? Thanks for the tips! ... View more