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

[KrishnaChandra]

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?

[Scott_Mitchell · Accepted solution]

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

;

[KrishnaChandra]

Thanks

Scott_Mitchell

[sas_lak]

/* 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;