topic format issues in New SAS User

format issues

anming — Thu, 26 Nov 2020 15:19:37 GMT

the format of a numeric variable can be

format score comma10.2;

format capital dollar8.2;

the format of a date is

format sdate date9.;

format today_date MMDDYY10.,

format a string variable:

format gender $genderf. average_score label.; /*genderf and label defined in the libname*/

when a period should be added to the format (a date or string variable, anything else?) and when is a period unnecessary (only like a numeric variable?)?

Re: format issues

Astounding — Thu, 26 Nov 2020 16:02:53 GMT

A dot is always required when using a format. Notice all the formats you listed in your example contain a dot somewhere. The dot might not appear at the end, but it always appears somewhere.

When creating your own format using PROC FORMAT, the dot is not needed as part of the format name. Only when you later use the format is the dot required.

Some programmers add a dot in a LENGTH statement, such as:

length gender $1.;

The LENGTH statement never requires a dot. If you add one, SAS will forgive you, but it is not needed.

Re: format issues

nrk1787db1 — Thu, 26 Nov 2020 16:16:08 GMT

A period is needed with FORMAT statement for all data types.

Re: format issues

anming — Thu, 26 Nov 2020 16:26:50 GMT

thanks!

Re: format issues

anming — Thu, 26 Nov 2020 16:27:46 GMT

thanks!

Re: format issues

Reeza — Thu, 26 Nov 2020 16:28:57 GMT

A FORMAT statement always requires a period, so something in this format:

format variableName formatName.;

You can have something after the period as well, for numeric formats at least.

And the exception to the rule, is when passing formats using PUTN() or PUTC() where the format can be just the string, no period, otherwise a period is usually required.

format-specification

is a character format that you want to apply to value.

Here are valid format forms:

format-name
format-name.
format-namew.

Re: format issues

Tom — Thu, 26 Nov 2020 16:44:26 GMT

You need to include a period in your format specification so the compiler knows you mean a format and not variable name.

In your code examples you are using the format specifications of

comma10.2
dollar8.2
date9.
MMDDYY10.
$genderf.

Which are references to the formats named COMMA, DOLLAR, DATE, MMDDYY and $GENDERF.

If you removed the period from the format specification then it looks like a variable name. So this statement is attaching the DOLLAR format with a width of 8 characters of which 5 are before the decimal point and 2 after.

format capital dollar8.2;

But this statement is removing the formats from two variables named capital and dollar82 .

format capital dollar82;

Re: format issues

ballardw — Thu, 26 Nov 2020 21:07:44 GMT

The digits after a dot in a format indicate how many decimal values to display. So really only applicable for numeric formats.