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;
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.
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.
Thanks for the answer.
For me, uppercase is easier to read. Anyway, thank you for your suggestion!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.