BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dolbi18
Calcite | Level 5

Hi, i have to change the type of variable from numeric to character. I've tried several ways, but i always get an error or warning 😞

 

Variable "x3" is in BEST8. format and SAS uses numeric format, but i need x3 variable to be in character format.

 

Dear communities, how to do it :D? 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

You can not change the type of a variable once it is created. But you can convert a variable and assign it to a new variable like this

 

data test;
	format x3 best8.;
	x3=100.56;
	x3_char=put(x3, best8.);
run;

proc contents data=test;
run;

View solution in original post

3 REPLIES 3
PeterClemmensen
Tourmaline | Level 20

You can not change the type of a variable once it is created. But you can convert a variable and assign it to a new variable like this

 

data test;
	format x3 best8.;
	x3=100.56;
	x3_char=put(x3, best8.);
run;

proc contents data=test;
run;
dolbi18
Calcite | Level 5
Thanks 🙂
PeterClemmensen
Tourmaline | Level 20

Anytime, glad to help 🙂

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1480 views
  • 0 likes
  • 2 in conversation