I have a text file with the below format. patient_id|desc 1|active 34|closed 33|joined on 23-apr-12 patient|01JAN2011|3 The first row is a header variable. The last row is a trailer with the file name, date the text file was sent and the record count. I have loaded the data into a sas dataset. In that process , I also want to check if the record count in the trailer matches with the data that gets loaded into the sas dataset. I skip the trailer record when I load my data into the patient sas dataset. If i could incorporate this logic into a macro and read the macro into the main sas job that loads the data into a dataset, it would be better. I need to do this check on 7 files. Please advise as I am a beginner in sas and never used macros....
... View more
