Thank you, Reeza, for your thoughts on this, very much appreciated! ... View more

Thank you very much, Reeza. The logic of your solution makes sense but that did not solve the issue in my WORD output. May this be an issue with ODS WORD, because the SAS output distinguishes all LABELs correctly?   I tried ODS RTF and I could get labels for the first variable on each separate page. Thanks ... View more

Reeza, thank you again for your code. Now, I want to use it on another occasion but I could not modify it very well. I am using the following code to save the labels and print them above the tables in my report. In my SAS output, it works perfect and copies each label above each table (sample output below) AGE: How old are you? VarName Mean SD L_95_p_CI U_95_p_CI N AGE 39.88 14.25 39.14 40.62 1250 However, in my ODS WORD file, only the label for the first variable in the list appears. May you please help me to resolve this issue, please? Thanks %macro do_sm(varname); ods exclude all; data output3; retain VarName VarLabel Mean &varname LowerCLMean UpperCLMean N; set output2; run; data output4 (rename=(VarName=VarName VarLabel=Label &varname=SD LowerCLMean=L_95_p_CI UpperCLMean=U_95_p_CI)); set output3; run; proc sql noprint; select distinct Label into :title_name from output4; quit; data output5 (drop=Label); set output4; run; ods exclude none; title j=l "&title_name."; proc print data=output5 noobs; run; %mend do_sm; ods word file="D:path\REPORT_&DATE..docx" STARTPAGE=NO; OPTIONS NONUMBER NODATE FORMDLIM='~'; %do_sm(age); %do_sm(money); ods word close;   ... View more

Great, thank you, Ksharp! ... View more

Hi Koen, Thank you, for your advice. Next time, I will search the previous posts more carefully. Thanks, Mary ... View more

Thank you, PaigeMiller. It works very well! ... View more

Thank you, Reeza. I used this in my code and it works perfectly. ... View more

Thank you, Tom. This is great! ... View more

Below is the full code that I am using. I hope it helps. Thanks   %macro macro_surveyfreq(varname); ods exclude all; ods output OneWay=Output; proc surveyfreq data = &dataset VARHEADER = NAMELABEL nosummary; tables &varname/cl nofreq nostd; weight &weight_var; run; data output; set output; label = vlabelx(scan(table,2,' ')); run; proc print data=output; run; data output1; set output (drop=Table F_&varname _SkipLine) end=last; if not last then output; run; data output2 (rename= (WgtFreq=Frequency LowerCL=L_95_p_CI UpperCL=U_95_p_CI)); set output1; run; proc print data=output2 noobs; run; data output3; retain &varname label Frequency Percent L_95_p_CI U_95_p_CI ; set output2; run; ods exclude none; proc print data=output3 noobs; run; *this is the table that goes into report; %mend; ods word file="D:\path\PROC_SURVEYFREQ.docx" STARTPAGE=NO; %macro_surveyfreq(age); %macro_surveyfreq(gender_3_levels); %macro_surveyfreq(education_level); %macro_surveyfreq(income_4_cat); *my list is long here; ods word close; ... View more

Thanks, ballardw. I tried the GROUP code but I think I am doing something wrong because it grouped all rows. My code and the new table are copied below. I am going to send my full code in a separate post. Thanks proc report data=output3; columns label &varname Frequency Percent L_95_p_CI U_95_p_CI ; define label / group; run; label Age  categories Weighted Frequency Percent 95% Lower Confidence Limit, Percent 95% Upper Confidence Limit, Percent Age  categories 15 1941 100.0 89.7 110.3 ... View more

Thanks, ballardw. I try your previous code and will send an update shortly. Thanks ... View more

Good point, Patrik. My ideal table looks like this:   Age categories AGE Frequency Percent L_95_p_CI U_95_p_CI 10-20 years 379 19.5 17.1 21.9 21-30 years 460 23.7 21.3 26.1 31-40 years 380 19.6 17.6 21.5 41-50 years 369 19.0 17.0 20.9 51-60 years 354 18.3 16.6 19.9 Thanks ... View more

Thank you, ballardw, for your suggestion. I want to keep the variable name age as is. I want to add the label in some form once. the label is not really a label anymore. It is a column of my dataset that is repeating itself for all rows, which makes it too repetitive in a long report. Thanks ... View more