Link to home
Start Free TrialLog in
Avatar of labradorchik
labradorchikFlag for United States of America

asked on

How to verify number of files received as well as records in each ASCII pipe-delimited file by using tally files in SAS?

Hi everyone,

I am trying to verify number of files received as well as records in each ASCII pipe-delimited file (file<electronic_company><electronic_device>.txt) by using its associated tally file (file<electronic_company><electronic_device>tally.csv) in SAS?  

ASCII pipe-delimited file (file<electronic_company><electronic_device>.txt) - each files contains 100s of records
Associated tally file (file<electronic_company><electronic_device>tally.csv) - contains a total record number of records in each associated ASCII pipe-delimited file

I have already done the same verification in Bash scripting in Unix but my assumption is the number of files verification can be also done in SAS as well as the number of records verification in each pipe-delimited file can be accomplished by reading each tally file (file<electronic_company><electronic_device>tally.csv) that is associated with each file (file<electronic_company><electronic_device>.txt) received.  Does anyone know what is the best practice in SAS verifiyng number of files and number of records in each file?  
Any suggestions/examples would be greatly appreciated.

Thank you!
Avatar of Bill Prew
Bill Prew
I haven't worked in SAS in "forever" so can't help you myself, but if you don't get any solutions here on EE you might want to post on a SAS specific forum (if you haven't already).  It looks like this one is sanctioned by SAS and provides a place for more technical / programming questions.


And while it may be seen as a competitor to EE, there is some SAS activity on this site as well that you could try if you don't get help here.


»bp
Avatar of labradorchik
labradorchik
Flag of United States of America image

ASKER

Hi Bill,

Thank you very much for your suggestions!
I also checked out SAS forums as well but still did not find a correct way to approach this problem.
Avatar of Bill Prew
Bill Prew
That's too bad, sorry I couldn't be of more help.  If you do get a solution on your own please post back onto this question for future reference.

»bp
ASKER CERTIFIED SOLUTION
Avatar of labradorchik
labradorchik
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial