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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.