I made the change as you suggested and it works.  Thanks very much for your help. ... View more

Hi Shagillmam,   Here is my last test:   //LETSGO EXEC SAS //WORK     DD UNIT=SYSDA,SPACE=(CYL,(1000,1000),,,ROUND) //*XMT007  DD DSN=SGSM.PXXMT07.SASTAGSU,DISP=SHR //*YSIN    DD DSN=SGSM.IBM.SOURCE(DXXMT007),DISP=SHR //SYSIN    DD * *ILENAME XXMT007 'SGSM.PXXMT07.SASTAGSU'; FILENAME XXMTCSV 'SGSM.CXXMT07.SASTAGSU.CSV'; %DS2CSV (DATA=SGSM.PXXMT07.SASTAGSU,RUNMODE=B,CSVFREF=XXMTCSV); //   I get this error...so it looks like it needs the reference.   ERROR: SGSM.PXXMT07.SASTAGSU is an invalid name for the SAS data set to be formatted.   Have you tried this DS2CSV macro on your z/os environment?  I'd like to see the whole job for a successful run.  Thanks. ... View more

Hi Shagillman, Thanks for the correction to your macro.  I did try the DS2CSV and I also have a syntax or format error. You can see this on the post to Cynthia_SAS just before I posted the question to you.  Do you have a minute to look at that post? Thanks, earlex ... View more

Hi Cynthia,   I tried to run the DS2CSV macro on z/os (in batch mode) and it doesn't like my inbound file reference.  The file to be copied is a SAS library.  I hope the macro will copy a SAS library file to a flat CSV file on the mainframe.  Here is the JCL:   //*------------------------------------------------------------------ //*        DUMP OUT SAS LIBRARY XXMT007 //*------------------------------------------------------------------ //LETSGO EXEC SAS //WORK     DD UNIT=SYSDA,SPACE=(CYL,(1000,1000),,,ROUND) //*XMT007  DD DSN=SGSM.PXXMT07.SASTAGSU,DISP=SHR //SYSIN    DD * FILENAME XXMT007 'SGSM.PXXMT07.SASTAGSU'; FILENAME XXMTCSV 'SGSM.CXXMT07.SASTAGSU.CSV'; %DS2CSV (DATA=XXMT007,RUNMODE=B,CSVFREF=XXMTCSV); //   Here is the syntax error: 1          FILENAME XXMT007 'SGSM.PXXMT07.SASTAGSU'; 2          FILENAME XXMTCSV 'SGSM.CXXMT07.SASTAGSU.CSV'; 3          %DS2CSV (DATA=XXMT007,RUNMODE=B,CSVFREF=XXMTCSV); ERROR: File WORK.XXMT007.DATA does not exist. NOTE: Execution terminating...   Any suggestions?   Thanks, Mike ... View more

Hi Shagillman, I am trying to run your macro on z/OS. I copied the code and upper-cased it:   %MACRO RETAINVARS;  %LET DSID=%SYSFUNC(OPEN(WORK.VARLIST));  %DO UNTIL (&RC NE 0);   %LET RC=%SYSFUNC(FETCH(&DSID));   %IF &RC NE 0 AND &RC NE -1 %THEN %PUT %SYSFUNC(SYSMSG());   %ELSE %DO;    %LET VARNAME=%SYSFUNC(GETVARC(&DSID,%SYSFUNC(VARNUM(&DSID,NAME))));    RETAIN &VARNAME;   %END;  %END; %MEND RETAINVARS;   I am getting syntax (?) errors as follows:   ERROR: An unexpected semicolon occurred in the %DO statement. ERROR: A dummy macro will be compiled. ERROR: There is no matching %IF statement for the %ELSE. ERROR: SAS ended due to errors.        You specified: OPTIONS ERRORABEND;. ERROR: Errors printed on page 1.   I am well versed in z/OS, but not SAS.  So I am looking for some help with the above errors.   BTW, I am trying to copy a SAS library to a CSV file on the mainframe.  I hope your SAS program will do this.  Thanks. ... View more