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

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

pmdci — Sat, 19 Jan 2013 17:48:21 GMT

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,

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

art297 — Sat, 19 Jan 2013 20:11:28 GMT

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

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

pmdci — Sun, 20 Jan 2013 10:51:12 GMT

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,