How do I specify a currency format and a comma format in a DATA step?

[pmdci]

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.

[art297]

It would help if you provide some sample data, the code you have tried, and the result you want to achieve.

[pmdci · Accepted solution]

Hello,

Here are the examples:

• The currency field looks like: 1672349
• The integer field looks like: 94594
• The calculated field I created looks like: 17.67922912658308

I found out the formats and how to do it in the end, and what I applied is:

• NLMNLGBP. to the currency field, which formatted it as £1,672,349
• COMMA. to the integer field, which formatted it as 94,594
• NLMNLGBP. to the calculated field, which formatted it as £17.68

Regards,

P.