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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.