cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rstoffregen
‎11-05-2019
  • 4 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Issue running Mainframe EBCDIC data on Windows

by Fluorite | Level 6 in SAS Programming
‎09-18-2017 03:57 PM
‎09-18-2017 03:57 PM
I have pursued the comment concerning specifying EBCDIC input and output formats.  What I see now are SPACES or FILL columns in each record.  On windows an ASCII blank is a hex 20 vs EBCDIC blank is a hex 40.   Any ideas on how to ensure when a blank is written to the output file are all hex 40 without having to specify each column in the PUT stmt ? ... View more

Issue running Mainframe EBCDIC data on Windows

by Fluorite | Level 6 in SAS Programming
‎09-18-2017 02:28 PM
‎09-18-2017 02:28 PM
What options are needed to process (read, write) EBCDIC data on Windows and keep the data in EBCDIC format?   We have a need to download data from a mainframe and process it in SAS on windows while keeping it in EBCDIC format so it can be returned to the mainframe for additional processing.   I’ve tried several variations in a little test pgm and always come back with the error in the log (below). What am I missing ???   Note: we FTP the file using a BINARY transfer along with the options RECFM=F LRECL=80.   SASLOG follows   NOTE: PROCEDURE PRINTTO used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              20.09k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        376  Switch Count  0         SYMBOLGEN: Macro variable JOBPATH resolves to i:\APPL_DATA\OSYS065\RPTlib\zOAC0486\D2017-09-18_Mon_13-16-43 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable JOBSNAME resolves to S0001. SYMBOLGEN: Macro variable JOBPGM resolves to zOAC0486f. MPRINT(JOBEXEC):   PROC PRINTTO PRINT="i:\APPL_DATA\OSYS065\RPTlib\zOAC0486\D2017-09-18_Mon_13-16-43\S0001.zOAC0486f.SASLIST.txt"; SYMBOLGEN: Macro variable DEBUG resolves to YES SYMBOLGEN: Macro variable JOBPATH resolves to i:\APPL_DATA\OSYS065\RPTlib\zOAC0486\D2017-09-18_Mon_13-16-43 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable JOBSNAME resolves to S0001. SYMBOLGEN: Macro variable JOBPGM resolves to zOAC0486f. JOBexec INFO: SASLIST assigned to i:\APPL_DATA\OSYS065\RPTlib\zOAC0486\D2017-09-18_Mon_13-16-43\S0001.zOAC0486f.SASLIST.txt SYMBOLGEN: Macro variable SOURCE resolves to MYSOURCE SYMBOLGEN: Macro variable SOURCE resolves to MYSOURCE SYMBOLGEN: Macro variable PGM resolves to zOAC0486f NOTE: %INCLUDE (level 1) file MYSOURCE(zOAC0486f) is file D:\APPL\OSYS065\zoac0486f.sas. 2559     +  FILENAME INFL01 'D:\APPL\OSYS065\For_FTP\TGLP.PERM.GLAT281.INPUT.SPPSU.DAT'  RECFM=F LRECL=80; MPRINT(JOBEXEC):   FILENAME INFL01 'D:\APPL\OSYS065\For_FTP\TGLP.PERM.GLAT281.INPUT.SPPSU.DAT' RECFM=F LRECL=80; 2560     +  FILENAME SPPSU  'D:\APPL\OSYS065\For_FTP\NEW.PERM.GLAT281.INPUT.SPPSU.DAT'   RECFM=F LRECL=80; MPRINT(JOBEXEC):   FILENAME SPPSU 'D:\APPL\OSYS065\For_FTP\NEW.PERM.GLAT281.INPUT.SPPSU.DAT' RECFM=F LRECL=80; 2561     + 2562     + 2563     +  /******************************************************************/   NOTE: PROCEDURE PRINTTO used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.01 seconds       memory              170.96k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        377  Switch Count  6         2564     +   DATA ACTV; MPRINT(JOBEXEC):   DATA ACTV; 2565     + 2566     +     INFILE INFL01 ENCODING='EBCDIC1047'; MPRINT(JOBEXEC):   INFILE INFL01 ENCODING='EBCDIC1047'; 2567     +     INPUT @   1 SPPSC        $5.   52                                                         The SAS System                           13:16 Monday, September 18, 2017   2568     +           @   7 TOKEN       $11. 2569     +           @  23 PSTATCD      $2. 2570     +           @  26 PSTATTP      $4. 2571     +           @  31 PUSED       PD3.1 2572     +           @  35 NEW         PD3.1; MPRINT(JOBEXEC):   INPUT @ 1 SPPSC $5. @ 7 TOKEN $11. @ 23 PSTATCD $2. @ 26 PSTATTP $4. @ 31 PUSED PD3.1 @ 35 NEW PD3.1; 2573     + 2574     + 2575     +     PUSED = PUSED + 1; MPRINT(JOBEXEC):   PUSED = PUSED + 1; 2576     + 2577     +%JOBprint(UNIT=21); MPRINT(JOBPRINT):   OPTION NOMPRINT NOSYMBOLGEN   NOTE: The infile INFL01 is:       Filename=D:\APPL\OSYS065\For_FTP\TGLP.PERM.GLAT281.INPUT.SPPSU.DAT,       RECFM=F,LRECL=80,File Size (bytes)=37920,       Last Modified=18Sep2017:10:35:52,       Create Time=18Sep2017:10:42:44   FATAL: Wide character FILE/INFILE/FILENAME options have been specified. Wide character support is not currently enabled. FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.ACTV may be incomplete. When this step was stopped there were 0 observations and 6 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              421.90k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        378  Switch Count  8         JOBprint INFO: Printed output redirected to i:\APPL_DATA\OSYS065\RPTlib\zOAC0486\D2017-09-18_Mon_13-16-43\S0001.zOAC0486f.FT21F001.txt   NOTE: PROCEDURE PRINTTO used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              54.12k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        379  Switch Count  12           NOTE: DATA statement used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.01 seconds       memory              221.37k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        380  Switch Count  0           53                                                         The SAS System                           13:16 Monday, September 18, 2017   2578     +PROC PRINT DATA=ACTV; 2579     + 2580      +  /******************************************************************/   NOTE: No observations in data set WORK.ACTV. NOTE: PROCEDURE PRINT used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              308.43k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        381  Switch Count  0         2581     +   DATA WRITFL; 2582     +     SET ACTV; 2583     + 2584     +     FILE SPPSU ENCODING='EBCDIC1047'; 2585     +     PUT @   1 'NWREC' 2586     +         @   7 TOKEN       $11. 2587     +         @  23 PSTATCD      $2. 2588     +         @  26 PSTATTP      $4. 2589     +         @  31 PUSED       PD3.1 2590     +         @  35 NEW         PD3.1; 2591     +/******************************************************************/ 2592     + 2593     +%JOBprint(UNIT=22);   NOTE: The file SPPSU is:       Filename=D:\APPL\OSYS065\For_FTP\NEW.PERM.GLAT281.INPUT.SPPSU.DAT,       RECFM=F,LRECL=80,File Size (bytes)=0,       Last Modified=18Sep2017:13:16:43,       Create Time=18Sep2017:12:48:58   FATAL: Wide character FILE/INFILE/FILENAME options have been specified. Wide character support is not currently enabled. FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.WRITFL may be incomplete. When this step was stopped there were 0 observations and 6 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       user cpu time       0.01 seconds       system cpu time     0.00 seconds       memory              554.37k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        382  Switch Count  8         JOBprint INFO: Printed output redirected to i:\APPL_DATA\OSYS065\RPTlib\zOAC0486\D2017-09-18_Mon_13-16-43\S0001.zOAC0486f.FT22F001.txt   NOTE: PROCEDURE PRINTTO used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              52.59k       OS Memory           19280.00k   54                                                         The SAS System                           13:16 Monday, September 18, 2017         Timestamp           09/18/2017 01:16:43 PM       Step Count                        383  Switch Count  12           NOTE: DATA statement used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              221.31k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        384  Switch Count  0         2594     +PROC PRINT DATA=WRITFL; NOTE: %INCLUDE (level 1) ending.   NOTE: No observations in data set WORK.WRITFL. NOTE: PROCEDURE PRINT used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              199.03k       OS Memory           19280.00k       Timestamp           09/18/2017 01:16:43 PM       Step Count                        385  Switch Count  0         JOBexec INFO: SASLOG assigned to i:\APPL_DATA\OSYS065\RPTlib\zOAC0486\D2017-09-18_Mon_13-16-43\SASLOG.log ... View more

