Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I have data in a text file that contains a large number of variables. Is there any alternative to writing a lengthy INPUT statement?

April 26, 2017alternative Data file large lengthy text variables writing

0

Posted

I have data in a text file that contains a large number of variables. Is there any alternative to writing a lengthy INPUT statement?

1 Answer

0

Posted

SAS can read Excel 4 worksheets (but not Excel workbooks). It is often easier to simply import a text file into Excel, save the data as an Excel 4 worksheet, and then go into SAS and use the Import Data option under the File menu.