I used crude log-binomial regression with GEE for my analysis. When I ran the below code I get this error message.  proc genmod data = myproject_1e descending; class ParticipantID; class state_marijuana_legal_status1 (ref='3'); model Marijuana_Use2 = state_marijuana_legal_status1/ dist=binomial; link=log; repeated subject=ParticipantID/type=exch; run;     ... View more

When I ran proc freq I get warming where it indicated cell count are less than 5 and chi square may not be valid. Then I tried using fisher exact test, it was taking forever to run the proc freq with fisher test and not able to compute anything. If there is any alternative to fisher exact test if cell count are less than 5. Thank you. ... View more

Hi, I have 2 variables: marijuana_Use2 and illegal_drugUse2 both are binary variable. I want to combine the variables and name as drugUse2, recode as:                                                                                              0: Never use drug                                                                                              1: marijuana use                                                                                              2: Illegal drug use                                                                                              3: Both drug use I used the code mention below. I'm able to run the code but I am not sure the outcome I obtain is accurate. data myproject7; set myproject6; if marijuana_Use2 = 1 and illegal_drugUse2 = 0 then drugUse2 = 1; *Marijuana use; if marijuana_Use2 = 0 and illegal_drugUse2 = 1 then drugUse2 = 2; *non marijuana illegal drugs use; if marijuana_Use2 = 1 and illegal_drugUse2 = 1 then drugUse2 = 3; *both drugs use; if marijuana_Use2 = 1 and illegal_drugUse2 = . then drugUse2 = 1; *Marijuana use; if marijuana_Use2 = . and illegal_drugUse2 = 1 then drugUse2 = 2; *non marijuana illegal drugs use; if marijuana_Use2 = 0 and illegal_drugUse2 = 0 then drugUse2 = 0; *never use; if marijuana_Use2 = 0 and illegal_drugUse2 = . then drugUse2 = 0; *never use; if marijuana_Use2 = . and illegal_drugUse2 = 0 then drugUse2 = 0; *never use; label drugUse2 = Drug Use; run; ... View more

Hi,  When I ran the code I got error message in log, what does it mean by variable contains more than 32 bytes. Any solutions are highly appreciated. Thank you.   data project2; set project1; state_marijuana_legal_status1=state_marijuana_legal_status; if followUp=2 and date_recreational_marijuana_legalized > "01JUL2020"d then state_marijuana_legal_status1=1; if followUp=5 and date_recreational_marijuana_legalized > "01DEC2020"d then state_marijuana_legal_status1=1; if followUp=7 and date_recreational_marijuana_legalized > "01MAY2021"d then state_marijuana_legal_status1=1; if followUp=8 and date_recreational_marijuana_legalized > "01SEP2021"d then state_marijuana_legal_status1=1; if followUp=10 and date_recreational_marijuana_legalized > "01MAR2022"d then state_marijuana_legal_status1=1; run;   I got this error message in my log:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 data project2; 70 set project1; 71 state_marijuana_legal_status1=state_marijuana_legal_status; 72 if followUp=2 and date_recreational_marijuana_legalized > "01JUL2020"d then state_marijuana_legal_status1=1; ERROR: The variable named date_recreational_marijuana_legalized contains more than 32 bytes. 73 if followUp=5 and date_recreational_marijuana_legalized > "01DEC2020"d then state_marijuana_legal_status1=1; ERROR: The variable named date_recreational_marijuana_legalized contains more than 32 bytes. 74 if followUp=7 and date_recreational_marijuana_legalized > "01MAY2021"d then state_marijuana_legal_status1=1; ERROR: The variable named date_recreational_marijuana_legalized contains more than 32 bytes. 75 if followUp=8 and date_recreational_marijuana_legalized > "01SEP2021"d then state_marijuana_legal_status1=1; ERROR: The variable named date_recreational_marijuana_legalized contains more than 32 bytes. 76 if followUp=10 and date_recreational_marijuana_legalized > "01MAR2022"d then state_marijuana_legal_status1=1; ERROR: The variable named date_recreational_marijuana_legalized contains more than 32 bytes. 77 run; ... View more

Hi, I want to merge two datasets vertically. Both datasets have different variables, since for vertical merge we need the same variable name on both datasets. How can I create a new variable (other than renaming it) so it will be consistent between two datasets for easy merge? Thank you. ... View more