topic Re: External .TXT file in SAS Procedures

External .TXT file

Thomaz — Thu, 10 Dec 2015 17:13:05 GMT

I am having a hard time reading external data from a .TXT file. I used to do that easily using other SAS versions.

The program is shown below:

filename YaraCASA '/folders/myfolders/YaraCASA.txt' lrecl=2000;

data YaraCASA;

infile YaraCASA missover;

input COLETA HORA TRATAM MACHO MOTTOT MOTPROG DAP DCL DSL VAP VCL VSL STR LIN WOB ALH BCF TRDSL TRVSL TRWOB LOGLIN;

PROC GLM;

CLASS COLETA TRATAM HORA MACHO;

MODEL MOTTOT = TRATAM MACHO(TRATAM) HORA COLETA COLETA*TRATAM HORA*TRATAM;

RANDOM MACHO(TRATAM) / TEST;

LSMEANS TRATAM HORA*TRATAM / STDERR PDIFF;

RUN;

The error message I get follows next:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 filename YaraCASA '/folders/myfolders/YaraCASA.txt' lrecl=2000;

57 data YaraCASA;

58 infile YaraCASA missover;

59 input COLETA HORA TRATAM MACHO MOTTOT MOTPROG DAP DCL DSL VAP VCL VSL STR LIN WOB ALH BCF TRDSL TRVSL TRWOB LOGLIN;

NOTE: The infile YARACASA is:

Filename=/folders/myfolders/YaraCASA.txt,

Owner Name=sasdemo,Group Name=sas,

Access Permission=-rw-rw-r--,

Last Modified=10 de dezembro de 2015 14h24min40s,

File Size (bytes)=30467

NOTE: Invalid data for COLETA in line 1 1-102.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

Re: External .TXT file

Reeza — Thu, 10 Dec 2015 17:18:48 GMT

Your code looks correct, it looks like an issue with your input statement. Have you tried a standard proc import to see what it generates?

Re: External .TXT file

ballardw — Thu, 10 Dec 2015 17:42:39 GMT

Without the complete error message I am guessing that you have text data in a variable that should be numeric from the datastep code that you posted.

If the text appears to be a column heading you might just need to add firstobs=2 to the infile statement.

If the source of the data has changed the content then you may have to have a discussion about the field type with the provider.

Re: External .TXT file

Thomaz — Fri, 11 Dec 2015 10:47:24 GMT

I tried inserting the firstobs=2 in trhe infile statement. I did not help much. A more complete error message is below. Any help on that would be deeply appreciated.

NOTE: The infile YARACASA is:

Filename=/folders/myfolders/YaraCASA.txt,

Owner Name=sasdemo,Group Name=sas,

Access Permission=-rw-rw-r--,

File Size (bytes)=30467

NOTE: Invalid data for COLETA in line 2 1-103.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

2 CHAR 1.0.1.82.56.73.36.99.21.50.43.42.15.94.45.00.90.91.33.38.0.73.0.36.0.49.2.56.33.24.0.13.0.18.0.02.-0

ZONE 3030303303323303323303323303323303323303323303323303323303233032330323303233033233032330323303233023

NUMR 19091982956E73936E99921E50943E42915E94945E00990E91933E3890E7390E3690E4992E56933E2490E1390E1890E029D0

101 .44 103

COLETA=. HORA=. TRATAM=. MACHO=. MOTTOT=. MOTPROG=. DAP=. DCL=. DSL=. VAP=. VCL=. VSL=. STR=. LIN=. WOB=. ALH=. BCF=. TRDSL=.

TRVSL=. TRWOB=. LOGLIN=. _ERROR_=1 _N_=1

NOTE: Invalid data for COLETA in line 3 1-104

Re: External .TXT file

Reeza — Fri, 11 Dec 2015 11:42:48 GMT

It looks like you might have a period/decimal as your delimiter. Try adding dlm='.' To your infile statement. You may also want to change missover to truncover.

Re: External .TXT file

Thomaz — Fri, 11 Dec 2015 12:51:40 GMT

Weel, I tried this one, but it did not work either,

Erro message below:

filename YaraCASA '/folders/myfolders/YaraCASA.txt' lrecl=2000;

data YaraCASA;

infile YaraCASA dlm='.' truncover;

input COLETA HORA TRATAM MACHO MOTTOT MOTPROG DAP DCL DSL VAP VCL VSL STR LIN WOB ALH BCF TRDSL TRVSL TRWOB LOGLIN;

NOTE: The infile YARACASA is:

Filename=/folders/myfolders/YaraCASA.txt,

Owner Name=sasdemo,Group Name=sas,

Access Permission=-rw-rw-r--,

File Size (bytes)=30467

NOTE: Invalid data for COLETA in line 1 1-11.

NOTE: Invalid data for HORA in line 1 13-16.

NOTE: Invalid data for TRATAM in line 1 18-22.

NOTE: Invalid data for MACHO in line 1 24-28.

NOTE: Invalid data for MOTTOT in line 1 30-34.

NOTE: Invalid data for MOTPROG in line 1 36-40.

NOTE: Invalid data for DAP in line 1 42-46.

NOTE: Invalid data for DCL in line 1 48-52.

NOTE: Invalid data for DSL in line 1 54-57.

NOTE: Invalid data for VAP in line 1 59-62.

NOTE: Invalid data for VCL in line 1 64-67.

NOTE: Invalid data for VSL in line 1 69-72.

NOTE: Invalid data for STR in line 1 74-78.

NOTE: Invalid data for LIN in line 1 80-83.

NOTE: Invalid data for WOB in line 1 85-88.

NOTE: Invalid data for ALH in line 1 90-93.

NOTE: Invalid data for BCF in line 1 95-99.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

1 CHAR 1.0.1.81.23.19.9.77.16.64.35.14.11.85.35.27.74.22.25.20.0.71.0.34.0.48.2.29.33.98.0.11.0.16.0.02.-0.

ZONE 3030303303323303233033233033233033233033233033233033233032330323303233032330332330323303233032330232

NUMR 19091981923E1999E77916E64935E14911E85935E27974E22925E2090E7190E3490E4892E29933E9890E1190E1690E029D0E

101 47 102

COLETA=. HORA=. TRATAM=. MACHO=. MOTTOT=. MOTPROG=. DAP=. DCL=. DSL=. VAP=. VCL=. VSL=. STR=. LIN=. WOB=. ALH=. BCF=. TRDSL=47

TRVSL=. TRWOB=. LOGLIN=. _ERROR_=1 _N_=1

Re: External .TXT file

Reeza — Fri, 11 Dec 2015 15:22:50 GMT

Post a sample of your file

Re: External .TXT file

FreelanceReinh — Fri, 11 Dec 2015 23:13:35 GMT

As far as I can tell from the "ZONE" and "NUMR" lines shown in your log, this is a tab-delimited file. So, you should use dlm='09'x instead of dlm='.'.

(The dots replacing non-printable characters in the "CHAR" line can be misleading at times.)

Re: External .TXT file

Thomaz — Mon, 14 Dec 2015 10:52:59 GMT

Hi,

The dlm='09'x worked!!!

Thanks a lot.