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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.