This should do the job data HCA_file (drop = fil); infile " " ; input fil :$1 @ ; if fil = "H" then input #1 @3 Id :$6. State :$4. ; if fil = "C" then input Dates :date9. Transaction :dollar6.2 ; retain ID state Date; if dates = . then delete; format Dates date9.; run; data HCA_file (drop = fil); infile " " ; input fil :$1 @; if fil = "H" then input Id :$6. State :$4. DOB :date9.; if fil ="C" then delete; format dob date9.; run;
... View more