Reading a TAB delimited file



Read an external file into a SAS data set when the variables in the external file are separated with a TAB character. Note:   On ASCII systems (PC, UNIX, MAC, VMS) the hex representation of a TAB character is '09'x. On EBCDIC systems (VM, MVS, VSE) the hex representation of a TAB is '05'x.

data _null_;

  file 'c:\temp\tabdlm.txt';

  put "Samuel B. Thompson" '09'x "04/28/1995" '09'x "Raleigh";

  put "Suzy B. Thomspon" '09'x "5/1/1993" '09'x "Wake Forest";

run;



data info;

  infile 'c:\temp\tabdlm.txt' DSD dlm='09'x truncover;

  input name :$30. DOB :mmddyy8. city :$20.;

run;



proc print;

  format dob mmddyy8.; run;