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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: