Your answer does solve the problem and thanks a lot for it sir. But I have few questions regarding this approah. First that SAS does solve this but with an error. As per the log: NOTE: LOST CARD.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
15 ;
id=. id1=. id2= _ERROR_=1 _N_=27
NOTE: SAS went to a new line when INPUT statement reached past the end of a line. What does it mean and why is it giving an error? Secondly, if we are using- if not missing(id) here then why isn't SAS stopped right after fourth row as the next id is not available. Why does it goes to 27th line. Third question is that I did use @@ when I was trying to solve it, but my laptop stopped working completely. My code didn't include if not missing(id) command though. So what's the reason for that and how is this command stopping this infinite loop kind of thing that crashed my laptop. And last is that if there was space in between the characters then I could had easily used @@ and it had worked but this one didn't have one. Is there a way where I can just use each next value as a new input. I mean to say making SAS believe that there is no delimiter and accept each value as into new next variable? It'll be great if you could answer these sir.
... View more