topic Re: Need a solution for programming part to get a output in SAS Programming

Need a solution for programming part to get a output

mounikag — Fri, 24 Jul 2020 18:27:10 GMT

Hi All,

I need help in programming part. I have dataset :

Dataset:

Obs Subject ADY Avisitn Avalc

1 101 86 12 PR

2 101 186 17 PD

3 101 257 24 PR

4 101 327 29 PR

5 101 382 32 PR

6 102 76 14 PR

7 102 128 17 CR

8 102 188 24 CR

9 102 253 29 CR

I need a output these way:

Obs Subject ADY Avisitn Avalc

1 101 86 12 PR

2 101 186 17 PD

3 101 257 24 PR

5 101 382 32 PR

6 102 76 14 PR

7 102 128 17 CR

9 102 253 29 CR

So i dont need 4th and 8 th observation in the output. I am trying to use lag function but its not working properly. Could you please send me the piece of code to get the same output as above. Thanks in Advance.

Re: Need a solution for programming part to get a output

LeonidBatkhan — Fri, 24 Jul 2020 18:46:53 GMT

Hi mounikag,

If you need to throw out some observations by their numbers, you can do it this way:

data WANT;
   set HAVE;
   if _n_ in (4,8) then delete;
run;

Hope this helps.

Re: Need a solution for programming part to get a output

mounikag — Fri, 24 Jul 2020 18:53:33 GMT

Hi Leonid,

Thanks for your reply . I can't delete by using the observations because i have like 1000 of observations . Sorry if you misunderstood my question . If data has three immediate consecutive avalc values it should display first and last aval . So i mean if the data has

DAta:

So i should get the output has :

Re: Need a solution for programming part to get a output

Shmuel — Fri, 24 Jul 2020 23:38:15 GMT

Try next code:

data want;
 set have;
    by subject Avalc notsorted ;
        if  first.avalc or last.avalc then output;
run;

Re: Need a solution for programming part to get a output

ballardw — Fri, 24 Jul 2020 20:27:37 GMT

@mounikag wrote:

Hi All,

I need help in programming part. I have dataset :

Dataset:

Obs Subject ADY Avisitn Avalc

1 101 86 12 PR

2 101 186 17 PD

3 101 257 24 PR

4 101 327 29 PR

5 101 382 32 PR

6 102 76 14 PR

7 102 128 17 CR

8 102 188 24 CR

9 102 253 29 CR

I need a output these way:

Obs Subject ADY Avisitn Avalc

1 101 86 12 PR

2 101 186 17 PD

3 101 257 24 PR

5 101 382 32 PR

6 102 76 14 PR

7 102 128 17 CR

9 102 253 29 CR

So i dont need 4th and 8 th observation in the output. I am trying to use lag function but its not working properly. Could you please send me the piece of code to get the same output as above. Thanks in Advance.

What is the RULE involved with why the 4th and 8th observation are to be removed? A value? A combination of values? A count of rows within subject? You just don't like 4 and 8? A specific value on the previous row?

It is very easy to create a solution that will remove those two specific records but that quick and easy solution is almost certainly not going to work for a general case in data sets with 1000's of records where you want to remove 100's of records.

Re: Need a solution for programming part to get a output

mounikag — Mon, 27 Jul 2020 21:40:54 GMT

Hi Shmuel,

Your response is helpful. Thanks.

Regards,
Mounika