I'm using ODS RTF to output Proc Reports to a Word document. The following is my code:   ods rtf file='C:\Annual Summary Reports_2018-forward\Rolling Reports\AUTOLIB\Tables.rtf' noKEEPN; options nodate nonumber orientation=portrait ; ** PROC REPORT work; Proc report data=year3_region out=report_&thisname nowd STYLE(report) = [rules=none frame=hsides background=white cellspacing=0 cellpadding=.20] STYLE(header) = [foreground=black background=white cellheight=.23in borderbottomwidth=2.0pt borderbottomcolor=black bordertopwidth=.5pt bordertopcolor=white borderleftwidth=.5pt borderleftcolor=white borderrightwidth=.5pt borderrightcolor=white] ; Column region YY4_DOB,Percent dummyvar; Define region / group style(column) = {cellheight=.23in cellwidth=1.0in vjust=bottom just=left borderleftcolor=white borderleftwidth=.5pt borderrightcolor=white borderrightwidth=.5pt paddingright=.05in}; Define yy4_DOB / across style(column) = {cellheight=.23in cellwidth=1.25in vjust=bottom just=Middle borderleftcolor=white borderleftwidth=.5pt borderrightcolor=white borderrightwidth=.5pt paddingleft=.05in}; Define Percent / display style(column) = {cellheight=.23in cellwidth=1.25in vjust=bottom just=left borderleftcolor=white borderleftwidth=.5pt borderrightcolor=white borderrightwidth=.5pt paddingleft=.05in}; Define dummyvar / computed noprint ; compute dummyvar; dummyvar = 1; endcomp; Run; ODS rtf CLOSE;     This causes the following type of output. This is largely what I'm after, but I want the 2nd and 3rd lines to be less bold, and I can't figure out how to get it to display all the estimates without having all that space--this does not show up in the SAS output itself. Those estimates are a the result of a concatenation of 3 other variables in a previous data step:       Percent=Row_Percent || "%(" || Lower_CL || ", " || Upper_CL || ")" ;   How do I get rid of the extra spaces/wrapping AND how do I get rid of that "The SAS System" at the top? ... View more

I have a dataset table that I want to ultimately transpose:    Year PCP_Visit_past_year n Row_Percent Lower_CL Upper_CL 2016 Yes 628 84.6800 81.2606 88.0995 2016 No 110 14.5566 11.1867 17.9265 2016 Never vist 7 0.7634 0.0458 1.4809 2017 Yes 805 87.8194 84.9743 90.6645 2017 No 108 11.8672 9.0415 14.6928 2017 Never vist 4 0.3135 0.0000 0.6998 2018 Yes 583 86.1388 82.9866 89.2909 2018 No 82 13.2549 10.1490 16.3609 2018 Never vist 4 0.6063 0.0000 1.2480 2019 Yes 537 84.6572 80.5744 88.7401 2019 No 100 14.9445 10.8877 19.0013 2019 Never vist 6 0.3983 0.0000 0.9672 2020 Yes 492 84.5874 80.6830 88.4919 2020 No 94 14.3637 10.5594 18.1679 2020 Never vist 8 1.0489 0.0061 2.0916   I'm going to drop the frequency first, then I plan to use Excel to concatenate Row_Percent with the lower/upper CL --> % (95% CL) <-- and finally change this around to show: PCP_Visit_past_year 2016 2017 2018 2019 2020 Yes % (95% CL) % (95% CL) % (95% CL) % (95% CL) % (95% CL) No % (95% CL) .. .. .. .. Never vist % (95% CL) .. .. .. ..   But being the lazy person I am, there are probably 2-3 dozen tables I have to do this for--so how do I use SAS to make this easier? ... View more

