topic Re: convert categorical factor elements variable to numeric. in New SAS User

convert categorical factor elements variable to numeric.

Mo2018 — Tue, 11 Dec 2018 06:46:55 GMT

Hello,

I have a data the has three columns like this:

col1 col2 col3

1 2 F

2 10 P

3 8 P

4 5 F

5 10 P

Is there a way to convert the third column to 1 and 0 in SAS. I mean like this

col1 col2 col3

1 2 0

2 10 1

3 8 1

4 5 0

5 10 1

Thank you

learsaas — Tue, 11 Dec 2018 07:21:05 GMT

RW9 — Tue, 11 Dec 2018 09:05:58 GMT

data want (drop=old);
  set have (rename=(col3=old));
  col3=ifn(old="F",0,1);
run;