The structure of the expression looks like this: PUT(num,Z6.) The formatted value is then stored as a character string.īecause you want to create a character string with three leading zeroes, you will use the Zw. The PUT function converts a numeric variable into a character string, using the appropriate format that corresponds to the numeric value. You will now perform similar tasks in order to convert the numeric value to a character value, except you will use the PUT function instead of the INPUT function. Click Close to return to the Query Builder where you should now see the calculated column in the query builder.Ĭonvert a Numeric Value to a Character Value Click OK to exit the Advanced Expression editor, and then rename the variable from Calculation1 to a name of your choice.The expression should now look like this: You cannot get a list of available informats through the Advanced Expression Editor, so you must select the second placeholder and type MMDDYY10. Then, select the placeholder in the Expression text box and click Add to Expression. Click the Data tab and select the DATE variable.In the Category list, scroll down to Special, select INPUT(character) from the Functions list, and then click Add to Expression. Using the Advanced Expression Editor, click the Functions tab.The second argument is the appropriate informat and width. The first argument to the INPUT function is the variable that you want to convert. The structure of the expression looks like this: INPUT(date,mmddyy10.) For the date values in the sample data set, you need to use the MMDDYYw. The INPUT function converts character strings to numeric values, using the appropriate informat that corresponds to the character string.įor example, if you had a value of 08MAR2000, you would use the DATEw. Working with the character date value first, you will use the INPUT function to create a new numeric SAS variable. Click Computed Columns and then select New ► Build Expression to open the Advanced Expression Editor dialog box.Ĭonvert a Character Value to a Numeric Value.Display the Process Flow window, right-click on your sample data set, and select Query Builder.DATA SAMPLE Īfter you submit the code, the table opens automatically.
#SAS CONVERT NUMERIC TO CHARACTER CODE#
To create the sample data, you can select File ► New ► Code and submit the DATA step code shown below in the SAS Enterprise Guide code node.
convert a numeric value to a character string, adding leading zeros to the value (leading zeros are not retained in a numeric value).convert a character date variable into a numeric SAS date variable.
#SAS CONVERT NUMERIC TO CHARACTER HOW TO#
This sample will illustrate how to convert variable types by using the Advanced Expression Builder. SAS Enterprise Guide enables you to create new variables (computed columns) by using the Advanced Expression builder within the Query Builder. SAS does not allow you to change the type of a variable that is already defined, so a new variable must be created. This conversion is done by using the PUT and INPUT functions. One very common data manipulation is converting a variable type from either character to numeric or from numeric to character. However, if you want to manipulate data, such as changing date values or parsing a character string, then you will need to employ some SAS programming knowledge in order to achieve your goals. SAS Enterprise Guide provides easy access to data sources through a graphical interface, which means that 99% of the time you can work in SAS without knowing the SAS programming language.
0 kommentar(er)
