topic Re: categorize a variable in SAS Programming

categorize a variable

sahoositaram555 — Tue, 10 Aug 2021 20:25:21 GMT

Hi users,

I've 2 columns in my data.

data a;

input var1 $20 var2 $80;

cards;

cardio xxxxxxxxxxxxxxxxxxxxx

cardio yyyyyyyyyyyyyyybbbbbbb

derma yyyyyyyyyyyyyyyyyyyyy

derma yyyyyyyyyxxxxxxxxzzzzz

derma rrrrrrrrrrrrrryyyyyyyyuuuuuu

derma yyyyyyyyyyyyyyyyyyyyyuuu

neuro jjjjjjjjjjjuuuuuuuuuuuyyyyyyyy

neuro eeeeeeeeeeeeeetttttttttttyyyyy

neuro mmmmmrrrrrrrrrrrrrrrrtttttttttttt

mental_health zzzzzzzzzzzzzzzzzzz

;

run;

I want to categorize cardio to 1 and derma to 2 and subsequently to others. so a new column must appear where for each value of cardio must have 1. how to do this

Re: categorize a variable

Reeza — Tue, 10 Aug 2021 20:28:32 GMT

data want;
set a;

if var1 = 'cardio' then cardio=1;
else cardio=0;

if var1='derma' then derma=1;
else derma=0;

if var1 = 'cardio' then disease_code = 1;
else if var1 = 'derma' then disease_code=2;
else disease_code = 99;
run;

If you just want to enumerate the diseases then do this:

proc sort data=a;
by var1;
run;

data want;
set a;
retain disease_code 0;
if first.var1 then disease_code+1;
run;

@sahoositaram555 wrote:

Hi users,

I've 2 columns in my data.

data a;

input var1 $20 var2 $80;

cards;

cardio xxxxxxxxxxxxxxxxxxxxx

cardio yyyyyyyyyyyyyyybbbbbbb

derma yyyyyyyyyyyyyyyyyyyyy

derma yyyyyyyyyxxxxxxxxzzzzz

derma rrrrrrrrrrrrrryyyyyyyyuuuuuu

derma yyyyyyyyyyyyyyyyyyyyyuuu

neuro jjjjjjjjjjjuuuuuuuuuuuyyyyyyyy

neuro eeeeeeeeeeeeeetttttttttttyyyyy

neuro mmmmmrrrrrrrrrrrrrrrrtttttttttttt

mental_health zzzzzzzzzzzzzzzzzzz

;

run;

I want to categorize cardio to 1 and derma to 2 and subsequently to others. so a new column must appear where for each value of cardio must have 1. how to do this

Re: categorize a variable

AKHILA — Wed, 11 Aug 2021 04:59:11 GMT

Hope this will helps:

proc sort data=a;
by var1;
run;
data want;
set a;
by var1;
retain ord;
if first.var1 then ord+1;

run;