topic Re: Can someone help on the follwing question un-unk-unky.... in SAS Programming

Can someone help on the follwing question un-unk-unky....

rajeshalwayswel — Tue, 31 Oct 2017 05:40:15 GMT

If data contains UN----it should replace with -----01

if data contains UNK------it should replace with -----jan

if data contains UN-UNK-UNKY------ it should be missing....

data have;
input dt $15.;
cards;
23-jan-2000
un-feb-2001
un-unk-2002
un-unk-unky
un-may-1999
un-mar-2002
un-unk-2010
run;

Required Output:

23-jan-2000
01-feb-2001
01-jan-2002

01-may-1999
01-mar-2002
01-jan-2010

Re: Can someone help on the follwing question un-unk-unky....

Shmuel — Tue, 31 Oct 2017 06:05:29 GMT

As UNKY contains UNK and the last contains UN,

I shall check from the longest to the shortest string:

data want;
 set have;
     dt = upcase(dt);        /* line added */
      i = index(dt,'UNKY');
     if i > 0 then dt= ' '; /* line was edited as dt is char type */
     else do;
         i = index(dt,'UNK');
         if i>0 then substr(dt,4,3) = 'jan';
         else do;
             i = index(dt,'UN');
             if i = 1 then substr(dt,1,2) = '01';
     end; end; 
run;

Re: Can someone help on the follwing question un-unk-unky....

Shmuel — Tue, 31 Oct 2017 05:54:09 GMT

You may need upcase dt.

Re: Can someone help on the follwing question un-unk-unky....

rajeshalwayswel — Tue, 31 Oct 2017 05:57:15 GMT

sorry it not working any other way just I ran in sas i'm getting exact what I said... Thanks for reply...

Re: Can someone help on the follwing question un-unk-unky....

Shmuel — Tue, 31 Oct 2017 06:02:11 GMT

Have you matched case writting:

If UN-UNK-UNKY in input are all lowcase check for un-unk-unky

or you can precede a line with dt=upcase(dt); before checking for UN-UNK-UNKY (in upper case letters).

Re: Can someone help on the follwing question un-unk-unky....

Shmuel — Tue, 31 Oct 2017 06:14:51 GMT

Alternatively you can do:

data want;
 set have;
       if substr(dt,1,2) = 'un' then
          substr(dt,1,2) = '01';

      if substr(dt,4,3) = 'unk' then
         substr(dt,4,3) = 'jan';

      if substr(dt,8.4) = 'unky' then dt = ' ';
run;

Re: Can someone help on the follwing question un-unk-unky....

Ksharp — Tue, 31 Oct 2017 14:21:17 GMT


data have;
input dt $15.;
dt=prxchange('s/\bun\b/01/',1,dt);
dt=prxchange('s/\bunk\b/jan/',1,dt);
want=input(dt,?? date11.);
format want date11.;
cards;
23-jan-2000
un-feb-2001
un-unk-2002
un-unk-unky
un-may-1999
un-mar-2002
un-unk-2010
;
run;

Re: Can someone help on the follwing question un-unk-unky....

rajeshalwayswel — Tue, 31 Oct 2017 17:07:47 GMT

Thanks it work's....

Re: Can someone help on the follwing question un-unk-unky....

rajeshalwayswel — Tue, 31 Oct 2017 17:33:18 GMT

can you please explain prxchange function I'm little bit confuse in it..

Re: Can someone help on the follwing question un-unk-unky....

Ksharp — Wed, 01 Nov 2017 13:08:24 GMT

Sorry . I have no time to explain PRXCHANGE(), search it at support.sas.com

Here '\b' stand for the boundary of a word.