topic Re: How to convert format from character to numeric variable in SAS Studio

How to convert format from character to numeric variable

ydu180 — Sun, 09 Jul 2017 16:01:24 GMT

proc sort data=hw4.demographic
          out=work.demographic;
   by ID;
run;

proc sort data=hw4.survey2
          out=work.survey2;
   by ID;
run;

data work.demo2_ydu18;
   merge work.demographic work.survey2;
   by ID;
run;

ID in demographic is character and in survey2 is numeric. I want to merge those two data set, could anyone tell how to convert one of those type. I tried ID=input(ID, 3.0); in demographic but it did not work.

Re: How to convert format from character to numeric variable

art297 — Sun, 09 Jul 2017 16:14:47 GMT

data demographic;
  input id $;
  cards;
1
2
3
;

data demographic (drop=_id);
  set demographic (rename=(id=_id));
  id=input(_id,3.);
run;

Art, CEO, AnalystFinder.com

Re: How to convert format from character to numeric variable

ydu180 — Sun, 09 Jul 2017 17:12:59 GMT

Thank you, it works.