Reading from text file

[geoonline]

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.

[PGStats · Accepted solution]

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

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

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

;

proc print data=want noobs; run;

PG