11-06-2013 10:37 PM
I have a dataset;
create table test as
I need to assign an Id to the variables
input cat_id 1 cat_desc $2-20;
1 Eastern Region
2 Western Region
How can I add the cat_id in data have and apply it to the initial dataset?
11-07-2013 01:26 AM
Can you tell me that in your data 'have' what you have shown in datalines is your desired output or you want to display regions eg. eastern region by 1?(just for display : Go for Proc Format).
11-07-2013 01:52 PM
For example if proc sql you see cat_desc Eastern Region. However it has not cat_id. Now look in data have. I have replicated the cat_des and have added the cat_id. I need to assign cat_id to cat_desc so I can use the original proc sql datastep in a program to manipulate the variables