Welcome to clinical data management program using SAS. In this video we will be discussing about the further modifications of tabulated reports. So we'll be using the same procedure called proc tabulate that is proc tabulate data equals CDM dot disease, their marital status, we are again working with filter data. That is we want report to be created or to be formed only with respect to marriage married patients. caregiving class, disease, gender, bar, the internet use table disease comma, gender start dealing with us. So let's run this code to see if we have got disease wise disease wise and gender wise the sum of the daily internet users that is there are total 617.47 daily internet users for patients who are female and who are suffering from Alzheimer's disease.

Similarly for male to 680 4.06 Similarly, there are total say 160 point seven zero gastritis patients castrate his female patients there are total 160 point seven daily internet users gastritis female patients Similarly, there are 204 that is 204.33 gastritis made users guess it is male daily internet users. So, we have got previously used to get the category wise count values here we have got the categories device, some values for daily internet use, because we have given disease common agenda that is we have, we want a tabulated report with respect to disease and gender and we want our report to have the analysis variable called daily internet use and by default, then the some analysis is done with respect to daily internet use. Therefore, we have also given the vast statement that is our daily internet use class disease genders for categories. So we are categorizing with respect to disease and gender but in place of count we are getting the sum of daily internet use because we have specified daily introduce as our analytical variable or we going to be a specified date introduces an analysis variable now instead of some software If we want to display the mean then how do we do that?

That is here we were getting some in case of count but now we want me in case of some you know, how do we go with it we'll be using the same procedure called proc tabulate data equals CDM dot d disease were marital status equals married. Class, disease gender. This is a categorical variable with respect to which the report will be categorized. Again I'm doing the report with respect to only the patients who are married. You can remove the filter if you want. var daily interest use this is my analysis variable, then table disease.

Comma Jen gender start daily internet use here we give Starmie no mean because we we only want the Institute of some in place of some we want the mean of data introduced to be displayed and then rack so here the same thing we are doing we are displaying the report with respect to the patients who are married and we categorize in the report respect to disease agenda that's only a given disease and gender in class statement has been a staple statement because TABLE statement we are going to tabulate the report with respect to the categorical variables and then we have displayed daily internet using the var statement to define our analysis variable. And by default analysis, the analysis that is done with respect to the analysis variable to sum over here will be doing me so let's run this code. So here see the mean is displayed.

So the mean the average number of daily interest users who are females suffering from Alzheimer's diseases hope earning that is 4.9 for daily internet users the average number of daily internet users who are famous suffering from Alzheimer's disease proper name for similarly chemo patients suffering from hypertension for that is the average number of daily internet female patients suffering from hypertension is 4.82. Similarly for male patients is opening faith and in this way it goes on now we'll be doing a further modification of our tabulated report that is, we want to display the individual mean as well as the grand mean as well as the total knee we will be displaying individual min total mean and grand mean. So for that, how do we go load we'll be using the same procedure called proc tabulate. Data equals CDM dot disease where marital status equals married class disease Gender, Bailey internet use PayPal disease, karma, gender, baby internet use and then start mean this this will give the mean values present Some are in Slovenia the statistics suddenly add by default will get me next year giving all star daily internet use stop me All Star deleted you start mean this this is used to give the individual mean as far as the grand means will be getting getting the total means as well as granting with respect to this statement that is all start dealing to reduce standing and then let's run this code to see over here we have got the individual means that is and as well as the grand means the total means of the Grand means that is the average number of female patients is the average number of female data introduces suffer as I was discussing open info male and reduces suffering from Alzheimer's disease it's opening to add the total average versus average number of days reduces suffering from as Ms is opening.

Same way we see multiple sclerosis the average number of female dead introduces suffering from multiple services is 4.6 for average number of main internet users suffering from multiple sclerosis 4.68 and the total average number of dead introducers suffering from multiple sclerosis is 4.66. So this is we are getting the individual mean as well as the grand mean so in this video we'll be doing here in my next video I'll be discussing about exporting data before I move to the next video I need to also explain your few concepts that is see in till now, we have only got mean or some statistic that is in a tablet read reports if we want to keep analysis variable views to analyze the variable we analyzed the variable with respect to me or some instead of mean or some you could have also got admits that his number of missing observations STD standard deviation mean minimum max maximum well range range of errors median middle Val so in place of mean if you write all these values, you will get all these statistics so in this video I'll be doing till here in a coming video I'll be discussing about exporting data.

Thank you Goodbye. See you all for the next week. You