Infile statement to import a specific worksheet

sks521 — Tue, 10 Sep 2019 13:57:51 GMT

Hi folks,

How do I use infile statement to bring in data from a worksheet please?

Thanks

Re: Infile statement to import a specific worksheet

ballardw — Tue, 10 Sep 2019 14:12:15 GMT

@sks521 wrote:

Hi folks,

How do I use infile statement to bring in data from a worksheet please?

Thanks

Actually INFILE is not intended to work with spreadsheets. It is intended to read text files either fixed column, delimited, named input or some combination thereof.

If you want control over how data is read then export your worksheet (File > SaveAs) to a CSV file and use an infile statement pointing to that file to read.

topic Re: Infile statement to import a specific worksheet in SAS Programming

Infile statement to import a specific worksheet

Re: Infile statement to import a specific worksheet