topic Re: Reading numeric varible from excel in SAS Programming

Reading numeric varible from excel

ari — Fri, 15 Jul 2016 10:56:06 GMT

Reading numeric variable with commas into SAS 9.4 version.

Re: Reading numeric varible from excel

RW9 — Fri, 15 Jul 2016 10:42:31 GMT

Your question is too vague. What software are you using, how are you importing the data, what do you want the output to look like, what does the comma refence in this instance as some countries use , as decimal place for example. If you just want to convert 18,5 to 18.5 do:

data want;
  set have;
  new_var=input(tranwrd(old_var,",","."),best.);
run;

Re: Reading numeric varible from excel

Ksharp — Sat, 16 Jul 2016 04:31:57 GMT

Try informat COMMAX.

Re: Reading numeric varible from excel

Ksharp — Sat, 16 Jul 2016 05:55:46 GMT


data want;
  old_var='8.123,44';
  new_var=input(old_var,commax32.);
  format new_var comma32.2;
run;