my data set :
student session test_date grade
able 1 nov 30 11
baker nov 30 11
charlie nov 30 12
delta 2 nov 30 10
echo nov 30 12
foxtrot nov 30 11
what I want:
student session test_date grade
able 1 nov 30 11
baker 1 nov 30 11
charlie 1 nov 30 12
delta 2 nov 30 10
echo 2 nov 30 12
foxtrot 2 nov 30 11
I found this code in a previous post but don't know how to apply it:
%macro process(variable);
retain help_&variable;
if not missing(&variable)
then _&variable = &variable;
else &variable = _&variable;
drop _&variable;
%mend;
data want;
set have;
%process(sex)
%process(country)
%process(period)
run;
UNTESTED CODE
data want;
set have;
retain session1;
if not missing(session) then session1=session;
run;
UNTESTED CODE
data want;
set have;
retain session1;
if not missing(session) then session1=session;
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.