topic Re: Dummy variable in SAS Programming

Dummy variable

CathyVI — Wed, 16 Feb 2022 16:49:14 GMT

Hello,
I have dummy variable Var1 and Var2.
How will I remove the 2 in R862 so as to have R86 and R86 in both Var1 and Var2.
I will like to do this for all the unmatched e.g. C23 and C2357, E89 and E8996 etc. I have over 10,000 encounters my dataset with this issue.

Fname Lname Firstname Lastname Var1 Var2
John Doe John Do J124 J124
Pat Cut Patt Cot jr C23 C2357
Riley Jo Sr Rilly Joo R862 R86
Ellen Mee Elen Meey Sr. E89 E8996

Re: Dummy variable

Reeza — Wed, 16 Feb 2022 16:53:01 GMT

Please provide more details.
For starters, if that was your input what do you want as output.

Re: Dummy variable

CathyVI — Wed, 16 Feb 2022 16:59:44 GMT

@Reeza I want my output to be matched result for the two dummy variables. I will like to remove the extra numbers from each row. This is want I want my output to looks like.

Var1 Var2

J124 J124

C23 C23

R86 R86

E89 E89

Re: Dummy variable

Reeza — Wed, 16 Feb 2022 17:05:49 GMT

Check the lengths of each variable and whichever is the smaller, use that and assign it to both variables.

Something like this perhaps:

if length(var1) < length(var2) then var2=var1;
else var1=var2;