topic how can I find these values are numeric from a char variable in SAS Programming

how can I find these values are numeric from a char variable

Bal23 — Mon, 18 Jul 2016 17:21:40 GMT


 if  substr(icd, 1,3) in ( '0', '1', '2', '3', '4', '5', '6', '7', '8', '9') then num ="Y";else num ="N";

my code does not work

any ideas on how to modify?

Thanks

Re: how can I find these values are numeric from a char variable

GreggB — Mon, 18 Jul 2016 17:38:44 GMT

Have you run PROC CONTENTS?

Re: how can I find these values are numeric from a char variable

Quentin — Mon, 18 Jul 2016 17:39:13 GMT

I haven't used it, but perhaps NOTDIGT() is a possibility:

184  data _null_;
185    input text $;
186    if notdigit(trim(text))=0 then num="Y";
187    else num="N";
188    put (text num)(=);
189    cards;

text=hello num=N
text=123 num=Y
text=1 num=Y
text=4,321 num=N
text=1.5 num=N
text=m1m num=N

196  ;
197  run;

I think that should work, nof by numeric you mean contains only numbers. As shown above, characters such as comma or decimal point are considered non-numeric.

Kind Regards,

--Q.

Re: how can I find these values are numeric from a char variable

Astounding — Mon, 18 Jul 2016 17:43:09 GMT

Clearly, this code will rarely work. It examines the first three characters in your variable to specifically see if the first character is a digit and the second and third characters are both blanks. I doubt that is what you wanted to accomplish.

What did you want to accomplish? You will have to explain it in words, rather than show code that doesn't work.

Re: how can I find these values are numeric from a char variable

Bal23 — Mon, 18 Jul 2016 17:47:02 GMT

you are right, i found this problem and fixed it thanks