Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How do I match Information from one datset to other txt files?

How do I match Information from one datset to other txt files?

How do I match Information from one datset to other txt files?

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.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close