I have an interative macro code that runs crosstabs (with proc freq, of course) for each variable in a list that is stored in a macro, then saves each crosstab table as a separate dataset in a permanent location.   I would like to do something similar, but print out each of those datasets to a single Excel sheet so i can ultimately apply a custom table style and chart template to them.   My current iterative code is below: %let varnames= list_of_variables; *2) Iterate through the macro list; *2a) ODS selects only crosstab tables to print; %macro dothis; %do i=1 %to %sysfunc(countw(&varnames)); %let thisname=%scan(&varnames,&i,%str( )); *PROC FREQ, output ODS tables; ODS Select CrossTabs; ODS output CrossTabs=year_&thisname; Proc freq data=rollrpt3 Tables year*(&thisname) / row cl nostd nototal; Run; *OUTPUT SIMPLE TABLES TO PERMANENT LOCATION; Data AUTOLIB.year2_&thisname; Set year_&thisname; DROP Table F_: WgtFreq Percent LowerCL UpperCL _SkipLine; Run; ods excel file='C:\Summary Reports_2018-forward\Rolling Reports\AUTOLIB\Exports.xls' style=JOURNAL; PROC PRINT NOOBS DATA=AUTOLIB.YEAR2_&THISNAME; RUN; ODS Tagsets.ExcelXP CLOSE; /*OUTPUT PERMANENT SIMPLE TABLES TO EXCEL wORKBOOK; proc export data=autolib.year2_&thisname outfile="C:\Summary Reports_2018-forward\Rolling Reports\AUTOLIB\Exports.xlsx" dbms=xlsx replace label; sheet="&thisname"; run; */ %end; %mend; %dothis   ... View more

I'm trying to run a simple proc surveylogistic using one variable at a time to retrieve trends overtime for each variable. I don't want to have to copy/paste the variables each time and re-run (there are 55 of them, total). So I thought about creating an ARRAY containing the list of variables, and telling SAS to iterate through that list, one at a time, then finally print each of those "final outputs" into the results window.   But I'm not sure how to do this. Or if there is a better option, considering I have to create the ARRAY in the data step, then somehow pass it to the proc step? Below is an example of what I've been attempting, based off a suggestion I saw elsewhere on another forum:   *Create array list; ARRAY roll [4] var1 var2 var3 var4; DO i=1 to 4; *Select only table of interest; ODS Select ParameterEstimates; ODS output ParameterEstimates= roll[i]; PROC SURVEYLOGISTIC Data=rollrpt3 Total=TOTALS_DATASET NOMCAR; Weight wghtvar; Strata strat_var; Model roll[4] = year; Run; ODS close; *Print estimate and its associated P-value for trend; Proc print data=roll[i]; Var Variable ProbT; Where Variable="year"; run; Quit;   ... View more

I have an odds ratio that is 0.88 (95% CL: 0.78,0.99). I'm keeping decimals to 2 places, so is it technically still fair to consider the OR estimate statistically significant (since it still doesn't contain 1.0 when using 2 decimal places)? Or for publication purposes, would something like this be downplayed?   ... View more

I have 2 numeric variables for day and month respectively:  DD_LV and MM_LV. I also have a general YY_ variable for year.   I know I have to turn them into character variables first, but I ultimately want to concatenate them into a single MM/DD/YY date variable.    What's the most efficient way to approach this?  ... View more

I'm building two race-specific models using complex survey data. As a part of this process, I want to check for collinearity, which I haven't done outside of the classroom, which was a couple years ago.   Anyway, when I check for collinearity, I planned to use the regular PROC REG procedure. Do I also include the stratification variable, or since it is being stratified/controlled for anyway, can I exclude it?:   Proc REG data=fluvx; Model flu = rec_shot race2 age edu fpl reg_status bpinsur dpinsur marital_stat / VIF TOL COLLIN COLLINOINT ; Run; ... View more

I've just gotten SUDAAN installed to use the SAS-Callable features.  But when I run procedures, it keeps giving me this error in the log:   842 proc crosstab data=other.fluvx design=strwor; ---- 22 76 NOTE: An external program, not a SAS procedure, is being executed. ERROR 22-322: Syntax error, expecting one of the following: ;, AUDIT, CC, CLEANUP. ERROR 76-322: Syntax error, statement will be ignored.   I originally had the dataset saved as a WORK. dataset, but read somewhere that sometimes Sudaan can't recognize .WORK, so I saved it in a permanent library. But that doesn't work either.   Any ideas?  ... View more