.txt file to sas dataset

Reply
Contributor
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,

Ravi
Esteemed Advisor
Posts: 5,081

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.

/Linus
Data never sleeps
Valued Guide
Posts: 2,106

Re: .txt file to sas dataset

Ravi,

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.
Post a Question
Discussion Stats
  • 2 replies
  • 290 views
  • 0 likes
  • 3 in conversation