09-23-2013 07:30 PM
data one two three;
if a=2 output one;
if a=3 output two;
if a=4 output three;
/*creates three data sets*/
ods tagset (sheet interval='none' sheet_name = &name.....etc);
proc report data = &ds. NOWD; headskip split = '*' wrap nowd
col etc..........; /*the column fields go here*/
ods tagset.excelXP close;
When I run the report to populated the 3 different tabs I get the error message LINE AND COLUMN CANNOT BE DETERMINED
Why am I getting this error and will I have to rename the &name portion since it is in quotes
09-23-2013 10:53 PM
should be odd tagset.excelxp perhaps?
Usually means there's an error in the code somewhere but hard to see without all the code.
If you're splitting the data by a variable, in a proc report you can do it in one step using the sheet_interval option and adding in a variable that has the name.