Coding - Filter results for one group

[knjohns0]

I do not think I am coding for the right proc; I am trying to find the correlation of females who smoke and have moderate to high cholesterol. I can not figure out how to Isolate the females from the males?

proc glm data=sashelp.heart;
class cholesterol;
model smoking = cholesterol;
run;

proc univariate data=sashelp.heart plots;
class chol_status;
var smoking ;
run;

proc univariate data=sashelp.heart plots;
class smoking_status;
var cholesterol ;
run;

proc reg data=sashelp.heart plots(maxpoints=10000);
model cholesterol = smoking;
run;quit;

[knjohns0]

I do not think I am coding for the right proc; I am trying to find the correlation of females who smoke and have moderate to high cholesterol. I can not figure out how to Isolate the females from the males?

proc glm data=sashelp.heart;
class cholesterol;
model smoking = cholesterol;
run;

proc univariate data=sashelp.heart plots;
class chol_status;
var smoking ;
run;

proc univariate data=sashelp.heart plots;
class smoking_status;
var cholesterol ;
run;

proc reg data=sashelp.heart plots(maxpoints=10000);
model cholesterol = smoking;
run;quit;

[VDD]

proc glm data=sashelp.heart;
class cholesterol;
model smoking = cholesterol;
where sex = 'Female';
run;
 
proc univariate data=sashelp.heart plots;
class chol_status;
var smoking ;
where sex = 'Female';
run;

proc univariate data=sashelp.heart plots;
class smoking_status;
var cholesterol ;
where sex = 'Female';
run;
 
proc reg data=sashelp.heart plots(maxpoints=10000);
model cholesterol = smoking;
Where sex = 'Female';
run;quit;

add  where sex = 'Female': 

[VDD]

Try adding where sex = 'Female';

[Kurt_Bremser]

I merged the double-post.

[Reeza]

FYI - I've updated your subject line. Please use a more relevant subject line in the future.