topic Re: Proc report with DO and Conditional in SAS Programming

Proc report with DO and Conditional

ManitobaMoose — Fri, 12 Jan 2018 03:19:35 GMT

Hi.

I am trying to display the computed variable Hypertensive such that it is shown as "Hypertensive?" and is computed as 'Yes' or 'No' depending on conditional factors.

First of all, I am getting no display for yes or no if I leave the variable name as Hypertensive, as opposed to displaying Hyertensive?

Second, I have no idea how to convert the variable hypertensive to display hypertensive? in proc report.

Any help would be much appreciated. Thanks!

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

Libname Learn '/folders/myfolders/Learn' ;

Title "Hypertensive Patients" ;
proc report data=learn.BloodPressure nowd headline ls=80 ;
   columns Gender SBP DBP Hypertensive ;
   define SBP            / display "SBP" ;
   define DBP            / display "DBP" ;
   compute Hypertensive / character length=8 ;
   define Hypertensive   / display "Hypertensive?" ;
       If Gender=F then do ;
           If (SBP gt 138 or DBP gt 88) then Hypertensive='Yes';
           else Hypertensive='No' ;
       end ;
       If Gender=M then do ;
           If (SBP gt 140 or DBP gt 90) then Hypertensive='Yes';
           else Hypertensive='No' ;
       end ;
   endcomp ;
run ;

Re: Proc report with DO and Conditional

ChrisNZ — Fri, 12 Jan 2018 04:06:38 GMT

Like this?


proc report data=SASHELP.CLASS(obs=10);
    columns NAME SEX WEIGHT HYPERTENSIVE;
    compute HYPERTENSIVE  / character length=8 ;
        if SEX='F' then do ;
            if (WEIGHT.sum gt 100 ) then HYPERTENSIVE='Yes';
            else HYPERTENSIVE='No' ;
        end ;
        if SEX='M' then do ;
            if (WEIGHT.sum gt 110 ) then HYPERTENSIVE='Yes';
            else HYPERTENSIVE='No' ;
        end ;
    endcomp ;
run ;

Name	Sex	Weight	HYPERTENSIVE
Alfred	M	112.5	Yes
Alice	F	84	No
Barbara	F	98	No
Carol	F	102.5	Yes
Henry	M	102.5	No
James	M	83	No
Jane	F	84.5	No
Janet	F	112.5	Yes
Jeffrey	M	84	No
John	M	99.5	No

Re: Proc report with DO and Conditional

ManitobaMoose — Fri, 12 Jan 2018 04:26:24 GMT

Thanks.

As for getting the hypertensive to display 'true' or 'false', it was simple:

I did not put the gender ='f' and gender='m' in apostrophes, as I should have for a character variable. When I corrected this, after reading your post, it worked.

As for converting the variable hypertensive to hypertensive? for displaying on the proc report, I am not sure how to do this. However, I did get most of it. If anyone else has suggestions on this that would be great. If not, that is ok.

Re: Proc report with DO and Conditional

ManitobaMoose — Fri, 12 Jan 2018 04:26:59 GMT

Libname Learn '/folders/myfolders/Learn' ;

Title "Hypertensive Patients" ;
proc report data=learn.BloodPressure nowd headline ls=80 ;
   columns Gender SBP DBP Hypertensive ;
   define SBP            / display "SBP" ;
   define DBP            / display "DBP" ;
   compute Hypertensive / character length=8 ;
       If Gender='F' then do ;
           If (SBP gt 138 or DBP gt 88) then Hypertensive='Yes';
           else Hypertensive='No' ;
       end ;
       If Gender='M' then do ;
           If (SBP gt 140 or DBP gt 90) then Hypertensive='Yes';
           else Hypertensive='No' ;
       end ;
   endcomp ;
   hypertensive(rename=hypertensive?) ;
run ;

Re: Proc report with DO and Conditional

andreas_lds — Fri, 12 Jan 2018 06:54:43 GMT

The question-mark is not a valid char in a name. But you can assign a label to Hypertensive to be displayed as "Hypertensive?"

proc report data=SASHELP.CLASS(obs=10);
    columns NAME SEX WEIGHT HYPERTENSIVE;

    define HYPERTENSIVE / computed "Hypertensive?";

    compute HYPERTENSIVE  / character length=8 ;
        if SEX='F' then do ;
            if (WEIGHT.sum gt 100 ) then HYPERTENSIVE='Yes';
            else HYPERTENSIVE='No' ;
        end ;
        if SEX='M' then do ;
            if (WEIGHT.sum gt 110 ) then HYPERTENSIVE='Yes';
            else HYPERTENSIVE='No' ;
        end ;
    endcomp ;
run ;