Dear All,
I have a question regarding concatenating the household id and member id for my own research data.
that data looks like this
Household_ID | Member_ID |
IAP13B0291 | 5 |
IAP13B0291 | 209 |
IAP13B0293 | 4ca |
IAP13B0293 | 10 |
IAP13B0293 | 201 |
IAP13B0293 | 204 |
IAP13B0293 | 2 |
IAP13B0293 | 9 |
IAP13B0294 | 8 |
if i will merge both i need to add 2 zeroes in front of 5 in 1st observation and 2nd observation i dont want to add please suggest me which function i have to use????
thanks
Anil
data have; input Household_ID : $20. Member_ID $; cards; IAP13B0291 5 IAP13B0291 209 IAP13B0293 4ca IAP13B0293 10 IAP13B0293 201 IAP13B0293 204 IAP13B0293 2 IAP13B0293 9 IAP13B0294 8 ; run; data want; set have; length new $ 3; new=Member_ID; new=translate(right(new),'0',' '); run;
Xia Keshan
If I understood this correctly then this can provide the desired output.
data want;
set have;
if _n_<3 then new_id=cats(Household_ID,'00',Member_ID);
else new_id=cats(Household_ID,Member_ID);
run;
It looks to me as if at least one record has only two characters that "00" cat to would not solve (10). I would suggest a padding algorithm, principally as the id is alpha-numeric (if it was numeric you could use z. format).
data have;
length household_id member_id $200;
Household_ID="IAP13B0291"; Member_ID="5"; output;
Household_ID="IAP13B0291"; Member_ID="209"; output;
Household_ID="IAP13B0293"; Member_ID="4ca"; output;
run;
data want;
set have;
if length(strip(member_id))=3 then household_id=cats(household_id,member_id);
else household_id=cats(household_id,repeat('0',2-length(strip(member_id))),strip(member_id));
run;
data have; input Household_ID : $20. Member_ID $; cards; IAP13B0291 5 IAP13B0291 209 IAP13B0293 4ca IAP13B0293 10 IAP13B0293 201 IAP13B0293 204 IAP13B0293 2 IAP13B0293 9 IAP13B0294 8 ; run; data want; set have; length new $ 3; new=Member_ID; new=translate(right(new),'0',' '); run;
Xia Keshan
Hi Xia Keshan,
It is correct method thank for the help...
thank you all for your suggestions..
Regards,
Anil
Please mark as answered
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.