There are 45 companies and several employee 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
In my SAS library I have, 90 datasets (name ends with unique code) 2 dataset for each company containing department and hiring information.
names of the text files are in following format:
Dep_code and Hinfo_code
ex Dept_AA11, Hinfo_AA11 (datasets containing Department and hiring information for each Employee id)
I have third dataset in SAS named Test which contains Employee id and company code.
Now In this dataset, I have to look company code for each Employee id and company code, then need to select the 2 datasets containing Dept and Hiring info from the library ending with the matching code and then create a report containing both the Department and Hiring info.
i.e. from the dataset, check the company code for each employee id , and then select 2 department and hiring datasets for the matching company code and match the employee id, get the Department and hiring info and create the report.
I am new to sas..How should I start.
Any suggesstion is appreciated.
Thanks,
sasuser
... View more