Hello Friends,   I am not STATA user. I tried to understand this language so I could translate its code into SAS. I need your input in certifying that my SAS code is equivalent to the Stata code.   /*Example STATA code:*/   gen strataid=. replace strataid=(GESTFIPS*10000)+ HG_MSAC if HG_MSAC > 0 replace strataid =(GESTFIPS*1000) + GECO if GECO > 0 & HG_MSAC==0 replace strataid = GESTFIPS if GECO == 0 & HG_MSAC == 0   This is how I converted the above code into SAS: ................................; length STRATAID 4; set stratumxplr;     if missing(GECO) then call missing (STRATAID);  if missing (HG_MSAC) then call missing (STRATAID);  if missing (GESTFIPS) then call missing (STRATAID);  if GTCBSA > 0 then STRATAID = (GESTFIPS*10000) + GTCBSA;     else if GTCO > 0 and GTCBSA = 0 then STRATAID = (GESTFIPS*1000) + GTCO;      else if GTCO = 0 and GTCBSA = 0 then STRATAID = GESTFIPS;  label STRATAID = 'Stratum Identification'; run; Are the Stata double == equal signs equivalent to SAS one equal sign? Stata code is from Michael Davern et al. p. 14 (http://journals.sagepub.com/doi/pdf/10.5034/inquiryjrnl_43.3.283).   Thanks for your help,   Artp ====   ... View more

Hello,   Here is my SAS code:   proc tabulate data = parenting format=comma12.; class parsel; table parsel ='Parents' all, n*f=7.0 pctn*f=9.1 /rts=25; keylabelpctn = 'Percent' all = 'Total'; run;   Using Proc Means i get a total sum of 13572799.05. However, Proc Tabulate yields the following number: 1.36E+07 (when expanded, it is 13570000 (see Excel attachment). How can I format 1.36E+07 to get it fully displayed with 2 decimal points like 13572799.05 (or 13,572,799.05)?   Thanks for your technical input,   Artp   N Percent Parents 1.36E+07 100       Total 1.36E+07 100 ... View more

Hello,   Using the code below does not generate weighted estimates. Is there a different way to get the expected results?   proc tabulate data = parents vardef=weight; weight pwpwgt; class parseg; table parseg =' ' all, n*f=7.0 pctn*f=9.1 /rts=25; keylabel pctn = 'Percent' all = 'Total'; format parseg prselfm.; title 'Weighted Estimates Using vardef=weight in Proc Tabulate'; run;   Reference for vardef=weight: https://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473731.htm#a000068934   Thanks,   Artp ... View more

Hello Colleagues,   I am analyzing a Survey Data set. Running Proc Contents reveals the existence of the weight variable that was used. I do not see the other elements like the stratum and the PSU that are usually included in Proc Surveyfreq like shown below   proc surveyfreq data = one;   tables infant / row clwt;   strata _ststr; *_ststr is the stratification variable;   cluster _psu; * _psu is the psu or first stage clustering;   weight _srypwt; run;   Should I simply use the weight variable _srypwt in a Proc Freq or in either Proc Surveyfreq?   Thanks,   Artp   ... View more