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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.