BookmarkSubscribeRSS Feed
abcd123
Fluorite | Level 6

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.

2 REPLIES 2
ballardw
Super User

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.

damAK
Calcite | Level 5

Extending to the question:

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

ERROR: Export unsuccessful.

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2262 views
  • 0 likes
  • 3 in conversation