Hello all - new to this community- 1st question ever I have a fixed length data file of 18,000+ records (this will be known as File A) i have a fixed length data file of 83 records (this will be known as File B) My output file will need be a fixed length file of those same 18,000 records with a new variable added. File B only contains one field, and it is a variable number (1st observation is "72", 2nd is "144" etc...) this will change monthly. What I need is help with a program that will do this: I need to read the 1st observation of File B and store it's value - in this case "72" I need to then go back to file A and output the number of records stored from the 1st observation of File B (72) and add a new variable that contains sequential number...for example.1-0001 for File A Record # 1, 1-0002 for File A Record # 2 ...etc .. etc until I reach the last number that I got from File B (72) ... once I am there, I need to then read the 2nd Observation from File B (144), then repeat the above process of going back to File A and output that number of records with a variable that contains a 2nd number of "2-0001", 2-0002" etc etc. I have tried a few things with data sets, but I am not getting the 18,000 records to output. This is beyond what I've ever used SAS for, and I'm far from an expert in this language. Any help you could give would be appreciated. Tthanks in advance!
... View more