.txt file to sas dataset

Posts: 21

.txt file to sas dataset

Hi All,

Pl help me to read the .txt tile to sas as a dataset using sas or unix.

.txt file contains sas reports like listing or summary table.

Thanks in advance,

Super User
Posts: 5,876

Re: .txt file to sas dataset

To achieve this your are into some serious data step programming.
If possible, it would be much easier if you could lay your hands on the data the reports are based on.

Data never sleeps
Trusted Advisor
Posts: 2,124

Re: .txt file to sas dataset


I agree with Linus. It can be done, but it is a lot of tedious data step programming.

If you have to do it, here are some things that you need to learn about:.

The biggest is pointer control in the INPUT statement. It allows you to align the pointer with the data that you want to use.

You may also need to do a lot with the various index functions (INDEXC, etc.) and SUBSTR.

Good luck.
Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation