import external file with data step

Satori — Fri, 06 Jan 2023 13:48:52 GMT

my code:

data bvd.ac
infile '/data/bvd/ac/financials_and_ratios.txt' dlm='09'x missover dsd lrecl=32767 firstobs=2 truncover;
input
ID $12.
Code $2.
Filing_type $21.
Closing_date :yymmdd10.
Number_of_months $2.
Audit_status $1.

run;

my error:

data bvd.ac
infile '/data/bvd/AcademicsSample/Industry-Global_financials_and_ratios.txt' dlm='09'x missover dsd lrecl=32767 firstobs=2 truncover;
_ _
22 22
200 200
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.

ERROR 200-322: The symbol is not recognized and will be ignored.

what am I doing wrong?

Re: import external file with data step

Kurt_Bremser — Fri, 06 Jan 2023 13:53:49 GMT

The DATA statement misses the terminating semicolon, so the INFILE statement appears to the compiler as part of the DATA statement.

topic Re: import external file with data step in SAS Programming

import external file with data step

Re: import external file with data step