topic export an empty dataset to excel in SAS Procedures

export an empty dataset to excel

abcd123 — Fri, 30 Aug 2013 18:33:10 GMT

Hello, All

I have an empty dataset:

data test;

length var1 8 var2 $ 8 var3 8;

label var1='label for variable 1'

var2='label for variable 2'

var3='label for variable 1'

;

stop;

run;

Now I want to export this empty dataset to excel, using the label as the first row in excel:

proc export data=test

outfile='c:\temp\test.xlsx'

label

dbms=excel replace;

run;

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'..

I actually found this post ; but it does not seem to work for exporting an empty dataset.

Is there a way to make such export possible? Thanks.

Re: export an empty dataset to excel

ballardw — Fri, 30 Aug 2013 19:38:02 GMT

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.

Re: export an empty dataset to excel

damAK — Mon, 04 Jun 2018 11:04:12 GMT

Extending to the question:

I have exported the empty dataset to csv. still it is giving the error.

ERROR: Export unsuccessful.