Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 8201
Location: East Dubuque, Illinois, USA

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 ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts CA Intertest Batch 555shanth CA Products 0 Tue Nov 28, 2017 11:10 am
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us