Hello,   I am working with a secondary dataset that includes a rather complicated variable where some levels have many trailing zeros. For some reason, not all levels are included when I create a new variable based on the original variable levels. For example, one of the levels for the variable is 1020405100000 (n=16). But when I try to test the creation of a new variable based just on this value using the code below, it does not display the appropriate output of 16. Rather it says "level=0." This pattern continues for levels for this variable that include trailing zeros. However, if I insert shorter levels of the variable such as 1110 (n=20) in the below code, the new variable accurately reflects n=20. if q12=1020405100000 then newvar=1;   It was suggested that I attempt to truncate the variable to see this would solve the problem.    So instead of having:   1 1020405100000 2 10304051000000000 ....; It would be: 1 102040510 2 103040510 ...;   Do you think this would solve the issue? If so, how is the best way to truncate the variable and remove the trailing zeros? Thank you for any help. ... View more

Hello,   I have two cross sectional survey datasets, one from 2017 and one from 2018. I merged them together, but only 2017 data is weighed with the weight variable _finlwt and includes the strata variable _str. How can I apply the _finlwt and _str variable from 2017 to the responses for 2018 that do not include these variables? My goal is to be able to run proc surveylogistic procedures on the combined dataset with the 2017 weight and stratum variables.    This is my code for merging the two datasets. Thanks for any assistance.    data survey.combined; set survey.2017 survey.2018; run;   ... View more

Hi,   I currently have a program that outputs a new data set that contains results of the proc surveyfreq procedure below:  proc surveyfreq data=2016; weight finalwt; table (gender grade age race hhincome)*(eversmk cursmk)/ cl row nocellpct nostd nofreq nowt nototal; ods output CrossTabs=table1; data table1; retain gender grade age race hhincome eversmk cursmk RowPercent RowLowerCL RowUpperCL; set table1(drop=F_cursmk LowerCL UpperCL Table _SkipLine); run; I would like to develop a macro that calls in different years of data instead of repeating the same surveyfreq procedure on each year of data I have. The above program is for 2016 data, but I would like a macro that calls in 2015, 2014, etc and outputs the same resulting statistics. I have little experience with developing macro code, so any advice would be appreciated. Thank you! ... View more