Welcome to clinical data management program using SAS. In this video we will be discussing about how to export reports we'll be using the concept of ODS, CSV all that is we will be exporting our result viewer in an ODS file or through ODS, that is output delivery system and the result will be exported to the result will be exported to a CSV file. So we are going to use the concept of old ODS, CSV file that is odious ODS CSV on file equals within codes will be giving the path and the results I'm going to save it in a file save the name of the file and GPS data to dot CSV now after read the procedures and learning the procedure say PROC PRINT, you can read it Any procedure which gender is resolved the word. So proper data equal to CDM dot disease, I'm using the disease data set which we have used before from the CDM library.
I have executed the live name statement to get new CDM library and the disease data set. I'm filtering the data when marital status equals magic. That is I want those observations to come or I want opposition to those patients who are married. I'm giving a footnote as hospital records and then run. This is me cold proc step. And now so that in me further steps that he puts doesn't get saved.
That is to terminate the saving of the future. Reports I'm using the concept of OBS CSV or close. So let me explain the code. I have used the concept of OBS CSV or find ODS, transport output delivery system and CSV or comma separated value on file. This is the part where I want to export the report and keep it in form of CSV file, I have given the name of the pilots data to dot CSV, you can give any name this is my report that is I'm printing the data portion of the data set disease located at CDM. I'm filtering the data I want only those observations where the marital status of the patients are married.
That is I want to have those observation to be displayed who are married. I want to display those observations or those patients who are married. I have displayed a footprint that is hospital records. And then I'm doing ODS is we all close. This I'm doing in order to terminate the saving. So let's run this code.
So see this is me CSV file data to you can also see the CSV file from here if you open data to rock CSV, so just Because in our sass data to file is opened, you can close it from here, the same fight you will see as a CSV file. So, you can just open data to your CSV to see the report got exported to data record CSV file, the location was given in the part that we have specified we filtered the data. So we have a provision for many observations with the same number of variables. This is you This is how you export any report. So you can export a report in form of CSV and store the results in form of a CSV file. So for now, let me in this video over here in my coming video, I will be starting with the concept of statistics.
I will be starting with the concept of descriptive statistics and inferential statistics. Thank you Goodbye. See you or for the next video.