Thank you for the codes didn't quite work but I was able to mod it from there to get what I want it strip the R from my id, which I need to keep, but did put the correct value for BLK. thanks again
... View more
No, the missing data does not have any pattern, every then and there Yes, the related variable always have the same prefix except R or R1, R2, R3, etc. at the end, mostly just R thank you
... View more
id BLK AF120 0.02 AF120R BD111 0.5 BD111R in the above question I want to replace the missing BLK observation with the BLK of the related id what would be the syntax in sas 9.4? e.g. BLK value for AF120R eq to that of AF120, 0.02, and so on.
... View more
