topic Re: SAS import text file in SAS Programming

SAS import text file

ramya_sahu — Tue, 28 Feb 2017 06:53:18 GMT

Hi All,

I am very much new to SAS. So, Please help me importing attached text file to SAS.

Thanks in advance..

Ramya

Re: SAS import text file

Kurt_Bremser — Tue, 28 Feb 2017 07:57:55 GMT

Since you have fixed columns, the blanks in the model text don't matter.

Use formatted input with position modifiers:

input
  @1 id 3.
  @5 orderdate date9.

and so on. Use the truncover option in the infile statement, since your last column has a variable number of digits.

Re: SAS import text file

avinashns — Tue, 28 Feb 2017 08:00:00 GMT

filename orders 'C:\orders.txt';

data want;
	infile orders firstobs=2;
	informat orderdate date7.;
	format orderdate date7.;
	input ID Orderdate Model $12. Quantity;
run;

Re: SAS import text file

ramya_sahu — Tue, 28 Feb 2017 08:14:12 GMT

Thanks Avinas.. it worked.

Re: SAS import text file

user24feb — Tue, 28 Feb 2017 08:17:05 GMT

Your file does not open. Proc import might be easier.

proc import datafile=.. your path ../order.txt''
            out=order
            dbms=dlm
            replace;
     delimiter='09'x; * for tab-delimited files;
run;

http://support.sas.com/documentation/cdl/en/proc/69850/HTML/default/viewer.htm#n1w1xy48wd290bn1mqalitn7wy13.htm

Re: SAS import text file

ramya_sahu — Tue, 28 Feb 2017 08:25:24 GMT

Thanks. for below file format is it possible?

ID Orderdate Model Quantity
287 15OCT03 Delta Breeze 15
287 15OCT03 Santa Ana 15
274 16OCT03 Jet Stream 1
174 17OCT03 Santa Ana 20
174 17OCT03 Nor'easter 5
174 17OCT03 Scirocco 1
347 18OCT03 Mistral 1
287 21OCT03 Delta Breeze 30
287 21OCT03 Santa Ana 25

Re: SAS import text file

ramya_sahu — Tue, 28 Feb 2017 08:26:12 GMT

Thanks for your response

Re: SAS import text file

Kurt_Bremser — Tue, 28 Feb 2017 08:32:59 GMT

To deal with blanks in values, you either need fixed columns, or enclose the fields containing blanks in quotes, or use a field separator other than a blank (eg .csv file with commas as separator).

Everything else needs lots of programming effort to determine which "words" belong into one column.

@ramya_sahu wrote:

Thanks. for below file format is it possible?

ID Orderdate Model Quantity
287 15OCT03 Delta Breeze 15
287 15OCT03 Santa Ana 15
274 16OCT03 Jet Stream 1
174 17OCT03 Santa Ana 20
174 17OCT03 Nor'easter 5
174 17OCT03 Scirocco 1
347 18OCT03 Mistral 1
287 21OCT03 Delta Breeze 30
287 21OCT03 Santa Ana 25