BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
vraj1
Quartz | Level 8

I have a variable and i want to extract data like example

 

var1

kjjhf-0fdf-dfed

asd-fdfk-dfcsf

 

I want to get data which is between the -

var1

0fdf

fdfk

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

It is a good idea to post your test data in the form of a datastep:

data have;
  var1="kjd-fhf-asd"; output;
  var1="dfsf-dfg-dwe"; output;
run;
data want;
  set have;
  want=catx(' ',substr(scan(var1,2,"-"),1,2),substr(scan(var1,2,"-"),3,1));
run;

View solution in original post

4 REPLIES 4
Reeza
Super User

SCAN() function

 

Scan(var, 2, '-');
vraj1
Quartz | Level 8

sorry, i gave a incomplete question. i also want space after scanning like

var1

kjd-fhf-asd

dfsf-dfg-dwe

 

i want like this

var1

fh f

df g

 

 

Reeza
Super User

Use substr() to extract the two parts and the CAT function to create new variable. 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

It is a good idea to post your test data in the form of a datastep:

data have;
  var1="kjd-fhf-asd"; output;
  var1="dfsf-dfg-dwe"; output;
run;
data want;
  set have;
  want=catx(' ',substr(scan(var1,2,"-"),1,2),substr(scan(var1,2,"-"),3,1));
run;
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1749 views
  • 0 likes
  • 3 in conversation