topic Re: field formats in SAS Programming

field formats

larrytex — Tue, 28 Aug 2018 21:36:34 GMT

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.

Re: field formats

Reeza — Tue, 28 Aug 2018 21:50:06 GMT

DOLLAR

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=leforinforref&docsetTarget=p03sgbuduqemljn1nqj7qm1leql9.htm&locale=en

@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.

Re: field formats

Astounding — Wed, 29 Aug 2018 04:11:59 GMT

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.;

Re: field formats

larrytex — Tue, 04 Sep 2018 16:08:31 GMT

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