Welcome to clinical data management program using SAS. In this video we will be discussing about the practical session of clinical data management using SAS. So I'll be using the SAS software to explain you all the practical session. So first topic that we are going to cover in this video is accessing data. That is how to get data sets in SAS environment or how to get data sets in SAS libraries how to import SAS data sets. In our last video, we have discussed about the different types of libraries that are there in SAS that is permanent library and temporary library.

Permanent libraries are the SAS inbuilt libraries, as well as the library that we create using the live name statement and temporary library is a work library, which is by default empty the data sets that we create in the temporary library or work in our SAS session. The moment we close our session or end Association those data sets from the work library gets vanished only the work library remains. Similarly the power library that we create using the live name statement gets vanished from The end of class session we need the SAS inbuilt libraries remains. So now first we learn how to create our own library, which will create a permanent library. So that we'll be doing using a lignum statement which is a global statement. So we'll write live name.

I'm writing the name of the library a CD, that is I'm giving the name of the library, a CDN, that will give the path to see I'm taking the path of this folder. Then this is a global statement. So it is always executed individually. After the end of the statement, we have to give a semicolon. So let's run this code. You do not need a run statement particularly blooms statement because it's a global statement.

See this is empty library they have found. Okay now let's learn how to import a data file. into this library CD will be importing a data file and Excel file, which is a clinical data into our CDM library. For that we'll be using the procedure called proc import data file. So we are reading proc input data file equals two we have to give the path where our Excel file is located. So this is the part where our Excel file is located we are taking the path from here.

This is the back of her Excel file. The data that we are going to work with this data dot CSV so we'll copy the name of the Close it of course, remember never give semicolon in the proc import database statement. Because this is just a line this is not a complete statement, then we you are out statement out equals two CDM dot disease. This means that the data file or the Excel file that we are importing that is data dot CSV that will be created inside the library CDM and the name of the data set will be disease like after this data dot CSV file comes in the SAS environment the name of the SAS data set will be disease which will be created inside the CDM library then we are giving the command replace so after replace you have to give a semicolon so this is a total one statement from proc import in replaces one statement and then you could run right run in a different line or as you know that You can record multiple statements in one line in SAS, provided that each statement is Vyas and coded.

So that is up to you. But we generally write each statement in each time because that looks more structured and that is convention. So let's run this code. So, see this is the easiest data set. This is our data set consisting of the patient ID, the gender, the date of birth, the zip code, the employment status of the patient, the education, the marital status, number of children, they have their ancestry, their daily internet use the number of available vehicles, the military service, whether they have military service or not, and what are the diseases they are suffering basically, this data is like that more amount of average commute they have or more amount of daily internet use, they have they are more more prone to such diseases. Like for example, if a person uses locks, a lot amount of internet or a person travels a lot amount of distance, so he he or she might suffer from lots amount of hypertension because his or her heart should be more hectic.

This is the this is our data that we're able to work with. So in this video we'll be doing till here in our coming video we will be dealing with how to explore our data. So we will be doing few procedures of how to explore our data. So for now, let's end this video here. Thank you Goodbye. See over for the next video.