DATA Step, Macro, Functions and more

Sub setting the data set

Reply
Contributor
Posts: 60

Sub setting the data set

Hi 

 

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.

Super User
Posts: 6,977

Re: Sub setting the data set

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 5,099

Re: Sub setting the data set

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.

Super User
Posts: 10,550

Re: Sub setting the data set

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.

 

Ask a Question
Discussion stats
  • 3 replies
  • 211 views
  • 0 likes
  • 4 in conversation