topic Re: Set two dataset with if condition in SAS Programming

Set two dataset with if condition

TristanTang — Thu, 24 May 2018 07:28:33 GMT

An example program is followed. i am wondering why the last observation in dataset C had a value of 'B' in the column OUTCOME?

Thank you all!!

DATA A;

INPUT OBS $ OUTCOME $;
CARDS;
1 A
2 B
;
RUN;

DATA B;
INPUT OBS $ RESULT $;
CARDS;
1 1
2 2
3 .
;
RUN;
DATA C;
SET A(IN = A) B(IN = B);
IF A THEN DATASET = 'A';
IF B THEN DO;
DATASET = 'B';
IF RESULT = '1' THEN OUTCOME = 'A';
ELSE IF RESULT = '2' THEN OUTCOME = 'B';
END;
RUN;

Re: Set two dataset with if condition

Kurt_Bremser — Thu, 24 May 2018 08:05:10 GMT

First, keep in mind that all variables in datasets named in a set (or merge) statement are automatically retained.

So, when the second dataset B is being read, outcome will always be retained from the previous iteration of the data step.

Since the next-to-last observation in B has a result of '2', outcome is set to 'B'; In the last observation, result is missing, so none of the conditons in the do/end block is met, and outcome stays at value 'B'.

BTW stop coding in uppercase-only. Interpreters and compilers understand lowercase since the 60's, and it makes code easier to read.

Re: Set two dataset with if condition

TristanTang — Thu, 24 May 2018 08:24:27 GMT

Thanks for the answer.

For me, uppercase is easier to read. Anyway, thank you for your suggestion!!