Reading unstructured text file into sas

[sg_kr]

Hi ,

i have to read an unstructured data from a text file to SAS dataset 

raw data like below:

Description AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

assakndsklfdsfpsdskmcs'kfdskfnsd'vkmsdv;ls vlksnfdks'fjdsoifnsonvs;lnsohfsnskjfhso;fskfjslfks';fljslkfjs;lfjslkfj;lksfjslkfjos;kufoeisocnds;ojvnoriecnwiocns

fhdsiupfhwfnsdpcmdwpofwecmsd'lkvnpsfmspcns[oijsncspncdsvnsnccd

accountno  date current_balance credit debit total_bal

*********************************************************

1111 01/02/2000 100 20 40 80

2222 01/02/2000 10 20 30 0

2222 02/02/2000 40 10 2 48

accountno  date current_balance credit debit total_bal

*********************************************************

1111 01/02/2000 100 20 40 80

2222 01/02/2000 10 20 30 0

222202/02/20004010248

accountno  date current_balance credit debit total_bal

*********************************************************

1111 01/02/2000 100 20 40 80

2222 01/02/2000 10 20 30 0

222202/02/20004010248

accountno  date current_balance credit debit total_bal

*********************************************************

1111 01/02/2000 100 20 40 80

2222 01/02/2000 10 20 30 0

222202/02/20004010248

Output---

i want dataset to be with the following columns

accountno  date current_balance credit debit total_bal

kindly please help us on this

also i have attached the file as well

[Ksharp · Accepted solution]

filename x 'c:\temp\test.txt' encoding='utf8' termstr=crlf;
data have;
infile x  dlm='09'x dsd;
input @;
if anydigit(_infile_) ne 1 then delete;
input (accountno  date current_balance credit debit total_bal) (: $40.);
run;

[sg_kr]

thanks for the response, just want to know about the two input statements in the data step.

and how to deal if my columns names are two words like account no, instead of accountno

[Ksharp]

/*OK. Using liternal name syntax.*/

option validvarname=any;  *Make sure variable name could contain blanks;
filename x 'c:\temp\test.txt' encoding='utf8' termstr=crlf;
data have;
infile x  dlm='09'x dsd;
input @;
if anydigit(_infile_) ne 1 then delete;
input ('account no'n  date current_balance credit debit total_bal) (: $40.);
run;