topic i want to extract data which is in between both -xxxx- in the variable in SAS Programming

i want to extract data which is in between both -xxxx- in the variable

vraj1 — Mon, 21 Mar 2016 11:39:21 GMT

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

Re: i want to extract data which is in between both -xxxx- in the variable

Reeza — Mon, 21 Mar 2016 11:41:35 GMT

SCAN() function

Scan(var, 2, '-');

Re: i want to extract data which is in between both -xxxx- in the variable

vraj1 — Mon, 21 Mar 2016 11:44:52 GMT

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

Re: i want to extract data which is in between both -xxxx- in the variable

Reeza — Mon, 21 Mar 2016 12:18:40 GMT

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

Re: i want to extract data which is in between both -xxxx- in the variable

RW9 — Mon, 21 Mar 2016 13:00:38 GMT

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;