08-30-2013 02:33 PM
I have an empty dataset:
length var1 8 var2 $ 8 var3 8;
label var1='label for variable 1'
var2='label for variable 2'
var3='label for variable 1'
Now I want to export this empty dataset to excel, using the label as the first row in excel:
proc export data=test
However I got following error message:
ERROR: Error attempting to CREATE a DBMS table. ERROR: Execute: Field 'label for variable 1'
already exists in table 'TEST'..
Is there a way to make such export possible? Thanks.
08-30-2013 03:38 PM
Depending on your needs, exporting as a CSV seems to work. File will need a CSV instead of XLSX extension but can still open in Excel then save as if needed.