topic Re: Sub setting the data set in SAS Programming

Sub setting the data set

PravinMishra — Sun, 23 Oct 2016 13:30:02 GMT

I am trying below code to subset the but not getting result as expected.

DATA A;
INFILE DATALINES DSD DLM=' ';
INPUT A B;
DATALINES;
1 1
1 2
1 3
1 4
1 5
1 6
1 7
;
RUN;
DATA X Y;
SET A;
IF A=1 AND B IN (1,2,3) THEN OUTPUT X;
IF A=1 AND B IN (4,5,6,7) THEN OUTPUT Y;
RUN;

expected result:

Data set X:

1 1
1 2
1 3

Data set Y:
1 4
1 5
1 6
1 7

can anyone please let me know where I am doing wrong.

Re: Sub setting the data set

Kurt_Bremser — Sun, 23 Oct 2016 14:45:51 GMT

Take a look at dataset a, if it really looks as expected.

Next, inspect the log of both steps; if that does not give you a clue, post the log and the list outputs of both datasets.

Re: Sub setting the data set

Astounding — Sun, 23 Oct 2016 17:10:59 GMT

Your expectations are right on the money.

Many times, the board can diagnose the error with no help ... no log, no PROC PRINT results, no PROC CONTENTS results. Unfortunately, this is not one of those times. If you didn't get what you expected, you may have to show what the results actually were.

Re: Sub setting the data set

ballardw — Mon, 24 Oct 2016 14:36:17 GMT

When I run your code as posted I get exactly the desired result posted.

If your unexpected result is coming from a larger different data set A or the logic is more complex then that could be the diffrence. If you expect an output record everytime variable A=1 it may be that variable B has unexpected values such as missing or out of range of the exact values placed in the IN operator arguement.