I am taking a long dataset (repeated measures) some have 2 timepoints of data - some do not. When I use the following code to transpose the variables of interest to a wide dataset something his happening that is not transcribing values within a record. Whenever the observation has a record for time1 and time 2 - the first (time1) is entered as missing when there is a value in existence.   dataset I have timestamp    client    age    gender    PCLscore  CDRISCscore 4/08/22          xx        49     female         57                 15 4/14/22          xx        49     female         52                 17 5/12/22          xy        47     female         51                 31 5/02/22          zz        46     male            51                 27 5/13/22          zz        46     male            46                 24   what I get; client   age   gender    timestamp1  timestamp2 PCLscore1  PCLscore2 CDRISCscore1    CDRISCscore3 xx        49     female              .          4/14/22               .                  52                     .                         17 xy        47     female        5/12/ 22          .                   51                 .                      31                         . zz        46     male                .             5/13/22              .                 46                      .                        24     current code; DATA eHome12_Match_&V ; SET eHome11_Match_&V ; BY client ; KEEP client age gender timestamp1-timestamp2 PCL_Rscore1-PCL_Rscore2 CDRISC_Rscore1-CDRISC_Rscore2 PCS1-PCS2 MCS1-MCS2; RETAIN client age gender ; ARRAY adate(1:2) timestamp1-timestamp2; ARRAY apcs(1:2) PCS1-PCS2; ARRAY amcs(1:2) MCS1-MCS2; ARRAY acdrisc(1:2) CDRISC_Rscore1-CDRISC_Rscore2; ARRAY apcl(1:2) PCL_Rscore1-PCL_Rscore2; IF first.client THEN DO; DO i = 1 to 2 ; adate( i ) = . ; acdrisc( i ) = . ; apcs( i ) = .; amcs( i ) = . ; apcl( i ) = . ; END; END; adate( time ) = timestamp ; acdrisc( time ) = CDRISC_RScore ; aPCL( time ) = PCL_RScore ; aPCS( time ) = PCS ; aMCS( time ) = MCS ; IF last.client THEN OUTPUT ; format timestamp1-timestamp2 mmddyy10.; RUN; ... View more

I have 2 datasets, 1 that is a key and what that is survey data. I am trying to pull the value associated with 2 variables and match with the combination of 2 variables across 6 total pairs. "key" dataset row 0 1 2 3 1 0 .11 .25 .43 2 0 .32 .75 1.29 3 0 .64 1.5 2.57 4 0 1.07 2.5 4.29   Datafile (survey data) P1 P1a P2 P2a P3 P3a P4 P4a 1 1 2 3 3 4 1 2 2 3 3 1 2 3 2 4 3 1 0 . 1 3 3 4   the intersection of the row and column values for the "key" dataset match to the unique combination for P1 and P1a ---P4 and P4a in the "datafile", where the column value in "key" indicates the P"x" lookup value and the row value in "key" indicates the P"Xa" value to create a new variable PX1 for the new value for each record within the dataset.  result would yield PX1 PX2 PX3 PX4 (*in key table, over 1 (P1) and down 1 (P1a)) =0.11 1.5 4.29 .32 1.5 .32 1.5 2.5 .43 0 0.64 4.29 ... View more