topic Re: Proc export in SAS Programming

Proc export

SASPhile — Thu, 23 Apr 2009 15:12:05 GMT

PROC EXPORT DBMS=EXCEL DATA= work.trials
OUTFILE= "c:\Biopharm Business Analysis SAS Project (2009)\BSM Prescriber Reports\trials.xls" REPLACE;
SHEET="report";

RUN;

When I run the above code,instead of going to the specified sheet "report" the output is redirected to report1. i have not created a sheet "report1".
"1" is added to whatever sheet name i define.

Re: Proc export

deleted_user — Thu, 23 Apr 2009 18:02:48 GMT

Hello SASPhile,

I don't really know the cause of the problem. But ... did you know that it is possible to export to excel using an Excel engine? I would do this:

libname myxls "c:\Biopharm Business Analysi......";

proc sql;
create table myxls.report as
select *
from work.trials;
quit;

There is something very nice: you can use Excel as any other database engine.

Does it help?

Yoba

Re: Proc export

SASPhile — Thu, 23 Apr 2009 18:11:07 GMT

libname myxls "C\Biopharm Business Analysis SAS Project (2009)\BSM Prescriber Reports\nonofeiba1.xls";

proc sql;
create table myxls.report as
select *
from work.novo_fieba;
quit;

Tried this..but the access is denied!!

Re: Proc export

sbb — Thu, 23 Apr 2009 18:15:05 GMT

Best to paste the actual SAS log content (with SAS generated NOTE and other diagnostic ERROR messages intact), rather than the SAS code -- is the LIBNAME statement formatted correctly with your drive letter missing a trailing colon character, possibly?

Re: Proc export

deleted_user — Thu, 23 Apr 2009 18:17:06 GMT

Hold on ... do you get the error message when you try to open the excel file? If so, you have to unassign the library before opening the excel file. You can do this with the following syntax:

libname myxls clear; Message was edited by: yoba