topic How can i get the data set from different delimiters ??? in SAS Programming

How can i get the data set from different delimiters ???

KrishnaChandra — Mon, 14 Jul 2014 05:05:58 GMT

How to get the meaningful data set from this text file.

How can i get the data set from different delimiters ???

test.txt

101|jasmine/3000

102-roy\5000

103*david,7000

Please let me know the what I should do?

Re: How can i get the data set from different delimiters ???

Scott_Mitchell — Mon, 14 Jul 2014 05:09:40 GMT

You can specify more than one delimter as per the below.

DATA HAVE;

INFILE DATALINES DLM='|/-\*,';

INPUT ID NAME $ VALUE;

DATALINES;

101|JASMINE/3000

102-ROY\5000

103*DAVID,7000

;

Re: How can i get the data set from different delimiters ???

KrishnaChandra — Mon, 14 Jul 2014 06:09:13 GMT

Thanks

Scott_Mitchell

Re: How to convert character datetime to numeric datetime?

sas_lak — Mon, 14 Jul 2014 11:16:34 GMT

/* when the data having multiple delemiters and different length we should give the proper position or length for the data */

DATA OUT_PUT;

INFILE DATALINES DLM='|/-\*,';

INPUT ID @+0 NAME $ @+0 VALUE @+0; /* DEFINE THE LENGTH AND POSITION */

DATALINES;

101|JASMINE/3000

102-ROY\5000

103*DAVID,7000

;

run;