08-06-2015 05:17 PM
I have these points (or floating points?) in column Buy In, see image below. I want to create a user defined format to change floating points tp zero because it's easier to handle them in excel.
I got the steps from this community on how to do it but it's doesn't give me what I want. Help please.
08-06-2015 05:18 PM
Forgot to add, these are the instructions I was given on this site:
creating the user-defined format, apply it to your column...
08-06-2015 05:40 PM
What do you mean by "change floating point to 0"? do you mean to no display the decimal part or to remove any decimal part? A format like F4.0 would not display any decimal. If you still want $ to appear then try a format like dollar6.0.
To change the value round with the Round function.
08-06-2015 06:05 PM
I don't use EG. This code generates a format that does what I think you are asking for:
proc format library=work;
. = '$0' /* if you don't want $ to appear then just '0'*/
other=[dollar8.2] /* what ever the current format you are using for that column goes inside [ ]*/
Assign the MYDOLLAR format after it is created to the column(s) needed.
If you have a mixture of desired output like $ format and simple format like F4.2 you would need a separate format for each.
08-06-2015 07:19 PM
Just the library. I would expect to get an error work.query...
The format would be the WORK library. I would expect that just going to assign format method you should be able to find MYDOLLAR in the list of available formats, or type in the name of the library.