Syntax to Print Nett Sales (Monetary format) as a numeric format

Guru_MG — Tue, 18 Aug 2020 14:12:38 GMT

Syntax to Print Nett Sales (Monetary format) as a numeric format?

Country Nett Sales

Africa $250

Asia $300

Australia $350

Re: Syntax to Print Nett Sales (Monetary format) as a numeric format

AMSAS — Tue, 18 Aug 2020 14:24:55 GMT

Go look at numeric formats, specifically DOLLARw.d Format

Re: Syntax to Print Nett Sales (Monetary format) as a numeric format

ballardw — Tue, 18 Aug 2020 15:06:34 GMT

If your values are currently of numeric type with a format such as Dollarw.d assigned then if you want the value without currency symbols you could use a format such as Fw.d, to display values without commas or currency, or Commaw.d to display values without currency symbol but including commas, or even something like BEST12. which would do the best job of fitting the values into 12 characters without currency symbols or commas.

IF your Nett Sales variable is currently a character variable then you need to convert it to numeric which would be done in a data step by creating a new variable with and input statement such as

data want;

set have;

nett_numeric = input(nett_sales,comma15.);

run;

topic Syntax to Print Nett Sales (Monetary format) as a numeric format in SAS Programming

Syntax to Print Nett Sales (Monetary format) as a numeric format

Re: Syntax to Print Nett Sales (Monetary format) as a numeric format

Re: Syntax to Print Nett Sales (Monetary format) as a numeric format