Hi,
I have a simple problem to solve, 'dy' variable has samevalue for an entire section however it is missing in few rows under each section. I would like to copy the blanks with 'dy' value of that section. How can we do that without writing any loops in a simple code line. Please advise.
data test ; input section dy ; datalines; 1 . 1 . 1 . 1 33 1 33 1 33 1 33 1 . 1 . 1 . 2 44 2 44 2 44 2 . 2 . 2 . 2 44 2 44 ; run;
section | dy | desired_dy |
1 | . | 33 |
1 | . | 33 |
1 | . | 33 |
1 | 33 | 33 |
1 | 33 | 33 |
1 | 33 | 33 |
1 | 33 | 33 |
1 | 33 | |
1 | 33 | |
1 | 33 | |
2 | 44 | 44 |
2 | 44 | 44 |
2 | 44 | 44 |
2 | . | 44 |
2 | . | 44 |
2 | . | 44 |
2 | 44 | 44 |
2 | 44 | 44 |
Thank you
data test ;
input section dy ;
datalines;
1 .
1 .
1 .
1 33
1 33
1 33
1 33
1 .
1 .
1 .
2 44
2 44
2 44
2 .
2 .
2 .
2 44
2 44
;
run;
proc sort data=test;
by section descending dy ;
run;
data want;
update test(obs=0) test;
by section;
output;
run;
data test ;
input section dy ;
datalines;
1 .
1 .
1 .
1 33
1 33
1 33
1 33
1 .
1 .
1 .
2 44
2 44
2 44
2 .
2 .
2 .
2 44
2 44
;
run;
data want;
merge test test(rename=(dy=desired_dy) where=(desired_dy ne .));
by section;
run;
data test ;
input section dy ;
datalines;
1 .
1 .
1 .
1 33
1 33
1 33
1 33
1 .
1 .
1 .
2 44
2 44
2 44
2 .
2 .
2 .
2 44
2 44
;
run;
proc sort data=test;
by section descending dy ;
run;
data want;
update test(obs=0) test;
by section;
output;
run;
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 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.