topic I am trying to separate values of a variable into 2 different variables in SAS Programming

I am trying to separate values of a variable into 2 different variables

sas_learnsups — Wed, 11 Apr 2018 02:45:37 GMT

I have a variable with values as follows:

med_qty

100ml

2*96

2*100g

I want to make the above data into :

dose dosage qty

100 ml

96 2

100 2 g

Re: I am trying to separate values of a variable into 2 different variables

art297 — Wed, 11 Apr 2018 02:59:47 GMT

Here is one way:

data want (drop=med_qty);
  set have;
  if anyalpha(med_qty) then do;
   qty=substr(med_qty,anyalpha(med_qty));
   med_qty=substr(med_qty,1,anyalpha(med_qty)-1);
  end;
  dose=input(scan(med_qty,1,'*'),8.);
  dosage=input(scan(med_qty,2,'*'),8.);
run;

Art, CEO, AnalystFinder.com

Re: I am trying to separate values of a variable into 2 different variables

novinosrin — Wed, 11 Apr 2018 03:01:39 GMT

data have;
input  med_qty $20.;
datalines;
100ml
2*96
2*100g
;

data want;
set have;
if index( med_qty, '*')>0 then do;
dose=compress(scan(med_qty,2,'*'),,'kd');
dosage=scan(med_qty,1,'*');
qty=compress(med_qty,'*','d');
end;
else do;
dose=compress(med_qty,,'kd');
qty=compress(med_qty,'*','d');
end;
run;

Re: I am trying to separate values of a variable into 2 different variables

sas_learnsups — Wed, 11 Apr 2018 03:19:03 GMT

Thank you very much!

Re: I am trying to separate values of a variable into 2 different variables

sas_learnsups — Wed, 11 Apr 2018 03:22:13 GMT

Thank you very much