topic Re: Reading data with semi-colon in New SAS User

Reading data with semi-colon

hhchenfx — Tue, 13 Aug 2019 02:25:58 GMT

Hi Everyone,

I would like to read text data with semi-colon as in below code.

My data has only 1 column of text

Can you please help me with that?

Thank you so much,

HHCFX

data have;
	infile datalines dlm="|";
	length var $ 30000;
	input var $;
	datalines;
afdasb
12132ndfd
df;dfd;
semi;colon;;;fa

;run;

r_behata — Tue, 13 Aug 2019 02:33:00 GMT

Use datalines4 instead of datalines for reading the inline data with semicolons.

data have;
infile datalines dlm="|";
length var $ 30000;
input var $;
datalines4;
afdasb
12132ndfd
df;dfd;
semi;colon;;;fa
;;;;
run;

hhchenfx — Mon, 30 Sep 2019 04:01:46 GMT

Thank you for your help.
Hhcfx