DATA Step, Macro, Functions and more

re: Update Variables

Accepted Solution Solved
Reply
Regular Contributor
Posts: 248
Accepted Solution

re: Update Variables

Hi....I am trying to update the missing entries for the variables Status, Program Division for each StudentID based on the entries from the corresponding variables where the Term is the same or previous Term which is the closest to the Term with the missing entries. Any suggestions would be appreciated. Thanks.

 

data list9999;
    length StudentID 8 Status $ 8 Program $ 18 Division $ 12 Term 8;
    format StudentID BEST12. Status $CHAR8. Program $CHAR18. Division $CHAR12. Term BEST12.;
    informat StudentID BEST12. Status $CHAR8. Program $CHAR18. Division $CHAR12. Term BEST12.;
    infile datalines4 DLM='7F'x missover dsd;
    input StudentID : BEST32. Status : $CHAR8. Program : $CHAR18. Division : $CHAR12. Term : BEST32.;
datalines4;
100068  AutoBodyRepairs CC3LRSD 46
100068  AutoBodyRepairs CC3LRSD 48
100068 ADMITTED IndustrialWelding CC4PostSec 67
100068 ADMITTED IndustrialWelding CC4PostSec 68
100068 ADMITTED IndustrialWelding CC4PostSec 69
100068 ADMITTED IndustrialWelding CC4PostSec 70
100068 ADMITTED IndustrialWelding CC4PostSec 71
100068   72
100068   73
100068   74
;;;;

 

Want:

 

StudentID

Status

Program

Division

Term

100068

 

AutoBodyRepairs

CC3LRSD

46

100068

 

AutoBodyRepairs

CC3LRSD

48

100068

ADMITTED

IndustrialWelding

CC4PostSec

67

100068

ADMITTED

IndustrialWelding

CC4PostSec

68

100068

ADMITTED

IndustrialWelding

CC4PostSec

69

100068

ADMITTED

IndustrialWelding

CC4PostSec

70

100068

ADMITTED

IndustrialWelding

CC4PostSec

71

100068

ADMITTED

IndustrialWelding

CC4PostSec

72

100068

ADMITTED

IndustrialWelding

CC4PostSec

73

100068

ADMITTED

IndustrialWelding

CC4PostSec

74

 

 

 

 

 

 

       

 

 

   

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
   

 

   

Accepted Solutions
Solution
‎03-09-2018 08:54 PM
Super User
Posts: 2,499

Re: re: Update Variables

Like this?


data WANT;
  set HAVE;
  if STATUS  ^=' ' then PREV_STATUS  =STATUS ;
  if PROGRAM ^=' ' then PREV_PROGRAM =PROGRAM ; 
  if DIVISION^=' ' then PREV_DIVISION=DIVISION; 
  retain PREV: ;
  if STATUS  =' ' and lag(STUDENTID)=STUDENTID then STATUS  =PREV_STATUS;
  if PROGRAM =' ' and lag(STUDENTID)=STUDENTID then PROGRAM =PREV_PROGRAM;
  if DIVISION=' ' and lag(STUDENTID)=STUDENTID then DIVISION=PREV_DIVISION;
run;

 

View solution in original post


All Replies
Solution
‎03-09-2018 08:54 PM
Super User
Posts: 2,499

Re: re: Update Variables

Like this?


data WANT;
  set HAVE;
  if STATUS  ^=' ' then PREV_STATUS  =STATUS ;
  if PROGRAM ^=' ' then PREV_PROGRAM =PROGRAM ; 
  if DIVISION^=' ' then PREV_DIVISION=DIVISION; 
  retain PREV: ;
  if STATUS  =' ' and lag(STUDENTID)=STUDENTID then STATUS  =PREV_STATUS;
  if PROGRAM =' ' and lag(STUDENTID)=STUDENTID then PROGRAM =PREV_PROGRAM;
  if DIVISION=' ' and lag(STUDENTID)=STUDENTID then DIVISION=PREV_DIVISION;
run;

 

Regular Contributor
Posts: 248

Re: re: Update Variables

Hi Chris....Yes this was very helpful...thanks

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 121 views
  • 0 likes
  • 2 in conversation