Welcome to clinical data management program using SAS. In this video, we will be discussing about enhancing reports with titles, footnotes and labels. We will be working with our disease data set which we were working before and you know in order to get the datasets in the SAS environment, you have to execute the librium statement. So I have already executed the librium statement and this is my CGM library inside which I have made the disease data set to this Mary's disease data set. Even before it consists of ID gender, date of birth, zip code, employment status, education, vital status, children ancestry, average commute daily internet use available vehicles, military service disease, these are the different columns of my data set disease. So these are these this data set deals with the patient records, that is the patient details that is the patient name, the patient gender, their date of birth, their zip code, their employment status, either retired or employed, level of education, their marital status, number of children that they have their ancestry, the average commute the daily internet, use A number of available vehicles military service and what are the diseases that they're suffering from?

So first I'll show you all how to incorporate label in your report the concept of label can be incorporated in a report as well as it can be done in a data step manipulation. So first I will explain you on how to incorporate it in report for that we'll be using a procedure called PROC PRINT. So PROC PRINT data equals CDA doc disease. label is a key word to incorporate labor in your labor in other words can also be set a secondary need that is a variable can have two types of name one is primary name and money second secondary name say foster for example, you have a variable name called f name. What do you want to represent that F name in your data such as first name, so first name is the level of your variable, ethnic but you need to remember something that whenever you are calling a variable you have call this call by its primary name.

You can never call it by its label or secondary name. So Label Label, I'm labeling average commute is a VG underscore commute. Primary name of the variable equals average commute. I'm better naming a variable for children as normal number of children. And then before I run this report, let me expand on that this is a way by which you can check a label so you have to double click on the column when you see that this variable has a primary name for it, but this time does not have a label, the label which you are incorporating in a report, it is a temporary label it comes only for that particular report but it does not stay throughout the data segments the labels are permanently incorporated within your data set. So, before you do any sort of analysis before you do your data set, you upload this chart the label of every variables that whether it has got any label or not.

Sometimes you also see that the variable name in the data is given by its label, but if you call a variable name by label that particular variable cannot be accessed SAS will never execute if you call a variable name call a variable by sleep. So therefore it is very much necessary to check whether a variable is having a label or not. And you have to always use the primary name of the variable to call it the so this is a way you can incorporate label in your report. So let me run the code. So we have done PROC PRINT data equal to CJ is my library name dot disease CD and I have created by exhibiting a live name statement then label is the key word to incorporate the label. Then again using the key word label Want to label these two variables ABG underscore commuted for to average commute and children equals to number of children.

So let me run this code up this label statement is this is one statement. So after you complete the whole labor statement, then you hit the semicolon. To see the children is getting increasing number of children to the no children the report is displayed as number of children and Asians who commute is displayed. So this is a way you incorporate labeling your report now we will learn how to incorporate title in our report. So we are going to use the same procedure that is doctrine so PROC PRINT data equals CD in this mini library taught disease. semi colon var.

Var is used for variable specifications. You have to specify the variables in the var statement which you want in your report or a new property report. So I'm going to specify ID gender. I'm using variable specifications to make my report more concise. So here I'm specifying the variables as Id gender DOB that his date of birth, average commute, average underscore commute, daily interviews. These are the variables I want to display my result viewer on my report.

Now I'm going to incorporate the title that is titled. Then within double quotes on incorporating the title escalation details, you can give any title you want, but make sure you write it within double quotes. And then before I run this code, let me explain to you all what is title in SAS. By default, you have a title as the SAS system and there are certain features which are there for titles, which you remember title appears at the top of the page. The default title is the SAS system, the value of n can be from one to 10. What do you mean by end here you can give some title number which lies between one to 10 if you do not give any title number then it is taken as Title One By default, and I'm number title is equivalent to title one that is if you do not give any value of n then it will be taken as Title One titles remaining effect until they are changed, canceled or you end your session.

That is unless you do not change your title then your title will remain the same which you have given before and will remain same antennas you don't in India sets have cash and if you write title and semicolon that is a negative statement that will help you to cancel all the titles so now let's run this code you have to give semicolon in every statement you write in SAS otherwise SAS will executed properly to see this is the title of my report that is patient details the data portion of the data set diseases displayed and these are the variables which has come that is ID gender Date of Birth average computer daily internet use, these are the variables which are specified in the VA statement I got additional column as observation column that is observation number and the serial number column is the additional column which you have got in your report.

So this is how you incorporated In our code now I teach you all how to incorporate label in data manipulation. As you all know that label is basically a secondary name of a variable. A variable can have two types of names. That is what this primary name is saying rename. Say for example, if you have a variable name called f name, and F name is the primary name of the variable. Now you want to incorporate a secondary name to the variable as first name to make the report to or to make your dataset more readable, then you can use the concept of labels we have discussed about how to incorporate label in a PROC PRINT report, but that incorporation was temporary nature because the label was only coming in my report.

But suppose if you want the label to come in your data set, which will happen permanently it will get incorporated inside your data set permanently, then we have to use the concept of data step and we have to incorporate the label in data manipulation on origin DATA step. So now I'll teach you how to incorporate label in data or data manipulation. So I'm forming duplicate data set called d 20. I'm forming the So instead work you can form it anywhere you want in any library, then set CDM dot disease. So CDM for disease is my input data set. So this disease data set is getting kaput inside the 20 data set that is the duplicate data set, which I'm creating and work to D 20s.

Duplicate data serves a copy data set of the diseased data set which is present in sets EDM, so diseases may input data set and D 20s. May output data set. Then I'm using the keyword label. I'm labeling DOB as Date of Birth ID as a patient need. So this is the end of my label statement non giving semicolon and then so this is my CDM disease data sets II my DOB variable does not have any label. This is how you check the label of a variable you double click on that particular column and you get to know whether the variable has a label or secondary name or not do we also does not have any label and Id this variable also does not continue With our secondary needs now run this code, I can check the results in my D 20 dataset because there is a data manipulation so I won't get any result we were let's open the D 20 data set it is treated and said work.

That in the data the ID is now displayed as patient name and DOB is described as Date of Birth if you double click on this column, so patient name is the secondary name of my ID variable and date of birth is the secondary name of my DOB variable. This got permanently incorporated inside the data. Now I show you on how to incorporate footnote in your report, not a corporate footnote in your report, we are again going to use the same procedure that is proper and we will do PROC PRINT. data was CDM dot disease. We are using the keyword footnote in corporate footnote footnote is always incorporated at the bottom of the report. And in SAS, you do not have any default footnotes.

Like in case of title, you have default hightailing sack. That is you get the SAS system as a default title, you do not get any default title for footnote. In my report, I am giving footnote as hospital records. And then I'm running before I run this code. Let me explain to you a lot of the features of footnotes. Footnotes have the same features almost the same features as titles footnotes appears at the bottom of the page, no footnote is printed unless one is specified the value of n can be from one to 10.

That is, you can also number of footnote like title and unnumbered footnote is equivalent to footnote one if you do not give any value to end then it is equivalent to footnote one footnotes remain in effect until they are changed, cancelled or you end your SAS session. The non footnote statement cancels all footnotes. So let's run this code. So patient details was my title and hospital Because this means in this video we will be learning to hear in my next video I will be discussing about beauty frequency reports for now. Let me end this video over here. Thank you Goodbye.

I'll see you for the next video.