topic Urgent help for importing txt format data into SAS in SAS Programming

Urgent help for importing txt format data into SAS

QLi — Wed, 28 Apr 2010 13:54:04 GMT

I have this kind data in txt format. I need urgent help to import into SAS data set.
------------------------------------------------------------------------------------
| 193100 | 20100331 | 97 | 3 |
-------------------------------------------------------------------------------------
| 200998 | 20100331 | 97 | 4 |
-------------------------------------------------------------------------------------
| 201707 | 20100331 | 97 | 2 |
-------------------------------------------------------------------------------------
| 215848 | 20100331 | 97 | 1 |
-------------------------------------------------------------------------------------
| 233171 | 20100331 | 97 | 3 |
-------------------------------------------------------------------------------------
| 250530 | 20100331 | 97 | 16 |
-------------------------------------------------------------------------------------

Thanks

Re: Urgent help for importing txt format data into SAS

Cynthia_sas — Wed, 28 Apr 2010 16:04:36 GMT

Hi:
Does your data have the rows of dashes (-----------------------------) and the pipe characters between each column ( | )?????

Reading a TXT file into SAS is fairly simple. You might use PROC IMPORT or you might use the IMPORT Wizard (in Enterprise Guide) or you might use a DATA step program with INFILE and INPUT statements.

Here's a good place to start reading (and there are a lot of examples here in the documentation -- one of them should fit your data scenario):
http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/a001302670.htm

cynthia

Re: Urgent help for importing txt format data into SAS

deleted_user — Thu, 29 Apr 2010 09:25:20 GMT

It can be done as -
data data1;
infile 'c:\mtdata.txt';
input var1-var4;
run;

Re: Urgent help for importing txt format data into SAS

Patrick — Thu, 29 Apr 2010 11:27:52 GMT

data want(drop=_dummy_);
infile datalines dlm='|' dsd truncover;
input @1 _dummy_:$1. @;
if _dummy_ ne '-' then
do;
input var1 var2 var3 var4;
output;
end;
datalines;
------------------------------------------------------------------------------------
| 193100 | 20100331 | 97 | 3 |
-------------------------------------------------------------------------------------
| 200998 | 20100331 | 97 | 4 |
-------------------------------------------------------------------------------------
| 201707 | 20100331 | 97 | 2 |
-------------------------------------------------------------------------------------
| 215848 | 20100331 | 97 | 1 |
-------------------------------------------------------------------------------------
| 233171 | 20100331 | 97 | 3 |
-------------------------------------------------------------------------------------
| 250530 | 20100331 | 97 | 16 |
-------------------------------------------------------------------------------------
;
run;

proc print data=want;
run;

HTH
Patrick

Re: Urgent help for importing txt format data into SAS

ChrisNZ — Fri, 30 Apr 2010 01:32:15 GMT

or even

data want;
infile datalines dlm='|' dsd truncover;
input @;
if _infile_ ne: '-' ;
input @3 var1 var2 var3 var4;
datalines;