Filling in Missing Data with known values

GreggB — Tue, 05 Jun 2018 12:40:12 GMT

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;

Re: Filling in Missing Data with known values

PaigeMiller — Tue, 05 Jun 2018 12:42:34 GMT

UNTESTED CODE

data want;
    set have;
    retain session1;
    if not missing(session) then session1=session;
run;

topic Re: Filling in Missing Data with known values in SAS Programming

Filling in Missing Data with known values

Re: Filling in Missing Data with known values