Reading from text file

geoonline — Mon, 03 Feb 2014 04:30:33 GMT

I have a text file that has really long string with delimiter as ^ inbetween.

I want to read in this file as SAS dataset such it will be read in under a single varaibale (Say VAR1) with different observations whenever it encounters the delimiter '^'

Say the text file is as below

"This is my text file this is my text file ^ This is my ^ This is "

and the dataset should be read in as below

OBS VAR1

1 This is my text file this is my text file

2 This is my

3 This is

Is there any way to read in this text file as the example shown above? SAS Gurus, Please advise.

Re: Reading from text file

PGStats — Mon, 03 Feb 2014 04:48:17 GMT

Simply use option DLM= and hanging @@ :

data want;

infile datalines dlm='^';

length var1 $64;

input var1 @@;

datalines;

This is my text file this is my text file ^ This is my ^ This is

;

proc print data=want noobs; run;

topic Re: Reading from text file in SAS Programming

Reading from text file

Re: Reading from text file