How can I convert a numeric variable to a character variable using the SAS programming language? 2

How can I convert a numeric variable to a character variable using the SAS programming language?

The process of converting a numeric variable to a character variable in the SAS programming language involves using the appropriate SAS functions and formats. This allows for the manipulation of numerical data into a string of characters, which can be useful for certain analyses and reporting purposes. By using the correct syntax and techniques, the conversion can be done accurately and efficiently in SAS. It is important to note that the resulting character variable may have limitations in terms of mathematical operations and sorting compared to a numeric variable.

SAS: Convert Numeric Variable to Character


You can use the put() function in SAS to convert a numeric variable to a character variable.

This function uses the following basic syntax:

character_var = put(numeric_var, 8.);

The following example shows how to use this function in practice.

Related:

Example: Convert Numeric Variable to Character in SAS

Suppose we have the following dataset in SAS that shows the total sales made by some store during 10 consecutive days:

/*create dataset*/
data original_data;
    input day sales;
    datalines;
1 7
2 12
3 15
4 14
5 13
6 11
7 10
8 16
9 18
10 24
;
run;

/*view dataset*/
proc printdata=original_data;

We can use proc contents to view the data type of each variable in the dataset:

/*display data type for each variable*/proc contentsdata=original_data;

We can see that day and sales are both numeric variables.

We can use the following code to create a new dataset in which we convert the day variable from numeric to character:

/*create new dataset where 'day' is character*/
data new_data;
    set original_data;
    char_day = put(day, 8.);
    drop day;
run;

/*view new dataset*/
proc printdata=new_data; 

Note: We used the drop function to drop the original day variable from the dataset.

/*display data type for each variable in new dataset*/
proc contentsdata=new_data;

We can see that the new variable we created, char_day, is a character variable.

Additional Resources

The following tutorials explain how to perform other common tasks in SAS:

Cite this article

stats writer (2024). How can I convert a numeric variable to a character variable using the SAS programming language?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-convert-a-numeric-variable-to-a-character-variable-using-the-sas-programming-language/

stats writer. "How can I convert a numeric variable to a character variable using the SAS programming language?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-convert-a-numeric-variable-to-a-character-variable-using-the-sas-programming-language/.

stats writer. "How can I convert a numeric variable to a character variable using the SAS programming language?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-convert-a-numeric-variable-to-a-character-variable-using-the-sas-programming-language/.

stats writer (2024) 'How can I convert a numeric variable to a character variable using the SAS programming language?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-convert-a-numeric-variable-to-a-character-variable-using-the-sas-programming-language/.

[1] stats writer, "How can I convert a numeric variable to a character variable using the SAS programming language?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.

stats writer. How can I convert a numeric variable to a character variable using the SAS programming language?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)
Slide Up
x
PDF
Scroll to Top