Creating a frequency table using age

Kimberly_2020 — Sat, 08 Aug 2020 18:57:06 GMT

Hello there,

I am trying to create a frequency table for gender and sexual orientation between the ages of 18-50. Where am I going wrong.

Code:
proc freq data=WORK.SYPHILIS;
	tables genderC genderB sex_o age RACE / plots=(freqplot cumfreqplot);
	where  Type in ("genderC", "genderB", "sex_o", age "18-50");
run;

Log:

87         proc freq data=WORK.SYPHILIS;
 88         tables genderC genderB sex_o age RACE / plots=(freqplot cumfreqplot);
 89         where  Type in ("genderC", "genderB", "sex_o", age "18-50");
                                                            ___
                                                            22
                                                            202
 ERROR: Syntax error while parsing WHERE clause.
 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ).  
 ERROR 202-322: The option or parameter is not recognized and will be ignored.
 90         run;

Re: Creating a frequency table using age

PaigeMiller — Sat, 08 Aug 2020 19:54:33 GMT

I think this will work

where  Type in ("genderC", "genderB", "sex_o") and 18<=age<=50

This assumes age is numeric

topic Creating a frequency table using age in New SAS User

Creating a frequency table using age

Re: Creating a frequency table using age