topic Re: Proc export error in SAS Enterprise Guide

Proc export error

PJorge — Fri, 23 May 2014 19:09:33 GMT

Hi,

I'm trying to export data to an excel file without labeling it since I want the first row in the excel file to be the first row with data in the EG database.

I have EG 4.3 SAS9.2

proc export

data=work.QUERY_ART

DBMS=excelcs

outfile="C:\Documents\Reports SAS\Test.xls"

Replace;

PUTNAMES=NO;

Sheet="Test";

Server="pgl0408";

Port=8629;

Run;

However it gets an "ERROR 180-322: Statement is not valid or it is used out of proper order." for the putnames statement.

Appreciate all the help.

Re: Proc export error

stat_sas — Fri, 23 May 2014 19:34:49 GMT

Hi,

I think PUTNAMES=NO will not work with excel file. Try to export it as csv file.

Thanks

Re: Proc export error

Reeza — Fri, 23 May 2014 20:08:55 GMT

Why do you need no names?

When EG imports it strips the first row usually anyways.

Re: Proc export error

Ksharp — Sat, 24 May 2014 10:29:48 GMT

Did you try ODS ?

ods tagsets.excelxp file='c:\temp\x.xls' ;
proc report data=sashelp.class noheader nowd;
run;
ods tagset.excelxp close;

Xia Keshan

Re: Proc export error

PJorge — Tue, 27 May 2014 16:32:25 GMT

Hi,

I have tried with ODS as you mentioned:

ods tagsets.ExcelXP file='C:\Documents\Reports SAS\test1.XLS';

Proc Report data=work.query_art_vta_compl noheader nowd;

run;

ods tagsets.ExcelXP close;

and it turns out the following error:

ERROR: Physical file does not exist, C:\Documents\Reports SAS\test1.XLS.

And it did produces any file.

Re: Proc export error

ballardw — Tue, 27 May 2014 16:44:21 GMT

Are running this on a server or locally. The server may not have a path available of C:\Documents\Reports SAS.

Re: Proc export error

stat_sas — Tue, 27 May 2014 16:44:43 GMT

Hi,

Use this for the desired output.

Thanks,

Naeem

proc export

data=work.QUERY_ART

DBMS=csv

outfile="C:\Documents\Reports SAS\Test.csv"

Replace;

PUTNAMES=NO;

Run;