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?
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
;
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
;
Thanks
/* 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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.