topic Re: divsion observations in SAS Programming

divsion observations

BrahmanandaRao — Sat, 03 Apr 2021 14:31:11 GMT

data div;
input value $;
datalines;
40/20
150/30
300/100
;
run;

data dd;
set div;
result=mod(input(value,value,best12.));
proc print;
run;

How to divide values

Re: divsion observations

Tom — Sat, 03 Apr 2021 14:43:25 GMT

It is not clear what you are trying to do.

What output would you expect from that input.

Also explain what real world situation would require that you do anything like this?

Re: divsion observations

BrahmanandaRao — Sat, 03 Apr 2021 15:02:29 GMT

40/20 =2

Re: divsion observations

Tom — Sat, 03 Apr 2021 16:16:33 GMT

So convert the string into two pieces, convert the substrings into numbers, divide the numbers.

result = input(scan(value,1,'/'),32.) / input(scan(value,2,'/'),32.);

Re: divsion observations

mkeintz — Sat, 03 Apr 2021 16:21:01 GMT

Reading from a raw file? Then use DLM='/' (assuming you always expect a division sign):

data want;
  infile datalines dlm='/';
  input numerator denominator;
  quotient=numerator/denominator;
datalines;
40/20
150/30
300/100
run;

Re: divsion observations

FreelanceReinh — Sat, 03 Apr 2021 17:19:33 GMT

Maybe evaluate the expression to a numeric value and then continue from there:

data want;
set div;
nvalue=input(resolve(cats('%sysevalf(',value,')')),32.);
run;

KSharp used this RESOLVE-%SYSEVALF technique in several of his posts (e.g., here in 2011; in 2012 he mentioned that he himself learned it "from this Forum").