08-30-2012 06:44 PM
Hi SAS Community,
I have used the SAS dataset named “vtemp” and generated the SAS dataset "a.Table_I_want_finally" using proc summary (Please see below code).
proc summary data=vtemp nway missing;
format date date9.;
var Current One_to_30 Thirty_to_60 Sixty_to_90 Ninety_plus NPNA write_off;
proc print data= a.Table_I_want_finally;
Now I want to export a.Table_I_want_finally to Excel (ver. 1993), and I used the following code.
PROC EXPORT DATA=a.Table_I_want_finally
An error messege comes like this:
ERROR: DBMS type EXCEL not valid for export.
Then commented out dbms statement and ran.
Then this error message comes.
ERROR 180-322: Statement is not valid or it is used out of proper order.
Could any one help me to get over this problem?
From the literature, I found these:
DBMS= tells SAS what kind of file to create; the default is Excel 5. But what is the meaning of it?
PUTNAMES to output the variable name. If "PUTNAMES=NO" is used, the export procedure will not output any variable names, beginning with the data record instead.
But why then error message comes?
Thank you for the help
09-02-2012 05:21 PM
It worked like anything!
Many thanks for your help.
Thank you also for your input.
Need further help from the community? Please ask a new question.