proc export

[Tal]

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?

[DBailey · Accepted solution]

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

[Tal]

hmm,

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

[Jagadishkatam]

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

[Tal]

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

[AncaTilea]

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.

[Tal]

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?

[AncaTilea]

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

[Tal]

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

[AncaTilea]

I see.

then ODS TAGSETS.EXCELXP is what you need.

See here more helpful info:

[Tal]

yeaa  but that works too

Thanks  for all your  help Anca and team,

[Tal]

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?

[DBailey]

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.