05-23-2014 03:09 PM
I'm trying to export data to an excel file without labeling it since I want the first row in the excel file to be the first row with data in the EG database.
I have EG 4.3 SAS9.2
However it gets an "ERROR 180-322: Statement is not valid or it is used out of proper order." for the putnames statement.
Appreciate all the help.
05-27-2014 12:32 PM
I have tried with ODS as you mentioned:
ods tagsets.ExcelXP file='C:\Documents\Reports SAS\test1.XLS';
Proc Report data=work.query_art_vta_compl noheader nowd;
ods tagsets.ExcelXP close;
and it turns out the following error:
ERROR: Physical file does not exist, C:\Documents\Reports SAS\test1.XLS.
And it did produces any file.