Hi I am reading the specialist prep guide, on page 263, there is a TODAYDATE function, I googled it and can not find any info on it and dismissed it as one of the many errors in the book.
then I saw it again in the official SAS syntax reference guide, along with TODAY and DATE function.
so is like TODAYDATE() a retired function or something or just typo in two official SAS materials?
Yes, it's either TODAY() or its alias DATE() that you can use.
Yes, it's either TODAY() or its alias DATE() that you can use.
The functions are date() or today()
There is no function todaydate() - at least not in a recent SAS version and I also can't remember having it ever used in the past.
SAS is highly backward compatible. If this function ever existed then it must be a looong time/many versions ago.
You can easily test what works just by trying.
well did try, but I wasn't sure it is just a legacy function or something. Since what are the chances of error in two official SAS documents?
"Since what are the chances of error in two official SAS documents"
Slim - but from the looks of it you found one.
Suggest you raise a SAS Tech Support track so this gets fixed.
@Nietzsche wrote:
Since what are the chances of error in two official SAS documents?
The document that you called "official SAS syntax reference guide" is just supplementary material to the SAS Certified Specialist Prep Guide (see https://support.sas.com/en/books.html; there is also an errata document available), most likely created using that book, not independently. Given that there are a number of errata in the book, it's not surprising that the "syntax reference guide" has a few errors, too. Here's another one: In section "Creating User-Defined Formats" it says "LIBRARY=FMTLIB", but FMTLIB is a separate option (not needed for creating formats) of the PROC FORMAT statement and not a typical value of the LIBRARY= option.
Most reliable is the actual SAS documentation.
In section "Creating User-Defined Formats" it says "LIBRARY=FMTLIB", but FMTLIB is a separate option (not needed for creating formats) of the PROC FORMAT statement and not a typical value of the LIBRARY= option.
There is no section called " Creating User-Defined Formats with Variables" in the specialist prep guide. Did you mean " Displaying User-Defined Formats" on page 235?
I just searched entire book, find result did not turn up anything with LIBRARY=FMTLIB. Perhaps you remembered wrong?
@Nietzsche wrote:
In section "Creating User-Defined Formats" it says "LIBRARY=FMTLIB", but FMTLIB is a separate option (not needed for creating formats) of the PROC FORMAT statement and not a typical value of the LIBRARY= option.There is no section called " Creating User-Defined Formats with Variables" in the specialist prep guide. Did you mean " Displaying User-Defined Formats" on page 235?
No, I meant the supplementary two-page "Syntax Reference Guide", bottom half of page 1, right column. I don't have the prep guide.
Hello, @Nietzsche you can just try this function in SAS and SAS will tell you whether or not the function exists. No need to ask here in this forum, and SAS will give you much faster answers than this forum.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.