topic Re: proc export in SAS Procedures

proc export

Tal — Tue, 29 Jan 2013 14:53:10 GMT

they dont have sas access at work so i have to convert the file to csv before export it but i get errors

this is the code i am writing:

proc export data=mylib.susp_reasons_previous outfile= 'C:\Users\tiliev\Desktop\report.csv' replace;

sheet='susp_reasons_previous';run;

and this is the error i am getting:

1259 proc export data=mylib.susp_reasons_previous outfile= 'C:\Users\tiliev\Desktop\report.csv'

1259! replace;

NOTE: The previous statement has been deleted.

1260 sheet='susp_reasons_previous';

-----

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Does anyone see what i am doing wrong here,pleasE?

Re: proc export

DBailey — Tue, 29 Jan 2013 14:56:41 GMT

I believe the sheet statement is only used with excel exports, not csv's.

Re: proc export

Jagadishkatam — Tue, 29 Jan 2013 15:06:13 GMT

Hi,

Please try this

proc export data=mylib.susp_reasons_previous outfile= 'C:\Users\tiliev\Desktop\report.csv' dbms=csv replace;

sheet='susp_reasons_previous$';

run;

Thanks,

Jagadish

Re: proc export

Tal — Tue, 29 Jan 2013 15:06:36 GMT

hmm,

so any idea how to export csv files except through the wizard?

Re: proc export

AncaTilea — Tue, 29 Jan 2013 15:07:57 GMT

I agree, there is no way to name your sheetname when using CSV.

One work around it would be to name the file you are creating as the sheet-name.

For exmaple:

proc export data=mylib.susp_reasons_previous outfile= 'C:\Users\tiliev\Desktop\susp_reasons_previous.csv' replace;

sheet='susp_reasons_previous';run;

Good luck!

Anca.

Re: proc export

Tal — Tue, 29 Jan 2013 15:09:34 GMT

yea i did,still the same error.Probably "sheet" cant be used with csv as DBailey said

Re: proc export

Tal — Tue, 29 Jan 2013 15:14:34 GMT

thank you guys,

i do need all the query outputs to be on different worksheets of one excel file so i can have my table populated easily but i guess ODS
TAGSETS.EXCELXP would be the only way to do so?

Re: proc export

AncaTilea — Tue, 29 Jan 2013 15:21:20 GMT

So, then why don't your create an EXCEL file, instead of CSV?

Something like this:

%macro to_export(var = );

proc export data = sashelp.class (where=(sex="&var."))

outfile='file_path\Master_file.xls'

dbms=excel;

sheet="&var";

quit;

%mend to_export;

%to_export(var = F);

%to_export(var = M);

Re: proc export

Tal — Tue, 29 Jan 2013 15:29:41 GMT

but i cant export an excel file.I tried it before.We dont have sas access here

Re: proc export

AncaTilea — Tue, 29 Jan 2013 15:31:58 GMT

I see.

then ODS TAGSETS.EXCELXP is what you need.

See here more helpful info:

Re: proc export

Tal — Tue, 29 Jan 2013 15:42:08 GMT

yeaa but that works too

Thanks for all your help Anca and team,

Re: proc export

Tal — Wed, 30 Jan 2013 01:48:27 GMT

we dont have sas access to pc files but we have to ole db.Is there a way i can import/export excel files through it?

Re: proc export

DBailey — Wed, 30 Jan 2013 12:45:30 GMT

try this:

proc export data=mylib.susp_reasons_previous outfile= 'C:\Users\tiliev\Desktop\report.xls' dbms=csv replace;

run;

When you try to open the file with excel, you might get an error message that says the file is in a different format than the file extension, but if you click OK, excel should open the file.