Oh you solved me another question. Since I only set some of variables in length statement, the order of variables in the output dataset is not the same as the original one. ... View more

Thank you I will try. ... View more

I am so sorry that the data is confidential. I could only keep the form of the data. I am not sure whether you could accept it. Actually I found a way to solve my problem yesterday to some extend. That means I use excel to change the format of character variables. For example let "Diagnosis" become "D:Diagnosis". Then I will know when to read this variable. However, when testing my code, I found although there is "N:" before "Complication" variable of the 5th observation, sas does not read it into sas data set. Below is my code: ***Reading from Text file; data PatientInfo;       length Diagnosi $ 100           /*Procedur $ 10000*/           Anesthet $ 20   Complica $ 100   Notes $ 50   ;       infile 'F:\Patient Info.txt' delimiter = '09'x MISSOVER truncover DSD lrecl=32767 firstobs=2 obs=10;       input                 PatienID                 DOB           DOS                 @'D:' Diagnosi $   /*@'P:' Procedur $*/                 @'A:' Anesthet $                 PACUIn                 PACUOut                 Discharg                 @'C:' Complica $                 @'N:' Notes $      ; run; proc print data=PatientInfo; run; ... View more

Thank you SOOOOOO much for your advice. I am posting the data now. Sorry to confuse you, this is my first question in the community.:smileyblush: ... View more