Hi There,
I got two numeric variables in a dataset, one to hold a interger (whole) number, and another to hold a currency value in GBP (sterling pounds: £) without any decimal values.
The dataset has been imported from Excel and I already did some code in a few DATA steps to rename some of the field names and add some nice labels.
However I can't find a way to properly format these two numeric fields I have mentioned.
There is also a calculated field that I have created with with has a massively long decimal digits, and I would like to give it a format of currency with the £ sign and only two decimal places.
Could somebody please advise?
Regards,
P.
Hello,
Here are the examples:
I found out the formats and how to do it in the end, and what I applied is:
Regards,
P.
It would help if you provide some sample data, the code you have tried, and the result you want to achieve.
Hello,
Here are the examples:
I found out the formats and how to do it in the end, and what I applied is:
Regards,
P.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: