Dear Team, Iam creating a table and the table needs to show nE/100PY calculations , below is the requirement    1.If event – person time ends when the event occurred 2.If no event, person time is the entire study time for that patient  if event i am calculating ASTDT-TRTSDT  and if no event ( no AEs) those patients we need to create from ADSL RFENDT - RFSTDT    how to proceed with this ,is there any macro available      ... View more

  See the below requirement , i want the 3rd column , please see the Week5 here 2 subjects achieved response , so the count of subjects will be 2 .. like wise i need to create a dataset        Visits where response achieved  Sub No who achieved response  Count of Subject Number week1 4 1 Week2 3 1 week3   0 week4 1 1 week5 2, 5 2       ... View more

The code you have provided will give number subjects in each visits.. i want how many visits have got each subjects . the below example code will give the desired result, but i am not able to add the corresponding visits in to it, if i add the results are going different , pls see my code  proc freq data=mn ; tables usubjid/out=temp(rename=(count=count1)); run; proc freq data=temp; tables count1/out=temp1(keep=count) ; run; ... View more

This count is correct , but I want to show the visit column also in the dataset.. that is my exact requirement ... View more

I want it as a dataset ... View more

i have the example data  here we can see the visits number 8 having 2 subjects so the count of subject is 2 here , this is the brief of the data we have    Visits     Sub  count                                                                                                 5            3            2                                                       6                           0                                                       7            1            1                                                       8            5           2                                                       8            5           2 ... View more

I have used below codes and got the counts correctly as i required, but i need to show the corresponding visits also to the data. could you please modify my codes on    proc freq data=mn ; tables usubjid/out=temp(rename=(count=count1)); run; proc freq data=temp; tables count1/out=temp1(keep=count) ; run; proc freq data=mn ; tables usubjid/out=temp(rename=(count=count1)); run; proc freq data=temp; tables count1/out=temp1(keep=count) ; run;   ... View more

  Please find the data and the code below which i have.  ods trace on; ods output Association=or2 GlobalTests=GBLT_2; proc logistic data=mydata outmodel=stat_3; class gender (ref="F"); model improvement(event="Y")=result gender gender*result / clodds=wald; run; ods trace off;   improvement Result Gender  Y 12 M N 13 F Y 14 M Y 15 F Y 16 M Y 17 M Y 18 F ... View more

Hi I have used the code,.. the problem is that I am not able to get the ODDS ratio   ... View more

 Hi I have found a sample code, but i needed the below results for my requiremnt. I am not understanding how to pass the proper variables and options . the requirement below  Covariate Estimate Odds Ratio 95% CI Wald Chi-Square P-value Results  xx.xx xx.xx xx.xx xx.xx xx.xx Male xx.xx xx.xx xx.xx xx.xx xx.xx Female  Reference Reference Reference Reference Reference Results*Male xx.xx xx.xx xx.xx xx.xx xx.xx Results*Female Reference Reference Reference Reference Reference ... View more

need to check the Pvalue for first visit(Baseline) and all other visits ... View more

As you suggested the first method I have changed and it works...but in second method i need to show baseline VS all other timepoints (i.e visits) ... View more