HI! Thanks but I don't get all the observations processed in the array you sent out. I run this code: data two; set one; array a{5}; array v{5} _temporary_; if ty = 1 then do i = 1 to dim(a); v{i} = a{i}; end; i = input(scan(pid, -1, "A"), 2.); if i > 0 and i <= dim(v) then do; age = v{i}; output; end; keep id pid age; run; proc print data=two; var id pid age; run; This is the ouput I get: The SAS System 08:40 Monday, April 4, 2016 30 Obs id PID age 1 CT0121 CT0121A1 23 2 CT0121 CT0121A2 35 3 CT0121 CT0121A3 45 4 CT0121 CT0121A4 65 5 CT0200 CT0200A1 34 6 CT0200 CT0200A2 36 And I get the following from the log output: 383 384 data two; 385 set one; 386 array a{5}; 387 array v{5} _temporary_; 388 if ty = 1 then 389 do i = 1 to dim(a); 390 v{i} = a{i}; 391 end; 392 i = input(scan(pid, -1, "A"), 2.); 393 if i > 0 and i <= dim(v) then do; 394 age = v{i}; 395 output; 396 end; 397 keep id pid age; 398 run; NOTE: Invalid argument to function INPUT at line 392 column 5. id=NS10500 PID=NS10500A TY=1 a1=21 a2=23 a3=24 a4=25 a5=90 i=. age=. _ERROR_=1 _N_=7 NOTE: Invalid argument to function INPUT at line 392 column 5. id=NS10500 PID=NS10500A TY=2 a1=. a2=. a3=. a4=. a5=. i=. age=. _ERROR_=1 _N_=8 NOTE: Invalid argument to function INPUT at line 392 column 5. id=NS10500 PID=NS10500A TY=2 a1=. a2=. a3=. a4=. a5=. i=. age=. _ERROR_=1 _N_=9 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 3 at 392:5 NOTE: There were 9 observations read from the data set WORK.ONE. NOTE: The data set WORK.TWO has 6 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 399 400 proc print data=two; var id pid age; run; NOTE: There were 6 observations read from the data set WORK.TWO. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds I don't understand the error message about the INPUT Statement. Any suggestions? For some reason the last observations with a "NS" prefix are not included due to the error in the PUT statment. Thanks a lot!
... View more