topic Re: non numeric to replace 0 in SAS Programming

non numeric to replace 0

rohitkrishna — Tue, 22 Sep 2020 07:32:50 GMT

Hi All,

i have one issue regarding the sas code in my data have licnum it contains sum non numeric values like . $ A so i want to substitute the non numeric values to 0 plz kindly share the solution for the below issue

{

data licnum;

infile datalines;

input @1 licno 10.;

datalines;

12..994432

980..e221..

;

run;

data numchg;

set licnum;

if licno = . then licno = 0;

run;

kindly give sum solution for the above issue and mainly it's a sasmainframe

Thanks $ Regards

Rohit

Re: non numeric to replace 0

jklaverstijn — Tue, 22 Sep 2020 07:51:18 GMT

Your code is not wrong. You just use one of the many possible ways of mapping a missing to 0. These are a few other options:

data licnum;
infile datalines;
input @1 licno 10.;
/* Alternatives. Use one. */
licno = coalesce(licno, 0);
licno = sum(licno, 0);
if licno = . then licno = 0;
...

Hope this helps.

-- Jan.

Re: non numeric to replace 0

rohitkrishna — Tue, 22 Sep 2020 08:04:07 GMT

Hi jklaverstijn
thanks for the quick replay
but i got some issue wt you posted, below error i got kindly look it once
LICNO = COALESCE(LICNO, 0);
________
________
________
68
68
68
OR 68-185: The function COALESCE is unknown, or cannot be accessed. kindly plz give some solution for that one
Thanks & Regard
Rohit

Re: non numeric to replace 0

Kurt_Bremser — Tue, 22 Sep 2020 08:48:07 GMT

Please do always (as in

ALWAYS!

) post the whole log of a step, and do always (as in

ALWAYS!

) use this button for posting logs:

We always ask this not because we're extremely bored, but because only whole logs help in diagnosing problems, and the </> window keeps the log as it is, without destroying the formatting.

Re: non numeric to replace 0

ChrisNZ — Tue, 22 Sep 2020 08:48:25 GMT

You must have a very old SAS version. Use one of the other suggestions.

Re: non numeric to replace 0

rohitkrishna — Tue, 22 Sep 2020 10:08:56 GMT

HI KurtBremser,
Thanks for the Replay & sorry for what i posted, in the hurry manner i posted the hard code kindly ignore the mistake and give some of the solution above issue
Thanks & Regards
Rohit

Re: non numeric to replace 0

jklaverstijn — Tue, 22 Sep 2020 10:34:22 GMT

You already have more than one solution. If COALESCE() doesn't work for you, use one of the other suggested methods:

Either:

LICNO = SUM(LICNO, 0);

Or:

if LICNO = . then LICNO=0;

You can put that in straight after the INPUT statement. No need for a second data step;

Hope this helps,

- Jan.

Re: non numeric to replace 0

rohitkrishna — Tue, 22 Sep 2020 11:12:22 GMT

Hi jklaverstijn
Thanks for the quick response you're code working good but my expected o/p was not yet came i will share the log code
< DATA NEWLIC;
INFILE DATALINES;
INPUT @1 LICNO $10.;
IF LICNO = . THEN LICNO = 4;
DATALINES;
203....412
...3300421
9955..032.
;
RUN;
PROC PRINT DATA = NEWLIC;
RUN;
>
below the output i got
+++++++++++++++++++++++

Obs LICNO

1 4
2 4
3 4
+++++++++++++++++++++++++++++
but my expected output was
2030000412
0003300421
9955000320
i want to substitute non numeric to 0 like above . is the non numeric so i replaced with 0 in manual way kindly share some some solution for above one
Thanks & Regards
Rohit

Re: non numeric to replace 0

PaigeMiller — Tue, 22 Sep 2020 11:16:29 GMT

Please share the log in the window that appears when you click on the </> icon, as requested

Re: non numeric to replace 0

jklaverstijn — Tue, 22 Sep 2020 11:51:47 GMT

Please do not change the code halfway without explanation. By reading using a character informat ($10. instead of 10.) you just changed the data type from numeric to character and any proposed solution may be all of sudden not applicable.