topic Re: Regarding concatenate in SAS Data Science

Regarding concatenate

anilgvdbm — Tue, 06 Jan 2015 06:58:00 GMT

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

Re: Regarding concatenate

stat_sas — Tue, 06 Jan 2015 07:16:49 GMT

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;

Re: Regarding concatenate

RW9 — Tue, 06 Jan 2015 09:46:48 GMT

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;

Re: Regarding concatenate

Ksharp — Tue, 06 Jan 2015 10:16:33 GMT

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

Re: Regarding concatenate

anilgvdbm — Tue, 06 Jan 2015 11:06:15 GMT

Hi Xia Keshan,

It is correct method thank for the help...

thank you all for your suggestions..

Regards,

Anil

Re: Regarding concatenate

Reeza — Tue, 06 Jan 2015 14:29:35 GMT

Please mark as answered