There are 45 companies and several employees works in each company.
Each company has its unique code
EX: AA11, AA12..so on
Each emp has a unique id in 16 digit numeric format
Now at a particular location, I have 45 folders for each company (starts with unique code) and each folder contains 2 text file containing department and hiring information.
names of the text files are in following format:
code_Dep and code_Hinfo
ex AA11_Depl, AA11_Hinfo (files containing Department and hiring information for each Employee id)

I have a dataset in sas which contains Employee id and company code.
Now I have to look company code for each Employee id and company code, then need to go to the  location and select the 2 text file from the folder and then create a report containing both the Department and Horing info.
i.e. from the dataset, check the company code for each employee id ,  and then select the 2 text files from the matching company's  folder from the particular location  and match the employee id,  get the Department and hiring info and create the report.

I am thinking of creating 90 datasets by manually importing dep and Hinfo file for 45 companiesand then from the existing dataset  check the company code for each employee id and create the report.
Is this approach okay...how should I select the matching  txt files/datasets for employee id.

Thanks,
Blyssz