Hi Forum,
Could anyone help me to undestand the red colored piece of this code?
/*Sorting in preparation for "By-group processing" - I understand this */
PROC SORT DATA=A;
BY ID_NUM;
run;
/*By-group processing- I understand this */
DATA A1 A2;
SET A ;
BY ID_NUM;
RETAIN LOAN_RECEIVER 0;
IF FIRST.ID_NUM THEN LOAN_RECEIVER = 1;
IF LOAN_RECEIVER = 1 THEN OUTPUT A1;
ELSE IF LOAN_RECEIVER = 2 THEN OUTPUT A2;
RUN;
Q:
LOAN_RECEIVER + 1; is the Sum statement (not sum function) which returns accumulated total, am I correct?
Thanks
Miris
Miris,
The LOAN_RECEIVER + 1; statement is just equivalent to LOAN_RECEIVER = LOAN_RECEIVER + 1;, except for two side effects that are implied by LOAN_RECEIVER being the target of the sum statement. First, LOAN_RECEIVER value is RETAINed from one iteration to the next, second, LOAN_RECEIVER is initialized with zero.
So, you see, the statement RETAIN LOAN_RECEIVER 0; is not needed at all, as both statement's effects are already implied. Try removing it. you should see no change.
PG
Yes you are correct.The retain statement is unnecessary since variables in a sum statement are retained by default.
Miris,
The LOAN_RECEIVER + 1; statement is just equivalent to LOAN_RECEIVER = LOAN_RECEIVER + 1;, except for two side effects that are implied by LOAN_RECEIVER being the target of the sum statement. First, LOAN_RECEIVER value is RETAINed from one iteration to the next, second, LOAN_RECEIVER is initialized with zero.
So, you see, the statement RETAIN LOAN_RECEIVER 0; is not needed at all, as both statement's effects are already implied. Try removing it. you should see no change.
PG
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.