Hello I wondered if I could get some help me get started with the correct SAS syntax required to perform the following tests on my data. using the example Cohort/variables I have made up below . Statistical significance of differences Continuous variables - Wilcoxon rank sum tests prior to matching . Statistical significance of differences Continuous variables - Wilcoxon signed-rank tests post-match. Statistical significance of differences Categorical variables,prior to matching will be assessed using chi-squared tests. Statistical significance of differences Categorical variables, after matching using McNemar’s tests.                                                       Disease Cohort                        Control Cohort Cat Variables        Diabetes(yes/no)              1                                           0                              Gender                              1                                           2 Continuous Variable  Age                             80                                          30                                Once I understand the basic syntax I can then incorporate it into a  macro to run over all my categorical and continuous variables. Many thanks in advance. ... View more

I am trying to output to the following proc report to a  PDF file using the following code.  However my narrative variable  gets truncated if it is longer than one PDF page. One page is fine but if it spans over two pages it is truncated at the end of the first page. Does anyone have any help on how to stop the truncation of the narrative field. Many thanks. proc report data=patient headline headskip split='\' nowd; where casenumber=&casenum; column casenumber narrative comment_text abbrev_narrative seriousness_desc serious_notes causality     agent_notes listedness listedness_notes outcome_desc; define casenumber / order id noprint; define narrative / display  width=50 'Narrative' flow; define comment_text / display  width=50  Analysis Statement' flow; define abbrev_narrative / display  width=40 Comment' flow page; define seriousness_desc         / display  width=20 'Case Seriousness'; define serious_notes         / display  width=20 'Notes' flow; define causality     / display  width=10 'Case Causality'; define agent_notes     / display  width=20 'Notes' flow; define listedness     / display  width=14 'Listedness Determination'; define listedness_notes / display  width=20 'Notes' flow; define outcome_desc / display  width=20 'Case Outcome' page; compute before _page_; line @3 'CASE ASSESSMENT'; line @4 ' '; endcomp; ods pdf startpage=now; %macro loop(list=); %if %sysfunc(exist(work.check1)) %then %do; %* Initialize loop; %let i=1; %let casei=%scan(&list,&i,str(,)); %* Run loop; %do %while (&casei ne); dm 'odsresults; clear'; ods listing close; options papersize=a4 leftmargin=3.5 cm rightmargin=3.5 cm; ods pdf file = "C:\temp\CaseNumber &casei..pdf" style = sasweb; ods escapechar='~'; footnote1 j=c 'Page ~{thispage} of ~{lastpage} '; footnote2 j=r 'Report Generated on ' &sysdate9; ods pdf startpage=no; %* Do processing for this iteration of the loop;    %put PROCESSING CASE NUMBER &casei;    %casereport(casenum=&casei);    %* Prepare for next iteration of the loop;    %let i=%eval(&i+1);    %let casei=%scan(&list,&i,str(,)); ods pdf close; ods listing; %end; %end; %else %do; %display logonerror; %end; dm 'odsresults; clear'; %mend loop; ... View more

Hello, I am trying to create a line graph showing Hazard Ratio over time  using the following axis below: Hazard Ratio    6                          5                          4                          3                          2                          1                          0                             0        20       40       60       80       100     120    140                                                Time I have create the hazard ratios for the tables but am unsure now how to plot them and what procedure I need to use to create the plot.  If anyone can help to get me started that would be great. Here is the syntax used to create ratios: Proc phreg data=&infile; class exposure; Model personyrs*outcome(0) = exposure &covariates trtt /RISKLIMITS;; trtt = exposure*log(PersonTime); test_proportionality: TEST trtt;         ods output ParameterEstimates=HR&infile;         title1 "Proc PHREG for adjusted"; run; ... View more

I am trying to create graph plotting incidence rate of headache at -30 day intervals prior to baseline date I am unsure how to calculate the negative person time for each time point to create the rate. My graph will have the following x and y axis -365-0 for the time points and rates per 1000. rate per 1000 1 0.5 0 -365 -330 -300 -270 timepoint I have the following variables in my SAS dataset, Patient ID, baseline date (which will be represented be the 0 time point on my graph), headache (0/1), and headache date.  A patient can only have one headache max which is the earliest within the prior baseline 365 days.  Any help in calculating  the rate for each negative timepoint and then plotting it as a graph would be great. Many thanks, Lisa. ... View more