Hello there, SAS keeps saying that the variable type is not on file....What does this mean? WHen I did a one way frequency table without the where statement it ran...But when I made this edit, it didn't. Code:
proc freq data=WORK.SYPHILIS;
tables genderB genderC sex_o RACE age / plots=(freqplot cumfreqplot);
where Type in ("genderB", "genderC", "sex_o", "race") and 18<=age<=50;
run;
Log:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /home/u49152646/.sasstudio/.images/db1b9e49-6774-45a2-9899-069be7ad3673
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
SYMBOLGEN: Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME;
72
73 /*
74 *
75 * Task code generated by SAS Studio 3.8
76 *
77 * Generated on '8/10/20, 8:32 AM'
78 * Generated by 'u49152646'
79 * Generated on server 'ODAWS03-USW2.ODA.SAS.COM'
80 * Generated on SAS platform 'Linux LIN X64 3.10.0-1062.9.1.el7.x86_64'
81 * Generated on SAS version '9.04.01M6P11072018'
82 * Generated on browser 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)
82 ! Chrome/84.0.4147.105 Safari/537.36'
83 * Generated on web client
83 ! 'https://odamid-usw2.oda.sas.com/SASStudio/main?locale=en_US&zone=GMT-07%253A00&ticket=ST-27624-sinmcsizLgE19kH9QBkl-cas'
84 *
85 */
86
87 proc freq data=WORK.SYPHILIS;
88 tables genderB genderC sex_o RACE age / plots=(freqplot cumfreqplot);
89 where Type in ("genderB", "genderC", "sex_o", "race") and 18<=age<=50;
ERROR: Variable Type is not on file WORK.SYPHILIS.
... View more
