From USGJEL@langate.gsu.edu Fri Mar 3 11:26:32 2000 Date: Fri, 03 Mar 2000 11:21:21 -0500 From: Jane Leonard To: dscbms@panther.Gsu.EDU Subject: Re: TAB-delimited input to SAS Brian, No problem. You can use a delimiter statement: Tabs are usually a hex 05, DATA XX ; INFILE INX DELIMITER='05'X MISSOVER ; INPUT VAR1-VAR4 ; PROC PRINT; The only problem that I ever had is if there were two missing values in a row, such as tab, tab together. Then sas did not read properly, so I did something like the following in the MVS editor first, and saved the new file. change all '05'x ' | ' This changed all tabs to a "space, pipe, space, and then all worked fine, and I then used the pipe for the delimiter in the sas program. 00001 //STEP1 EXEC SAS 000002 //INX DD DSN=USGJEL.SAS.CNTL(COMMADAT),DISP=SHR 000003 DATA XX ; INFILE INX DELIMITER='|' MISSOVER ; 000004 INPUT VAR1-VAR4 ; 000005 PROC PRINT; 000006 /* 000007 SAMPLE DATA: 000008 1|2|3|4 000009 2|3|4|5 000010 4|5|7|8 Call if I have truly confused you now. Jane >>> "Brian M. Schott" 03/01 3:38 PM >>> Jane, Is there an easy way to read ascii data that is separated by TABs? (B=)