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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 4640 views
  • 1 like
  • 4 in conversation