re: Update Variables

twildone — Fri, 09 Mar 2018 02:39:38 GMT

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

Re: re: Update Variables

ChrisNZ — Fri, 09 Mar 2018 03:35:18 GMT

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;

Re: re: Update Variables

twildone — Sat, 10 Mar 2018 01:53:53 GMT

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

topic Re: re: Update Variables in SAS Programming

re: Update Variables

Re: re: Update Variables

Re: re: Update Variables