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

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

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

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?


Accepted Solutions
Solution
‎07-14-2014 01:09 AM
Super Contributor
Posts: 297

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

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

;

View solution in original post


All Replies
Solution
‎07-14-2014 01:09 AM
Super Contributor
Posts: 297

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

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

;

Frequent Contributor
Posts: 89

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

Thanks

Scott_Mitchell Smiley Happy
Contributor
Posts: 46

Re: How to convert character datetime to numeric datetime?

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 201 views
  • 0 likes
  • 3 in conversation