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
Need further help from the community? Please ask a new question.