topic Univariate- commas to decimals in SAS Procedures

Univariate- commas to decimals

JanetJanbek — Fri, 24 Aug 2018 13:37:48 GMT

Hi,

I have a dataset with a variable that contains some numbers as "x.y" and others as "x,y".. and I would like to do a univariate analysis on that variable, but sas categorizes the ones with a comma in between as missing. I tried to convert the commas with Commax and comma and numx and nothing seems to Work! Also tried locale but that doesnt make a difference. Please help 🙂 What can be done?

Thanks in advance!

Janet

My variable's name is s_result (it's a character and I converted it to numeric). The code is as such:

data dist2; set dist (rename=(s_result=s_result_char));

s_result=input(s_result_char, best.);

proc univariate; VAR s_result;

run;

Re: Univariate- commas to decimals

RW9 — Fri, 24 Aug 2018 13:49:39 GMT

Use a conditional input:

data dist2; 
  set dist (rename=(s_result=s_result_char));
  if index(s_result_char,",") then s_result=input(s_result_char,comma.);
  else s_result=input(s_result_char,best.);
run;

proc univariate; 
  var s_result;
run;

Note not tested as no test data in the form of a datastep.

Re: Univariate- commas to decimals

JanetJanbek — Fri, 24 Aug 2018 14:02:03 GMT

Thank you SO much. Worked!! 🙂

Re: Univariate- commas to decimals

FreelanceReinh — Fri, 24 Aug 2018 16:30:18 GMT

@JanetJanbek: Please wait. It's possible that your code ran without error messages, but used incorrect values! The COMMA. informat would not treat commas as decimal points. Better use NUMX. and compare the results.

Edit: Moreover, the COMMA and COMMAX informats have a default length of 1 (not 12 as NUMX.). So, without a length specification (e.g. COMMAX12.) they would read only the first character of the input string.