topic Re: Need help putting in currency symbols using PROC FORMAT in SAS 9.4 in SAS Programming

Need help putting in currency symbols using PROC FORMAT in SAS 9.4

rishabhns — Sun, 12 Jul 2020 17:01:01 GMT

Hi all,

I need help putting in currency symbols in the salary column to the data set below:

data new;
input empcode salary country $;
cards;
1001 1473.33 USA
1002 1560.00 UK
1003 1646.67 india
1004 1733.33 japan
1005 1820.00 netherlands
1006 1906.67 poland
1007 1933.33 zimbabwe;
run;

I was told that this could be done using PROC FORMAT. The values should still be numeric, they just need the correct currency symbols. Any help is greatly appreciated

Re: Need help putting in currency symbols using PROC FORMAT in SAS 9.4

Tom — Sun, 12 Jul 2020 17:15:15 GMT

Please explain more what you want. If you want display the SALARY variable using the US currency symbol of a $ then you could use the DOLLAR format. No need for PROC FORMAT.

If you want to display a different symbol based on the value of COUNTRY then one format will not help since a format attached to a variable applies to every observation. You will probably need to make a new variable that has the text.

If you want to convert the COUNTRY name into a symbol then PROC FORMAT could help.

proc format ;
  value $currency 'USA'='$' 'UK'='£' 'netherlands'='€';
run;

You could then use that when making your new character variable.

data want;
  set new;
  length salary_display $20 ;
  salary_display=cats(put(country,$currency.),put(salary,comma12.2));
run;

Re: Need help putting in currency symbols using PROC FORMAT in SAS 9.4

andreas_lds — Sun, 12 Jul 2020 17:18:50 GMT

What do expect as result? You can only assign one format to a variable, so displaying different currency symbols depending on the of the county-variable while maintaining numeric type is hardly possible.

Re: Need help putting in currency symbols using PROC FORMAT in SAS 9.4

rishabhns — Sun, 12 Jul 2020 18:23:36 GMT

The end result should look like the following

empcode salary Country
1001 $1473.33 USA

1002 £1560.00 UK

1003 ₹1646.67 India

and the rest of the symbols for their corresponding countries and currencies