BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jaliu
Quartz | Level 8

This is a very good explanation, but the book does not say this. Maybe you should write one. 

 

I'm realizing that the prep book is not a good tool.

Panagiotis
SAS Employee

By default, SAS has column naming rules. You can change that with the VALIDVARNAME= option. If you get a question wrong, it's best to do further research. For example, for the question you posted you have multiple options:

 

1. First is to reread about that option in the certification book. I'm not sure what version you have, but the the version I'm looking at explains what VALIDVARNAME= does. It's in Chapter 2 - Basic Concepts. It takes up an entire page. For the version i'm looking at start on page 12 "Rules for SAS Names".

2. You can also read the quick feedback they give you for a question at the end of the book. It quickly explains why something is correct. Here it explains that if you use the option ANY, the name can begin with  or contain any characters, including blanks, national characters, special characters, and multi-byte character. That's the feedback for the exact question you posted.

3. Lastly, go to the documentation for the full option. Here is the doc for the option: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/engfedsrv/p1ffkpdm6kbjawn1wvfpgzuzjcbg.htm

 

 

- Peter

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

LIBNAME 101

Follow along as SAS technical trainer Dominique Weatherspoon expertly answers all your questions about SAS Libraries.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 16 replies
  • 2703 views
  • 1 like
  • 4 in conversation