topic Re: Problem understanding date and dollar formats in New SAS User

Problem understanding date and dollar formats

serges007 — Wed, 01 Sep 2021 10:03:46 GMT

Hello Team, I have serious problems understanding the date and dollar formats. In fact, in certain exercises, dollar7 or a dollar12 are sometimes used. Can you better explain to me when should I use dollar7, dollar8 dollar9, dollar10, dollar11, or dollar12

here is an example I got I used dollar12. but in the correction one uses dollar7. and I can't understand the reasons they gave. It's the same problem with the date format using date7, date8 date 9, and so on.

data results.output13;
  set cert.input13;
  Chdate=put(date1,date9.);
  num1=input(Charnum,dollar7.);
run;

Thank's for your comprehension

Re: Problem understanding date and dollar formats

yabwon — Wed, 01 Sep 2021 10:14:16 GMT

Hi,

start with reading the doc:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/leforinforref/n11m54nggvjybhn1w2a8mbczw04q.htm

for dateW. format: "Writes date values in the form ddmmmyy, ddmmmyyyy, or dd-mmm-yyyy."

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/leforinforref/n16vcb736tge20n1ex3yxx49fzqa.htm

for dollarW.D format: "Writes numeric values with a leading dollar sign, a comma that separates every three digits, and a period that separates the decimal fraction."

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/leforinforref/p03sgbuduqemljn1nqj7qm1leql9.htm

W - indicates width of a text printed by format, D - indicates number of digits to the right of the decimal point

All the best

Bart

Re: Problem understanding date and dollar formats

Tom — Wed, 01 Sep 2021 12:40:05 GMT

The first thing you need to learn is the difference between a FORMAT and an INFORMAT. Your code is using one of each.

Formats convert values into text. Informats convert text into values.

The DOLLAR format writes numeric values with a $ prefix and thousand separators. There isn't any DOLLAR informat. But SAS will recognize DOLLAR as an alias for the COMMA informat. That informat will ignore $ and commas in the source string when converting the string into a number.

The w.d part of a format or informat specification indicates the number to total characters and the number of characters after the decimal point.

Note than when using the INPUT() function, as in your second example, it does not mind if you use a width on the informat specification that is larger than the length of the text string you are asking it to convert. So unless there are trailing characters in that text string you want INPUT() to ignore you are probably best off just using a large number for the width. Note that each informat (or format) will have a maximum width that it supports that you can find in the documentation for the informat (or format). For the COMMA informat you are using the maximum width is 32.

Re: Problem understanding date and dollar formats

ballardw — Wed, 01 Sep 2021 14:32:40 GMT

Minor addition: Unless you really know what "implied decimal" means and is used for do not use the decimal portion of an informat. If you specify a decimal portion on an informat and the text value does not actually contain a decimal value then the informat would imply a value.

data example;
   input amount :comma12.2;
datalines;
$456.38           /*ignores currency symbol*/
456.38
$45,638            /*ignores currency symbol and implies decimal*/
;

If in the above case you want a value of 45638 for the third value use the Comma12. informat to avoid implying a decimal that is not there.

This behavior for informats is partially related to ancient days of data entry and keypunch card data where there was limited space on the cards. By implying a position for the decimal they did not actually use that print position on the card allowing more data per card.