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

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

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

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.


Accepted Solutions
Solution
‎01-20-2013 05:51 AM
Contributor
Posts: 41

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

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.

View solution in original post


All Replies
PROC Star
Posts: 7,366

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

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

Solution
‎01-20-2013 05:51 AM
Contributor
Posts: 41

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

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 902 views
  • 0 likes
  • 2 in conversation