Welcome clinical data management program using SAS. In this video I'll be teaching you on how to convert numeric data types to capture data types and to convert character details to numeric data types. So first, we are going to convert the numeric data types. For that we are going to use data set we will be using the disease data set which we were using before. So we are first going to former output data set named D one I can form the output dataset anywhere I want. So I'll now put it as a can be created inside CDM library or any any other library or work library.

I'm creating it inside CDM in embedded in the work library, so data driven that I'm doing set here I'm specifying me input data set that is deeper disease. Before I do this, first let me tell you all in the disease data set I'm basically converting zip code zip code See it's numeric data type. If you double click on zip code you're getting it is a numeric data type I'm converting that into character data. Sets he gave no disease. Now convert a numeric variable to a character variable or numeric data types meditator to have a narrative we are going to use the put keyword, so we'll be using put it put comma, add the comma over here. When we are converting numeric to character, always remember that the format that we specify over here it is a format is the maximum length.

So we have given 64 format and then we are doing wrong Let's run this code you have opened the D one data set check your results this region network This is your D one data set this is it good Zipcar. So my zipper on which was a pure numeric variable it is converted into a character variable. How do we understand we double click on it and we see that exactly sousaphone is converted to academic. Now, they will learn how to convert immediately convert capital you may be having to learn two procedures one is automatic conversion. Another is to use explicit conversion. So, first let's do the automatic conversion.

For this we only use the recursive name to it is there the CDA plugin So let me first open the data set D to E this data set has got variables ID, gender, DOB, zip code, province status education, marital status, children ancestry average commute, they interrupt us available vehicles military service disease and see what and there are around 2000 observations in this data set. So, he will be converting seven which is a character variable to a numeric variable. So, first we have to do the automatic conversion. In automatic conversion we basically apply any mathematical operation to our active variable or any assignment statement mathematical assignment statement of the character variable to convert it into a numeric variable. So, over here, we have Want to calculate a variable c two which is a set of cx which is a clear mathematical operation so the result in any SQL that we will get it will be a numeric variable.

Let's do this data deep when I'm going to create the data set inside work library, it is not compulsory to create any data sets that work library you can create the data set in any library you want. Here in data statement, and specified may output data set in said statement I'm specifying my input date as the CDM broadly to semicolon now I'm doing the automatic conversion statement that is the assignment statement the mathematical operation where C two will be equal to 10% of C what we can write it like 0.10 in C one Linda Let's run this code. This data set that we have created d 12. This data set is created is our work. So we have to check the work library to check our results. So this is Missy one and is seeking which is 10% of Siva.

Now let's check the data type of see to not have to check the data, we double click on the column, you see that see there is no numeric erotic. So we had a mathematical operation on our variable CR, which is a data type. And the result variable that we got C to is converted number numeric data type. So this is one way of converting a character variable to do with variants. This is called the automatic conversion. The next is we're going to do an explicit conversion.

So for that, again, I'm using the data set cd 32 two for that first aptitude output data set I'm creating output dataset name depot. Inside work I can create the output dataset in any library I want my input data set is set CDM dot d two I'm creating a variable c three where I will write my explicit conversion statement c three is equal to input input statement like in our first case when we are converting numerical data we will use input statement to convert numeric factors. In order to convert character to numeric or explicit conversion we use industry. So we'll use input bracket Siva, comma 4.2. Now, I think I told you that when we are converting on numeric to a character data at least this way format over you. As a put parameter format is argument of the put function, but when we want to convert a numeric data type, the parameter or the argument that we provide for the input function that is in format, this is in format notice the concept of format and in format format is basically converting the SAS format to a user defined value.

And in format is converting a user defined variable or SAS format. But in case of a numeric variable, it is very difficult to differentiate between a format and in format. Because we're a numeric variable. Even if you put a user defined formula or if you put the SAS SAS format, the value remains safe. It doesn't change. The concept of in format is better understood when you work with a date variable.

Suppose if you have a date variable and you apply an in format on it, then that value will be converted into a SAS format. That is what is SAS format. That is the difference between the SAS base Did and the data is specified so here in the input statement the function the inside my input function I have specified in format and then I'm getting so let's run this code if you open the data depot cc three is the C three variable citizen indicator, it is no more my C one was character dignity, your character dignity was seen c three is now numerical using explicit conversion and using the input statement converted the numeric so to convert any variable from numeric to character we use the put statement for quadratic numeric we can either go over the conversion or we can use the input output statement is basically a format for input statement a specific input So in order to check in datatype of the variables, you can double click on the various columns and then you can check the later time of the video.

For now, I will be doing till here in this video in my coming video I'll be discussing about merging and concatenation of data sets. Thank you. Goodbye. see you for the next video.