Hi all,   I am trying to create a SAS report that has some pages with 2 columns with one centered header for the section. Code and output below:   ods pdf startpage = now; ods pdf columns = 2; ODS TEXT = "~{newline 1}"; ODS TEXT = "~{STYLE[JUST = C FONTWEIGHT = BOLD FONTSIZE = 12PT]Study Stop}"; ODS TEXT = "~{newline 1}";    proc sort data=current.status_file; by descending stop_date; run; PROC REPORT DATA = current.status_file NOWD HEADLINE BOX SPLIT = "\"; column study_id stop_date ss_reason ssreas_othersp withdraw_reason; where ss_reason ne .;   define study_id / center "ID"; define stop_date / center order = internal "Stop Date" format = MMDDYY10.; define ss_reason / display center "Reason" format=ss.; define ssreas_othersp / display center "Other reason"; define withdraw_reason / display center "Withdrawal Reason";   run; ods pdf close;     I am able to get two columns using ODS PFF columns=2, but this then puts the header over the first column instead of at the center at the top of the page. Is there a way to center this in the middle of the two columns? I have tried to find something but have not had any luck, and anything I try gets rid of the two columns which is more important for the formatting than the title being in the middle. Thanks in advance for your help! ... View more

Hi all,   I'm having some issues with the below code and datasets. I am trying to use a proc sql left join to bring the two datasets together with a new variable, but when I do it adds an extra two from the second dataset instead of only joining to the two already existing in the first dataset. Code and pictures of the three datasets in order below. Thank you in advance for the help!   proc sql; create table eligs as select a. * , b. x_dupIPelig label = "Match with other Elig" as eligIP_flag from eligIP2 a left join eligIPdups b on a.screener_ID = b.screener_ID; quit;   eligIP2: Eligipdups:   Eligs(Created dataset):       ... View more

Title says it. I'm trying to create a program to add a password to an excel file using SAS but haven't been able to get it to work today. It worked a couple of weeks ago but I cant remember how or if I changed anything. Any ideas? Also an explanation of how it works would be great as well. Thanks!   %let ExcelFile = H:\Password Code Test\Password Code Test 4.xlsx; %let VBscript = H:\convert.vbs; %let password=test; data _null_; file "&vbscript" lrecl=200; put 'Dim xlApp, xlWkb, SourceFile, TargetFile'; put 'Set xlApp = CreateObject("excel.application")'; put 'SourceFile="' "&ExcelFile" '"'; put 'Set xlWkb = xlApp.Workbooks.Open(SourceFile)'; put 'TargetFile="' "&ExcelFile" '"'; put 'xlApp.DisplayAlerts=false'; put "xlWkb.SaveAs TargetFile, 51,""&password"""; put 'xlApp.DisplayAlerts=true'; put 'xlWkb.close'; run; options noxwait noxsync; x "cscript ""&vbscript"""; ... View more

Hi all,   I'm trying to do an interaction assessment for a dataset I have using dummy variables coded as different smoking statuses and a lifestyle score I have been using. However, when I try to multiply these together to create a variable to use in the analysis, no values are created. Both variables are numerical with the score ranging from 5-25 and the dummy variables being coded as 0/1. Code posted below:    ecl_nonsmoke = ecl2_score*dummy_nosmoke; ecl_cursmoke = ecl2_score*dummy_cursmoke; ecl_forsmoke = ecl2_score*dummy_forsmoke;   The proc freq I run afterwards shows that all values for the newly created variables are missing, even though all the observations in the dataset have values for the score and the dummy variables used in the calculation. Any ideas why this could be happening? Thanks! ... View more