The SAS Output Delivery System and reporting techniques

PROC EXPORT and Proc Print using EXCELXP tagset

Reply
N/A
Posts: 0

PROC EXPORT and Proc Print using EXCELXP tagset

I have a job which generates EXCEL reports on OS2 platform using PROC PRINT EXCELXP tagset. The job is taking 10 minutes CPU mainframe time (may be because the report has 8000 records and styles associated to them).
There is only one db2 call in the job and I did verify that PROC PRINT step is the only step consuming all the time. Generally SAS jobs do not consume that much CPU time. So I tried to use PROC EXPORT option , creating EXCEL sheet manually with the styles I wanted and tried to load to the same sheet. That way only data is loaded to the sheet and not the styles. And When I ran my job with PROC EXPORT, I found an error message saying that "Import/Export facility is not supported on this operating system". Is that true? Can I not use PROC EXPORT on OS2 platform? The code I used is as follows:

PROC EXPORT DATA=XXXXX
DBMS=EXCEL REPLACE;
SHEET="class";
RUN;
Frequent Contributor
Posts: 102

Re: PROC EXPORT and Proc Print using EXCELXP tagset

Posted in reply to deleted_user
Are you on OS/2, or are you on a mainframe? z/OS or MVS (IBM IS/390 architecture) is what people usually mean when they say "mainframe".

In any case, if SAS tells you that something won't run, it's probably correct. The supported platforms and formats are listed at <>.

And the ExcelXP tagset is not blazingly fast. In fact, it's disappointingly slow, but it's supposed to get better in SAS 9.3.
N/A
Posts: 0

Re: PROC EXPORT and Proc Print using EXCELXP tagset

Posted in reply to JackHamilton
Thanks JackHamilton. I am using MVS operating system. I am still not able to figure it out if PROC EXPORT works in MVS.
Frequent Contributor
Posts: 102

Re: PROC EXPORT and Proc Print using EXCELXP tagset

Posted in reply to JackHamilton
I don't know why the forum software deleted the url to the list of supported platforms in my earlier message. In any case, z/OS is not one of the platforms listing as supporting PROC EXPORT. You will have to use the ExcelXP tagset or one of the other ODS solutions.

The URL is http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000316288.htm
SAS Super FREQ
Posts: 8,864

Re: PROC EXPORT and Proc Print using EXCELXP tagset

Posted in reply to JackHamilton
Jack:
It looks like you might have started to enclose your URL in < > brackets. Sometimes, (but, maddeningly, not all the time) when your post contains the angle brackets, text gets truncated.

To get around that, I either use square brackets[ ], curly braces { } or I use the "named entity" method of inserting angle brackets:
&_lt_; and &_gt_; (without the underscores)
that is, ampersand-lt-semicolon or ampersand-gt-semicolon

cynthia
Super Contributor
Posts: 345

Re: PROC EXPORT and Proc Print using EXCELXP tagset

Posted in reply to deleted_user
Afaik proc export does not support the use of stylesheets at all.
Ask a Question
Discussion stats
  • 5 replies
  • 482 views
  • 0 likes
  • 4 in conversation