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!!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.