Re: PROC SQL WINDOWS vs zOS - PARM DEGREE=ANY

by Fluorite | Level 6 in SAS Procedures
‎07-26-2017 02:28 PM
‎07-26-2017 02:28 PM
Addtl.   Based on some research PROC SQL appears to use these options to run multiple processes for a task: SAS PROC Guide - Threaded Processing Using PROC SQL  pg 218 Options that exist for parallelism. DBSLICEPARM THREADS CPUCOUNT   It also appears the DEGREE=ANY within z/OS DB2 provides the same benefit.  So a better question might be what options need to be set or turned on in z/OS SAS to enable SQL parallelism from a Windows SAS server workload ?   ... View more

PROC SQL WINDOWS vs zOS - PARM DEGREE=ANY

by Fluorite | Level 6 in SAS Procedures
‎07-26-2017 11:41 AM
‎07-26-2017 11:41 AM
I'm new as an Admin and I'm trying to assist our programming staff as they convert SAS running on z/OS to Windows using PROC SQL.  The backed DBMS is DB2 still running on z/OS.    z/OS - SAS 9.4   Windows 9.4.01   Where would I look for info on a PROC SQL parm  DEGREE=ANY and how to convert it?    On z/OS PROC SQL uses this parm apparently to great advantage (decreased elapsed time) vs Windows where so far we cant find an equivalent.  Since the SQL query is still running on z/OS DB2 we're still preplexed as to why Windows SAS wont accept the parm.    Any help would be appreciated.  Thx.   PROC SQL Stmt on z/OS    PROC SQL;                                         CONNECT TO DB2 (SSID=DSNP DEGREE=ANY);                            CREATE TABLE SPTRR AS      SELECT *      FROM CONNECTION TO DB2      (SELECT R.STAT_TRAN_ID_NR  AS TRANID,              DATE(R.ENTR_GP)    AS ENTRGP,              E.EFF_DT           AS EFFDT,              E.EXP_DT           AS EXPDT       FROM PROD.SPTRR R, PROD.SPENT E       WHERE R.STAT_TRAN_ID_NR  = E.STAT_TRAN_ID_NR    /*   AND R.ENTR_GP          > '2015-05-15-00.00.01.000001'  */         AND R.MSG_TYPE_CD      = 'I'         AND R.MSG_CATGR_CD     = 'M'         AND R.MSG_SUB_CATGR_CD = 'SR'         AND R.MSG_SEQ_CD       = '0032'         AND E.TYPE_CD          = 'LH'         AND E.EXP_DT           IS NULL         AND NOT EXISTS (SELECT 1                         FROM PROD.SPENR N                         WHERE E.STDNT_ACCT_ID_NR = N.STDNT_ACCT_ID_NR                           AND E.SCHL_NR          = N.SCHL_NR                           AND N.ENRL_END_DT      > E.EFF_DT)         AND NOT EXISTS (SELECT 1                         FROM PROD.LOAN L                         WHERE E.STDNT_ACCT_ID_NR = L.STDNT_ACCT_ID_NR                           AND L.TYPE_CD          = 'P')       FOR FETCH ONLY WITH UR); DISCONNECT FROM DB2; %PUT &SQLXRC &SQLXMSG;     PROC SQL Stmt on Windows    PROC SQL;                                                                  CONNECT TO DB2 (DATABASE=DSNPROD              user='APPL526'   password='---user pswd here---');        CREATE TABLE SPTRR AS      SELECT *      FROM CONNECTION TO DB2      (SELECT R.STAT_TRAN_ID_NR  AS TRANID,              DATE(R.ENTR_GP)    AS ENTRGP,              E.EFF_DT           AS EFFDT,              E.EXP_DT           AS EXPDT       FROM PROD.SPTRR R, PROD.SPENT E       WHERE R.STAT_TRAN_ID_NR  = E.STAT_TRAN_ID_NR    /*   AND R.ENTR_GP          > '2015-05-15-00.00.01.000001'  */         AND R.MSG_TYPE_CD      = 'I'         AND R.MSG_CATGR_CD     = 'M'         AND R.MSG_SUB_CATGR_CD = 'SR'         AND R.MSG_SEQ_CD       = '0032'         AND E.TYPE_CD          = 'LH'         AND E.EXP_DT           IS NULL         AND NOT EXISTS (SELECT 1                         FROM PROD.SPENR N                         WHERE E.STDNT_ACCT_ID_NR = N.STDNT_ACCT_ID_NR                           AND E.SCHL_NR          = N.SCHL_NR                           AND N.ENRL_END_DT      > E.EFF_DT)         AND NOT EXISTS (SELECT 1                         FROM PROD.LOAN L                         WHERE E.STDNT_ACCT_ID_NR = L.STDNT_ACCT_ID_NR                           AND L.TYPE_CD          = 'P')       FOR FETCH ONLY WITH UR); DISCONNECT FROM DB2; %PUT &SQLXRC &SQLXMSG; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-05-2019 04:20 PM
Quick links