Dear all,
I currently have a huge dataset which looks like this:
Value 1 | value 2 | Value 3 | Value 4 | Value 5 |
OK | OK | NAME1 | . | OK |
OK | OK | NAME2 | Value2 | OK |
OK | OK | Value1 | OK | |
OK | OK | NAME2 | . | OK |
OK | OK | NAME3 | Value3 | OK |
OK | OK | NAME3 | Value3 | OK |
OK | OK | NAME1 | Value1 | OK |
OK | OK | NAME2 | . | OK |
... | ... | ... | ... | ... |
OK | OK | NAME3 | Value3 | OK |
In the end I would like to have something like this:
Value 1 | value 2 | Value 3 | Value 4 | Value 5 |
OK | OK | NAME1 | Value1 | OK |
OK | OK | NAME2 | Value2 | OK |
OK | OK | Value1 | OK | |
OK | OK | NAME2 | Value2 | OK |
OK | OK | NAME3 | Value3 | OK |
OK | OK | NAME3 | Value3 | OK |
OK | OK | NAME1 | Value1 | OK |
OK | OK | NAME2 | Value2 | OK |
... | ... | ... | ... | ... |
OK | OK | NAME3 | Value3 | OK |
I'm currently struggling with the code for this:
I have already the following datastep:
data &outlib..&outdsn.;
Set &outlib..&outdsn;
if missing (value_4) and not missing (value_3) then
do i=1 %to &vars_N.;
do until (not missing(value_4));
but then nothing works further.
Can anyone help me out?
Thanks a lot in advance.
Frederik
Post test data in the form of a datastep in a code window!!
As such I am not typing that in. Why should the third row be used to populate the first one? I can see no logical reason. Post something which actually reflects the problem. Now at a guess, what you can do is to first create a distinct list of Name + Value pairs which are not missing, then merge that back onto the data e.g:
proc sort data=have out=inter (rename=(value4=rep)) nodupkey; by value3 value4; where value3 ne "" and value4 ne ""; run; data want; merge have inter; by value3; if value4="" then value4=rep; 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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.