Hi, I will like to create a variable Zip_1 where: 1 = Response zip code does NOT correlate to a state zip code 0 = Response zip code correlates to a state zip cod. I used the following data step; data a; set b; if zipcode in (45666,55756,33546,45645,08083) then Zip_1 =0; else Zip_1=1; run;   How do I use the operator (not in) so that I can have Zip_1=1 before Zip_1=0. I guess what am trying to ask is what is the correct operator for (not in) so that I will be able to include all the numbers. data a; set b; if zipcode  not in (45666,55756,33546,45645,08083) then Zip_1 =0; else Zip_1=1; run;   ... View more

Hi, I would like to merge two data set and also create a new variable by using proc sql. This is my code but am getting the following syntax error.   proc sql; create table final_table_0607 as select * from case_07 as x left join mth_0607 as y on x.bene_id = y.bene_id where month_fu-(mondx1+12) as month_std; __ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, IN, INTERSECT, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ORDER, OUTER, UNION, ^, ^=, |, ||, ~, ~=.   ERROR 76-322: Syntax error, statement will be ignored. ... View more

Hello, I am trying to use IPTW but I encountered this warning after running my code. I would like to know what this warning means and how to rectify the warning and have a smooth running code.    /*Log*/ 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc logistic data= data1 desc; 74 class sex agerace (ref=first) 75 ALZHDMTE_a (ref=first) 76 AMIE_a (ref=first) ANEMIA_a (ref=first) 77 ATRIALFE_a (ref=first) ASTHMA_a (ref=first) 78 CHFE_a (ref=first) CHRNKDNE_a (ref=first) 79 COPDE_a (ref=first) DIABTESE_a (ref=first) 80 GLAUCMAE_a (ref=first) HIPFRACE_a (ref=first) 81 HYPERL_a (ref=first) HYPERP_a (ref=first) 82 HYPERT_a (ref=first) HYPOTH_a (ref=first) 83 ISCHMCHE_a (ref=first) OSTEOPRE_a (ref=first) 84 RA_OA_E_a (ref=first) STRKTIAE_a (ref=first) 85 cancer_a (ref=first) /param=ref; 86 model case (event='1') = age sex race ALZHDMTE_a 87 AMIE_a ANEMIA_a ATRIALFE_a ASTHMA_a CHFE_a 88 CHRNKDNE_a COPDE_a DIABTESE_a GLAUCMAE_a HIPFRACE_a 89 HYPERL_a HYPERP_a HYPERT_a HYPOTH_a ISCHMCHE_a 90 OSTEOPRE_a RA_OA_E_a STRKTIAE_a cancer_a / link=logit rsquare; 91 output out=data1_PS p=A1_C xbeta=logit_ps; 92 run;   NOTE: PROC LOGISTIC is modeling the probability that case=1. WARNING: There is possibly a quasi-complete separation of data points. The maximum likelihood estimate may not exist. WARNING: The LOGISTIC procedure continues in spite of the above warning. Results shown are based on the last maximum likelihood iteration. Validity of the model fit is questionable. NOTE: There were 1234567 observations read from the data set WORK.data1.     ... View more

Hi, Can I use rsubmit on sas studio? if yes how can it be done. Thanks! ... View more

Hi, I saw a similar code online. What is the function of "case" in this codes? what are they use for? data want; set have; if a ne . then come=1; else come=0; if b ne . then go=1;else go=0; if c ne . then home=1;else home=0; case=1; run; data want2; set have2; if a ne . then come=1;else come=0; if b ne . then go=1;else go=0; if c ne . then home=1;else home=0; case=0; run;     ... View more