IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Proc print in Mainframe


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Aleem S

New User


Joined: 11 Nov 2020
Posts: 3
Location: india

PostPosted: Wed Nov 11, 2020 9:01 pm
Reply with quote

HI Guys,

First of all I don't know SAS and currently we have SAS job running in Mainframe. I'm trying to print the dataset which has 100+ fields but it's not populating as expected.

Current O/P:

Obs 1 Field1 ........................ field8
2 field1 ......................... field8
.
'
'
Obs 1 field9 ....................... field15
2 field9 ....................... field15

Expected:

Obs1 field1 ....................................................... field15
2 field1 ..................................................... field15

i'm using the below command:
proc print data=rawdata.correct ;

Could someone please help me
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1255
Location: Bamberg, Germany

PostPosted: Wed Nov 11, 2020 10:09 pm
Reply with quote

What do you expect when not showing to us what the proc looks like? icon_question.gif
Back to top
View user's profile Send private message
Aleem S

New User


Joined: 11 Nov 2020
Posts: 3
Location: india

PostPosted: Wed Nov 11, 2020 10:15 pm
Reply with quote

Please see below the proc,

Code:
//S01SAS EXEC WPS,
// PARM='SYSPARM="%LET IF_MV=MV;%LET XMAC=ANNUITY;%LET RAW=Y;
//                %LET MTHYR=OCT20;"'
//SASEXEC  DD DSN=SWDDEV.UICS.MACLIB.COMMON(AUTOEXEC),
//            DISP=SHR
//IN       DD DSN=SWDDEV.EOM20OCT.MAS001.ANNCURMV,DISP=SHR
//SASDATA  DD DSN=SWDDEV.SASLIB.ANNUITYV.B0801,DISP=OLD
//RAWDATA  DD DSN=SWDDEV.MV.SASDATA.B0507.NEW,DISP=OLD
//SASCAT   DD DSN=SWDDEV.UACTMAST.CPORT.ANNUITYV,DISP=OLD
//MVSUMEX  DD DSN=SWDDEV.REPORTS.MVSUMEX.B0507,DISP=OLD
//MVCONT1  DD DSN=SWDDEV.REPORTS.MVCONT1.B0507,DISP=OLD
//MVCONT2  DD DSN=SWDDEV.REPORTS.MVCONT2.B0507,DISP=OLD
//MVERROR  DD DSN=SWDDEV.REPORTS.MVERROR.B0507,DISP=OLD
//LIBRARY  DD DSN=SWDDEV.SASSACT.LIBRARY.SASLIB.B0507,DISP=SHR
//WORK     DD UNIT=SYSDA,SPACE=(CYL,(150,75))
//SASAUTOS DD DSN=SWDDEV.UICS.MACLIB.COMMON,DISP=SHR
//         DD DSN=SWDDEV.UICS.SASSACT.MACLIB.ANNUITY.REPORTS,
//            DISP=SHR
//         DD DSN=SWDDEV.ANN.UICS.PROD.SASSACT.MACLIB.ANNUITY,DISP=SHR
//         DD DSN=SWDDEV.ANN.UICS.PROD.SASSACT.MACLIB.COMMON,DISP=SHR
//         DD DSN=SWDDEV.UICS.PROD.SASSACT.MACLIB.COMMON,DISP=SHR
//SASLOG   DD SYSOUT=*
//SASLIST  DD DSN=SWD.DVAXS.STCSAS.OUT,
//            DISP=(OLD,CATLG,CATLG),UNIT=SYSDA,
//            SPACE=(CYL,(100,99),RLSE),
//            DCB=(RECFM=FB,LRECL=5000,BLKSIZE=0)



I have given the display statement here as follows,

Code:
***********************;
**** Output Record ****;
***********************;

output rawdata.correct;
put 'writing as expected:';
proc print data=rawdata.correct ;
%drop;


it's printing in O/p but not as the same record

Code:
********************************* Top of Data **********************************
  Obs    valdate POLNO        BKNO1 BKNO2       MOPNO        MOVECODE SUBCODE

     1 31OCT2020  xxxxxxxxxxxx  AN    999                        09      09    01
     2 31OCT2020  xxxxxxxxxxxx  AN    999                        09      09    01

Obs  NAME                     CLASS         MKRS1        MKRS2        MKRS3

   1 YYYYYYYYYYYY        XXX          528384            0            2
   2 YYYYYYYYYYYY        XXX         528384      8389120            0


Coded for you - next time do it yourself
Back to top
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 712
Location: Denmark

PostPosted: Thu Nov 12, 2020 2:32 pm
Reply with quote

Been a long time, but as I recall SAS will print like shown if a side-by-side print does not fit in a line. Again as I recall you can specify side-by-side and length of each item. My best suggestion is to read the manual.
Back to top
View user's profile Send private message
Aleem S

New User


Joined: 11 Nov 2020
Posts: 3
Location: india

PostPosted: Thu Nov 12, 2020 4:34 pm
Reply with quote

Thanks for your response.

Thanks,
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts JCL sortcard to print only the records DFSORT/ICETOOL 11
No new posts Mainframe Programmer with CICS Skill... Mainframe Jobs 0
No new posts How to Reformat a file using File Man... All Other Mainframe Topics 14
Search our Forums:

Back to Top