hi everyone, I have got a weird txt files with only 1 column, like: id variable value 01,sex,1 23,mat,N 78,contin,2 34,age,29 01, job,2 06,mat,Y 78,sex,2 ... ... So this txt files with numerous lines shows each variable for each id one by one, which means each id will show up many times for different variables. For example, the first line is saying the sex of 01, the 5th line is saying race of 01 and so forth... Could anybody help me how to import this kind of txt file into sas (shown below)? id sex mat contin job age ... .... 01 02 ... 78 ... 1000 Thank you so much!
... View more