Thanks so much I did not realize it was case sensitive. I corrected this and it is working great now. Thank you! ... View more

apologies.. 4036 data dataseta; 4037 set dataset; 4038 /* Person, Tele and Phone are mutually exclusive */ 4039 if consentperson='yes' then visit_typeconsent=1; 4040 else if consenttele='yes' then visit_typeconsent=2; 4041 else if consentphone='yes' then visit_typeconsent=3; 4042 run; NOTE: There were 166 observations read from the data set WORK.DATASET. NOTE: The data set WORK.DATASETA has 166 observations and 254 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds 4043 4044 4045 proc freq data=dataseta; 4046 TABLES visit_typeconsent*consentdeviation/chisq expected nopercent; 4047 run; NOTE: No statistics are computed for visit_typeconsent * consentdeviation because all data are missing. NOTE: There were 166 observations read from the data set WORK.DATASETA. NOTE: PROCEDURE FREQ used (Total process time): real time 0.06 seconds cpu time 0.00 seconds 4048 4049 proc freq data=dataseta; 4050 tables visit_typeconsent*consent_complete/chisq expected nopercent; 4051 run; NOTE: No statistics are computed for visit_typeconsent * consent_complete because all data are missing. NOTE: There were 166 observations read from the data set WORK.DATASETA. NOTE: PROCEDURE FREQ used (Total process time): real time 0.10 seconds cpu time 0.03 seconds   ... View more

Here is the log: 4020 data dataseta; 4021 set dataset; 4022 /* Person, Tele and Phone are mutually exclusive */ 4023 if consentperson='yes' then visit_type=1; 4024 else if consenttele='yes' then visit_type=2; 4025 else if consentphone='yes' then visit_type=3; 4026 run; NOTE: There were 166 observations read from the data set WORK.DATASET. NOTE: The data set WORK.DATASETA has 166 observations and 254 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 4027 4028 4029 proc freq data=dataseta; 4030 TABLES consentperson*consentdeviation/chisq expected nopercent; 4031 run; NOTE: There were 166 observations read from the data set WORK.DATASETA. NOTE: PROCEDURE FREQ used (Total process time): real time 0.14 seconds cpu time 0.09 seconds 4032 4033 proc freq data=dataseta; 4034 tables consentperson*consent_complete/chisq expected nopercent; 4035 run; NOTE: There were 166 observations read from the data set WORK.DATASETA. NOTE: PROCEDURE FREQ used (Total process time): real time 0.13 seconds cpu time 0.03 seconds 4036 data dataseta; 4037 set dataset; 4038 /* Person, Tele and Phone are mutually exclusive */ 4039 if consentperson='yes' then visit_typeconsent=1; 4040 else if consenttele='yes' then visit_typeconsent=2; 4041 else if consentphone='yes' then visit_typeconsent=3; 4042 run; NOTE: There were 166 observations read from the data set WORK.DATASET. NOTE: The data set WORK.DATASETA has 166 observations and 254 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds 4043 4044 4045 proc freq data=dataseta; 4046 TABLES visit_typeconsent*consentdeviation/chisq expected nopercent; 4047 run; NOTE: No statistics are computed for visit_typeconsent * consentdeviation because all data are missing. NOTE: There were 166 observations read from the data set WORK.DATASETA. NOTE: PROCEDURE FREQ used (Total process time): real time 0.06 seconds cpu time 0.00 seconds 4048 4049 proc freq data=dataseta; 4050 tables visit_typeconsent*consent_complete/chisq expected nopercent; 4051 run; NOTE: No statistics are computed for visit_typeconsent * consent_complete because all data are missing. NOTE: There were 166 observations read from the data set WORK.DATASETA. NOTE: PROCEDURE FREQ used (Total process time): real time 0.10 seconds cpu time 0.03 seconds   ... View more

Hi Paige, I tried running that code and this is what the output looked like when I attempted to run a chi squared analysis using the new variable: data dataseta; set dataset; /* Person, Tele and Phone are mutually exclusive */ if consentperson='yes' then visit_typeconsent=1; else if consenttele='yes' then visit_typeconsent=2; else if consentphone='yes' then visit_typeconsent=3; run; proc freq data=dataseta; TABLES visit_typeconsent*consentdeviation/chisq expected nopercent; run; proc freq data=dataseta; tables visit_typeconsent*consent_complete/chisq expected nopercent; run;   reach The FREQ Procedure   For visit_typeconsent * consentdeviation all data are missing because all levels of variable visit_typeconsent are missing.   reach The FREQ Procedure   For visit_typeconsent * consent_complete all data are missing because all levels of variable visit_typeconsent are missing.   ... View more

For example: Input data: person      tele      phone yes            no       no no              yes     no no             no        yes   Output: Visit_Type 1 2 3   ... View more

All three categories are mutually exclusive, so if the visit was in person it is not tele or phone.  ... View more