Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need a sample batch SAS pgm, flat file in, accum totals out

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
View previous topic :: :: View next topic  
Author Message
dkaster

New User


Joined: 21 Mar 2011
Posts: 2
Location: USA

PostPosted: Fri Mar 25, 2011 9:44 pm    Post subject: Need a sample batch SAS pgm, flat file in, accum totals out
Reply with quote

I need to verify record counts and accum totals on fields is a series of mainframe flat files, and all I have available is SAS. I'm able to print and accum an entire file, but only want and need to see the bottom line (not the millions of individual records). I've been through "dummies", but it (and the SAS site) only covers the online app and statistics. Can anyone help??
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7993
Location: Bellevue, IA

PostPosted: Fri Mar 25, 2011 10:40 pm    Post subject:
Reply with quote

Code:
DATA _NULL_;
     INFILE DDIN END=EOF;
     INPUT ;
     NRECS + 1;
     IF  EOF
     THEN DO;
          FILE PRINT;
          PUT 'RECORD COUNT = ' NRECS COMMA10.;
          END;
Use _NULL_ to not create a SAS data set. DDIN is the DD name for the input file. If you just want a count, don't input any variables but if you need field counts, change the INPUT statement appropriately. The END= sets a variable to TRUE when the end of the input file is reached.
Back to top
View user's profile Send private message
dkaster

New User


Joined: 21 Mar 2011
Posts: 2
Location: USA

PostPosted: Sat Mar 26, 2011 2:55 am    Post subject: Reply to: Need a sample batch SAS pgm, flat file in, accum t
Reply with quote

Great, just what I needed - thanks!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Batch job tunning sgandhla Testing & Performance analysis 0 Fri Mar 24, 2017 9:41 pm
No new posts Getting sum on Totals and Adjusted to... balaji81_k DB2 3 Fri Mar 24, 2017 7:51 pm
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 1 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 3 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us