Hi ,
We are trying to write out a sas dataset from MVS (v 9.1) to a PC server with the following code:
DATA TEST;
LENGTH ID $14. ;
SET SASHELP.CLASS;
N=_N_;
ID=CATS(' ','123456789122',PUT(N,Z2.)) ;
RUN;
PROC PRINT;
RUN;
FILENAME CUSTX FTP "EXCEL.XLS"
HOST=....
CD="\.......\TEMP"
USER='ANONYMOUS' PASS="&PASS"
RECFM=S;
ODS TAGSETS.EXCELXP FILE=CUSTX RS=NONE TRANTAB=ASCII STYLE=MINIMAL
OPTIONS(SHEET_NAME="THIS IS A TEST" FROZEN_HEADERS='YES');
PROC PRINT DATA=TEST NOOBS LABEL ;
VAR ID/STYLE(DATA)={TAGATTR="FORMAT:00000000000000"};
VAR _ALL_ ;
TITLE1 'THIS IS A TITLE TEST' ;
RUN;
The code works except
1. it did recogonized the Excel tagset options. No frozon_header and the sheet name is 'Table 1 - Data Set WORK.TEST' instead of the one we defined.
2. There is no title in the output spreadsheet. We tried use the HTML tagsets and it will ouput a title but it will not except the statement
VAR ID/STYLE(DATA)={TAGATTR="FORMAT:00000000000000"};
and the output variable ID will formatted 1.23457E+13 instead of 12345678912201
3. When we use VAR ID/STYLE(DATA)={TAGATTR="FORMAT:00000000000000"};
is ther any good idea to exclude the variable from the _ALL_ list.We have datasets that has over 50 variables and multi STYLE(DATA)= . It is a pain to type out the rest of the print list.
Thanks for the help we can get..
... View more
