Why I cannot export this sas data file to Excel (ver 2003)

Mirisage — Thu, 30 Aug 2012 22:44:53 GMT

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

class date;

var Current One_to_30 Thirty_to_60 Sixty_to_90 Ninety_plus NPNA write_off;

output out=a.Table_I_want_finally(drop=_:)

sum=;

run;

proc print data= a.Table_I_want_finally;

run;

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

OUTFILE="\\xxxxx-a9-sas01\kkm\data\ANYNAME.xls"

DBMS=EXCEL REPLACE;

PUTNAMES=YES;

run;

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

Mirisage

Re: Why I cannot export this sas data file to Excel (ver 2003)

art297 — Thu, 30 Aug 2012 22:49:34 GMT

Does your site license SAS/Access for PC File Formats? If not, then you can't use the Excel engine.

Re: Why I cannot export this sas data file to Excel (ver 2003)

Ksharp — Fri, 31 Aug 2012 02:48:04 GMT

Or if your excel file is in English, try to use XLS engine .

DBMS=XLS

Re: Why I cannot export this sas data file to Excel (ver 2003)

Mirisage — Sun, 02 Sep 2012 21:21:39 GMT

Hi Ksharp.

Great!.

It worked like anything!

Many thanks for your help.

Hi Art,

Thank you also for your input.

Warm regards

Mirisage

topic Re: Why I cannot export this sas data file to Excel (ver 2003) in SAS Procedures

Why I cannot export this sas data file to Excel (ver 2003)

Re: Why I cannot export this sas data file to Excel (ver 2003)

Re: Why I cannot export this sas data file to Excel (ver 2003)

Re: Why I cannot export this sas data file to Excel (ver 2003)