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.
How to count no. of records based on a condition?
-
- Registered Member
- Posts: 24
- Joined: Wed Jul 17, 2013 9:08 am
- Robert Sample
- Global Moderator
- Posts: 1903
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: How to count no. of records based on a condition?
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.
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.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute