field formats

[larrytex]

I have a field with the input layout of '$9999.99'. What SAS format will fit this besides character. This field will be summarized in a total with supporting record lines. Really stuck on what format to use.

[Reeza]

DOLLAR

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=leforinforref&docsetTarge...

---

@larrytex wrote:

I have a field with the input layout of '$9999.99'. What SAS format will fit this besides character. This field will be summarized in a total with supporting record lines. Really stuck on what format to use.

---

[Astounding]

To read such a field, you need to apply an informat, such as:

input varname dollar8.;

That will give you a numeric variable that you can summarize.  If you want to print out the result using dollar signs and commas, apply a format for printing:

format summarized_varname dollar9.;

[larrytex]

Sorry. Needed char format. Used source to text formatting to make it work