DATA Step, Macro, Functions and more

Filling in Missing Data with known values

Accepted Solution Solved
Reply
Super Contributor
Posts: 286
Accepted Solution

Filling in Missing Data with known values

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;


Accepted Solutions
Solution
‎06-05-2018 08:45 AM
Respected Advisor
Posts: 3,000

Re: Filling in Missing Data with known values

UNTESTED CODE

 

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

View solution in original post


All Replies
Solution
‎06-05-2018 08:45 AM
Respected Advisor
Posts: 3,000

Re: Filling in Missing Data with known values

UNTESTED CODE

 

data want;
    set have;
    retain session1;
    if not missing(session) then session1=session;
run;
--
Paige Miller
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 100 views
  • 0 likes
  • 2 in conversation