How to convert format from character to numeric variable

[ydu180]

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. 

[art297 · Accepted solution]

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

[ydu180]

Thank you, it works.