- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I`m trying to convert decimal values to character. But i can not preserve the decimal values.
For example, 0.0078 shows up as 0.
Is there anyway i can preserve the exact decimal places after converting to character?
Thanks,
Saravanan
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You should supply a bit more information about what you did that did not work, what you have and what you want, that sort of thing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
This is the dataset. A is numeric.
A
0.1245
0.0045
0.0235
I need to convert this numeric variable to character. 'A' should be a character in my output.My output should be
A
0.1245
0.0045
0.0235
I tried A1=put(A,$6);
Thanks,
Saravanan
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You need to use the proper format in the PUT function see post from Anca tilea.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your assiatance. Much appreciated.
saravanan
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
This would be one way:
data temp;
length y $10;
x = 0.03456;
y = put(x, 10.4);*I arbitrarily selected 4 decimal...which means 10.4 format allows for 10 characters, from which 4 are the decimal part;
run;
Good luck!
Anca.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much. It works fine.
Saravanan
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You are welcome.
Please mark the thread as answered so users don't try to come up with more answers.
Thanks.