topic Reading unstructured text file into sas in SAS Programming

Reading unstructured text file into sas

sg_kr — Mon, 12 Feb 2024 15:38:23 GMT

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

Re: Reading unstructured text file into sas

Ksharp — Tue, 13 Feb 2024 04:40:39 GMT

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;

Re: Reading unstructured text file into sas

sg_kr — Tue, 13 Feb 2024 06:12:21 GMT

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

Re: Reading unstructured text file into sas

Ksharp — Tue, 13 Feb 2024 09:24:15 GMT

/*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;