topic Re: Calculating a new column in SAS Enterprise Guide

Calculating a new column

Mairam2345 — Sat, 28 Apr 2018 13:42:01 GMT

Hello,

I have a table of transaction data with a lot of different customer names in alphanumeric. Now i want to convert those names in a numeric variable.

I would like to have the following conversion:

Trans1. Customer A -> 1

Trans2. Customer B -> 2

Trans3. Customer C-> 3

Trans4. Customer A-> 1

Is that possible? Can you help me pls.

Thanks and regards,
Mariam

Re: Calculating a new column

SuryaKiran — Sat, 28 Apr 2018 14:12:25 GMT

You can sort the data by group and then use FIRST. to assign a value to that group.

data have;
input cust $;
datalines;
A
B
B
C
A
B
C
;
proc sort data=have;
by cust;
data want;
set have;
by cust;
if first.cust then ID+1;
run;

Re: Calculating a new column

mnjtrana — Mon, 30 Apr 2018 13:28:21 GMT

Hi- If i understood correctly, you have specific values that needs to be changed to numeric .

In the below code, you are checking for specific values for names and assigning new_val variable to numeric values as you mentioned.

data need;
set have;

if name in("Trans1. Customer A" ,"Trans4. Customer A") then new_val = 1;

else if name in("Trans2. Customer B"0 then new_val = 2;

else if name in("Trans3. Customer C"0 then new_val = 3;
run;