Reading a txt file into SAS?

Mirisage — Wed, 28 Mar 2012 17:13:16 GMT

Hi Community,

"Bank number","Start date","Branch number","Person name", “Balance", and so on…….

(note that names of some variables are having spaces)

Each record of descriptor portion is also found as a continuous string as follows, seperated by commas.

77,22/2/2011 0:00:00,6,"JOHN JOSEPH", and so on……

First of all, I need to run some descriptive statistics in SAS and get some feel about the data set.

I have given the following command to read the data set in SAS.

data test;

infile 'H:\Model_Building\data.txt' firstobs=2 dlm='09'x dsd;

input

Bank number Current date Branch number Short name Balance ........

;

Run;

My question

Help is highly appreciated.

Thank you

Mirisage

sassharp — Wed, 28 Mar 2012 19:19:31 GMT

It might be helpful to you

Re: Reading a txt file into SAS?

sassharp — Wed, 28 Mar 2012 19:50:32 GMT

Would you try like this

proc import datafile='H:\Model_Building\data.txt' dbms=dlm out=work.test replace;

delimiter=",";

getnames=yes;

guessingrows=500;

run;

Mirisage — Thu, 29 Mar 2012 19:09:22 GMT

Hi SASSHARP,

Thank you very much.

Mirisage