I am trying to create a file which out puts data into excel, I have two files that have more than 25 rows and everytime excel comes across them it has a hissy fit. It is putting the data on rows 1-25 (Columns A-Y) ad then it will populate the next row on column AZ. The rest of the data will not appear and there is a removed records error when i open up the excel format. With the code below I get no errors or warnings in SAS, just a dodgy excel file. Error: In event 'data': bad arguement #3 to 'format' (string expected, got nil) I ahve tried a multitude of things to no avail, i am thinking maybe excel has a default field of 25 for something, but i dont know what? is anyone able to help, I am at my wits end..? I have stripped my code to the bone and changed it to a sas help data set (incase anyone wants to see if it works for them - just need to update the path). ods excel file = " path\test.xlsx" proc report data = sashelp.pricedata split = "|" spacing = 1 nowd; column _all_; run; ods excel close;
... View more
