topic Re: Not able to compute a variable in SAS Studio

Not able to compute a variable

smartrambit0 — Sat, 14 Apr 2018 16:09:35 GMT

I am new to SAS analytics and running my code on "online sas studio". please let me know what is wrong with the code. I am getting missing value for the computed variable.

Here is the dataset

--------------------------
data emp;
input id salary total weightr;
datalines;
1 2000 5000 20
2 3000 4000 30
3 5000 7000 44
4 2000 4000 55
;

Here is the code

----------------------

proc report data=emp;
column id salary total weightr ratio;
define id / display;
define salary / 'salary';
define total / 'total';
define weightr / 'weight';
define ratio / computed 'ratio';

compute ratio;
ratio=round(weightr/2.2);
endcomp;

run;

Below is the output

--------------------------

id salary total weight ratio
1 2000 5000 20 .
2 3000 4000 30 .
3 5000 7000 44 .
4 2000 4000 55 .

I am trying to compute ratio as weight/2.2. Please suggest what is wrong with code here.

Re: Not able to compute a variable

Reeza — Sat, 14 Apr 2018 18:55:29 GMT

Add DISPLAY to the DEFINE weightR statement.

Personally, I also like to explicitly specify the second parameter in the ROUND() function, because it's not the same as the Excel function but people have a tendency to assume it is and it's a common place to make a mistake.

This works for me.

proc report data=emp;
    column id salary total weightr ratio;
    define id / display;
    define salary / 'salary';
    define total / 'total';
    define weightr / display 'weight';
    define ratio / computed 'ratio';
    compute ratio;
        ratio=round(weightr/2.2, 0.1);
    endcomp;
run;

@smartrambit0 wrote:

Hi

I am new to SAS analytics and running my code on "online sas studio". please let me know what is wrong with the code. I am getting missing value for the computed variable.

Here is the dataset

--------------------------
data emp;
input id salary total weightr;
datalines;
1 2000 5000 20
2 3000 4000 30
3 5000 7000 44
4 2000 4000 55
;

Here is the code

----------------------

proc report data=emp;
column id salary total weightr ratio;
define id / display;
define salary / 'salary';
define total / 'total';
define weightr / 'weight';
define ratio / computed 'ratio';

compute ratio;
ratio=round(weightr/2.2);
endcomp;

run;

Below is the output

--------------------------

id salary total weight ratio
1 2000 5000 20 .
2 3000 4000 30 .
3 5000 7000 44 .
4 2000 4000 55 .

I am trying to compute ratio as weight/2.2. Please suggest what is wrong with code here.

Re: Not able to compute a variable

Shmuel — Sat, 14 Apr 2018 19:09:01 GMT

Next code worked for me:

proc report data=emp;
    column id salary total weightr ratio;
    define id / order 'ID';
    define salary / 'salary';
    define total / 'total';
    define weightr / order 'weight';
    define ratio / computed format 5.1 'ratio';

    break after weightr / ;
    compute ratio;
        ratio=round(weightr/2.2, 0.3);
    endcomp;
run;

Re: Not able to compute a variable

smartrambit0 — Sat, 14 Apr 2018 19:20:30 GMT

Perfect thank you. I think, because I did not define it as display variable, SAS treated it as analysis variable as it was numeric datatype.

Due to SAS treating it as analysis variable it was not able to perform mathematical operation on it.

Re: Not able to compute a variable

Shmuel — Sat, 14 Apr 2018 19:39:25 GMT

Compute can be done only on GROUP or ORDER variable and there is need to define BREAK statement.