Page 1 of 1

How to count no. of records based on a condition?

Posted: Fri Jul 19, 2013 12:21 pm
by Sachin Kumar
Hi,

I want to count number of records from a huge file based on condition. The file has got some records with, say 'AAAAA' at position 10. I want to count only those records. How to do it? LRECL of file is 80 and RECFM is FB.

Re: How to count no. of records based on a condition?

Posted: Fri Jul 19, 2013 4:37 pm
by Robert Sample
1. Use Sort to an output dummy file and manually look at the sort output count.
2. Use SAS or EASYTRIEVE if installed at your site
3. Write a program in the language of your choice

There are other ways depending upon the specifics of the file and the site, but three should give you a way to proceed.