topic .txt file to sas dataset in SAS Health and Life Sciences

.txt file to sas dataset

SSN_Ravi — Tue, 24 Aug 2010 06:52:15 GMT

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

Re: .txt file to sas dataset

LinusH — Tue, 24 Aug 2010 07:46:09 GMT

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

Re: .txt file to sas dataset

Doc_Duke — Tue, 24 Aug 2010 12:38:30 GMT

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.