Skip to content

Instantly share code, notes, and snippets.

@statgeek
Created May 6, 2021 23:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save statgeek/42b3eafdb7f94820f1ae25cce00a362f to your computer and use it in GitHub Desktop.
Save statgeek/42b3eafdb7f94820f1ae25cce00a362f to your computer and use it in GitHub Desktop.
SAS - Conversion between types
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