Created
May 6, 2021 23:08
-
-
Save statgeek/42b3eafdb7f94820f1ae25cce00a362f to your computer and use it in GitHub Desktop.
SAS - Conversion between types
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
data char_num; | |
char = "8.4"; output; | |
char = "10.5"; output; | |
run; | |
data char_date; | |
char = "2012-01-01";output; | |
char = "2014-02-08"; output; | |
run; | |
data char_currency; | |
length char $12.; | |
char = "$1,230,000";output; | |
char = "$500,000.45"; output; | |
run; | |
data convert_char1; | |
set char_num; | |
num = input(char, 8.); | |
run; | |
data convert_char2; | |
set char_date; | |
date = input(char, yymmdd10.); | |
format date yymmdd10.; | |
run; | |
data convert_char3; | |
set char_currency; | |
dollar = input(char, dollar20.); | |
format dollar dollar20.2; | |
run; | |
proc print data=char_num; | |
proc print data=convert_char1; | |
proc print data=char_date; | |
proc print data=convert_char2; | |
proc print data=char_currency; | |
proc print data=convert_char3; | |
run; | |
data convert_num1; | |
set convert_char1; | |
char2 = put(num, 8.1); | |
run; | |
data convert_num2; | |
set convert_char2; | |
char2 = put(date, yymmddd10.); | |
run; | |
data convert_num3; | |
set convert_char3; | |
char2 = put(dollar, dollar20.2); | |
run; | |
proc print data=convert_num1; | |
proc print data=convert_num2; | |
proc print data=convert_num3; | |
run; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment