SAS Certitication Prep Guide dataset

[Paul830]

I am  learning SAS basis, using both the e-learning and from the Certification Prep Guide book with CD.  However when I try in add the dataset from the CD I get an lots of error codes;

" ERROR: Write access to member SASUSER.STAFF.DATA is denied."

 All I did was as instructed was to copy the code and paste it into SAS then run it. Could anyone guide me where I am going wrong.  Many thanks

[Amir]

If you are getting "lots of error codes" then it would be better you share the whole log.

When you paste the log, using the "{i}" icon in the forum editor helps make it more readable.

Amir.

[Paul830]

Hi Amir,

Here is the log that I get when I try to import the sample data from the CD.  Many thanks for your help.

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 NOTE: ODS statements in the SAS Studio environment may disable some output features.
 73         
 74         /**********************************************************************\
 75         | Copyright (C) 2006 by SAS Institute Inc., Cary, NC, USA.             |
 76         |                                                                      |
 77         | SAS (R) is a registered trademark of SAS Institute Inc.              |
 78         |                                                                      |
 79         | This program sets up practice data for SAS(R) Certification Prep     |
 80         | Guide: Base Programming for SAS(R)9.                                 |
 81         \**********************************************************************/
 82         
 83         
 84         options nosource nonotes nocardimage validvarname=V7 replace;
 ERROR: Write access to member SASUSER.ADMIT.DATA is denied.
 ERROR: Write access to member SASUSER.ADMITJUNE.DATA is denied.
 ERROR: Write access to member SASUSER.COMPANY.DATA is denied.
 ERROR: Write access to member SASUSER.CREDIT.DATA is denied.
 ERROR: Write access to member SASUSER.DIABETES.DATA is denied.
 ERROR: Write access to member SASUSER.EUROPE.DATA is denied.
 ERROR: Write access to member SASUSER.FINANCE.DATA is denied.
 ERROR: Write access to member SASUSER.FUNDDRIVE.DATA is denied.
 ERROR: Write access to member SASUSER.HEART.DATA is denied.
 ERROR: Write access to member SASUSER.INSURE.DATA is denied.
 ERROR: Write access to member SASUSER.LAGUARDIA.DATA is denied.
 ERROR: Write access to member SASUSER.LOANS.DATA is denied.
 ERROR: Write access to member SASUSER.NEWADMIT.DATA is denied.
 ERROR: Write access to member SASUSER.RECORDS.DATA is denied.
 ERROR: Write access to member SASUSER.REPERTORY.DATA is denied.
 ERROR: Write access to member SASUSER.STRESS2.DATA is denied.
 ERROR: Write access to member SASUSER.STRESS98.DATA is denied.
 ERROR: Write access to member SASUSER.STRESS99.DATA is denied.
 ERROR: Write access to member SASUSER.STRESSTEST.DATA is denied.
 ERROR: Write access to member SASUSER.SURVEY.DATA is denied.
 ERROR: Write access to member SASUSER.TALENT.DATA is denied.
 ERROR: Write access to member SASUSER.THERAPY.DATA is denied.
 ERROR: Write access to member SASUSER.THERAPY1999.DATA is denied.
 ERROR: Write access to member SASUSER.THERAPY2000.DATA is denied.
 ERROR: Write access to member SASUSER.TOTALS2000.DATA is denied.
 ERROR: Write access to member SASUSER.MECHANICS.DATA is denied.
 ERROR: Write access to member SASUSER.NAVIGATORS.DATA is denied.
 ERROR: Write access to member SASUSER.PILOTS.DATA is denied.
 ERROR: Write access to member SASUSER.STAFF.DATA is denied.
  
  Sample data sets and files are ready.
  
 1811       
 1812       OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 1825       

[Mark2010]

I'll attempt to address the error, but first I think the bigger issue the the edition of the Prep Guide that you are using. CD's haven't been shipped as part of the prep guide since the second edition (circa 2009), and we are now on the fifth edition. There are significant changes to the exam since then. Also, this exam is nearing the end of it's life and will not be available after June. You may want to look into the new "SAS Certified Specialist: Base Programming Using SAS 9.4" credential. This new credential has it's own prep guide, which is a first edition guide.

Regarding the error you are getting, it sounds like you are using an environment (possibly SAS University Edition?) where the SASUSER library is not writable. There are ways around this by redefining the location of SASUSER with a new libname statement.

[novinosrin]

Thank you sir @Mark2010  for this  "SAS Certified Specialist: Base Programming Using SAS 9.4" 

May i ask a quick question?  Am i allowed to use google or our sas website for syntax help. If yes, I will take the test right away, if not am i supposed to memorize syntax???

[Reeza]

---

@novinosrin wrote:

Thank you sir @Mark2010  for this  "SAS Certified Specialist: Base Programming Using SAS 9.4" 

May i ask a quick question?  Am i allowed to use google or our sas website for syntax help. If yes, I will take the test right away, if not am i supposed to memorize syntax???

---

You'll be fine for your base certification, you should definitely do the test if you want to 🙂

[Mark2010]

Sorry for the delay @novinosrin - I've been messing with my email settings and clearly don't understand where my notifications are going. And apologies to @Paul830 for hijacking your thread.

Google - no. This would open up your exam session to places like SAS communities. I can see the posts now: SUBJECT: "Urgent!!! Please Help!!! Message Body: I'm in my exam and I need to know how to......."  Your exam needs to reflect your skill, not your friend Bob's.

But we do provide access to SAS documentation on the web in the exam. Not tech support, or training, but you can reach doc if you need to. It isn't the fastest access to doc, seems loading the doc pages stresses the virtual computers more than running the SAS programs do. It is there if you find yourself in a bind. We would say that successfully using SAS documentation is a valuable skill, so have at it. We even provide quick shortcuts to common material that a Base Programming Specialist would use regularly, such as Base Procedures, Functions, and Formats.

Also, you have your choice of SAS UI, so if you want to use EG or Studio, you get the in-line syntax help too. Display Manager.....not so much.

And if you've answered 4,185 posts (and counting) here on the communities...I'm betting you have a lot of the Base syntax pretty well figured. But always review the exam content guide as part of your prep (What!? PROC TRANSPOSE is on here?....Oh jeez....).

[novinosrin]

Thank you @Mark2010   The SAS docs is all I need. I will take the exam and soon and be done with it. Plus, a cheeky desire. Just as a e-learning has a lot of free content for student users, can you folks make an subsidized e-library akin to safarionline but unlike that charges us $60 for subscription. If SAS inc can do that, take it from me I will swallow SAS 🙂

[Cynthia_sas]

Hi:

  We do have a Learning Subscription for annual access to all of our e-learning courses, as shown here: https://www.sas.com/en_us/training/programs/learning-subscription.html  which allows you to watch as many of the e-learning classes available under that subscription as you have the time or interest for. To see the list of courses, scroll down to Available Courses section of the page and click on the button for "See Course List".

  This is a great way to get access to the e-learning library, except for the Data Science courses, which are packaged and sold separately.

    I like the books in Safari Online. But the documentation doesn't need a container like that in my mind because the documentation is already freely available. I know that Safari Online has some classes in their site; but, the ones I looked at seem of fairly short duration.

  The Learning Subscription that I mention above is a "library" or collection for the e-learning courses. Inside the Learning Subscription interface in the Virtual Learning Environment, the classes are arranged in Learning Paths. That keeps the Statistical Analysis classes separate from the SAS Programming classes and the Data Mining classes. You can focus on the learning path that you're most interested in. The e-learning classes have videos and activities and quizzes that need to be managed and progress that needs to be tracked. Our Virtual Learning Environment (VLE) does that in a way that allows us to award digital Learn Badges when someone finishes a course and has passed all the quizzes because the VLE is set up to track progress on our servers.

  The time investment for our e-learning classes is typically more than 3 hours per class. As an example, if you consider just Programming 1, Programming 2, SQL 1, Macro Language 1 and Programming 3 classes, they represent approximately 12 days of training content in the classroom. We design our e-learning content to be approximately the same duration as the classroom training. So the 12 days for all those classes translate to approximately 96 hours of content (8 hours per day *12 days of training).

    Our e-learning classes are SCORM-compliant for Learning Management Systems. The classes can be hosted at a company site using their LMS or hosted on our servers.

  We also offer a JMP Learning Subscription separate from the SAS training, that has a separate group of classes available, as shown here: https://www.jmp.com/en_us/training/learning-subscription.html .

  For our shorter content and "how to" material, we offer our Free Tutorial page: https://video.sas.com/category/videos/how-to-tutorials contains several hundred short(5-8 minute) videos on discrete topics.

  My favorite site for SAS freebies, however, is the www.lexjansen.com site, which is an amazing (and indexed) collection of over 30,000 user group papers. Everything from the very obscure PROC EXPLODE (4 results) to the very popular Macro Quoting (379 results) to the very, very popular PROC SQL (over 7000 results).

  We are putting training on some other interfaces. We have offerings on LinkedIn training and have just rolled out Statistics 1 as our latest Coursera offering. If you want access to a large selection of our e-learning classes, then the Learning Subscription is the best way to go. It does have an access period limitation of 1 year for the content. So if you only need to dip into selected topics on a "just in time" basis, then the documentation or the user group papers are better resources for that.

  Cynthia

(ps I have shared your suggestion with our Customer Service Manager.)

[novinosrin]

Thank you Mam @Cynthia_sas  for the detailed note and especially for "(ps I have shared your suggestion with our Customer Service Manager.)" . Basically I am very very keen on learning the concepts using books by some of my favorite authors and then use SAS docs rather for syntax help. Hence the reason, I am trying to find ways to get access to safari-online by any inexpensive means so that I can continue learning using this very approach.

Personally, 

1. Reading books and understanding concepts with some reread and redo helps me grip it very well.

2. For syntax,SAS docs are very handy

3. Once the stuff registers in my mind, I tend to leapfrog in speed. It's almost gets to the point, as the requirement narrates to my mind, the code is in the fingers.

One would be wondering, then why not buy the eBooks from SAS press. Well, I enjoyed the safari subscription being a full time student at DePaul but now that I have graduated the thought of not having it is really disturbing but at the same time indiv subscription is very expensive for someone who only cares about SAS+Statistics books.  Hence, my wish and idea of SAS Inc having an e-library that charges pay as you go for usage service would be so wonderful.

Don't get me wrong, While I sound so much being concerned about the price, I do value some of the authors and their hard work in being able to launch the book in a particular topic however safari price tag is really frustrating.

Best Regards!

PS I was participant in a discussion about data visulization and was of the impression SAS ODS is losing ground to Tableau/Qlikview etc but was really pleased when somebody pointed to me that ODS is still better and powerful. Apparently, they often refer to your

• Library

• DePaul University User
  DePaul University User

  • Sign Out & Clear Session
• Personal Sign In

< Return to Search Results

• Output Delivery System: The Basics and Beyond

• By: Lauren E. Haworth; Cynthia L. Zender; Michele M. Burlew

• Publisher: SAS Institute

• Pub. Date: October 01, 2009

• Print ISBN-13: 978-1-59994-660-3

• Pages in Print Edition: 636

[Paul830]

Hi Mark2010,

Many thanks.  I am using a book which was publish in 2007, so yes it is an old book.  Which I had hoped would be useful, but it would explain the errors.  I am also learning via the SAS site also.  I will now have to look into getting a more up to date book.  If you know of a supplier of learning material in the UK that would be helpful.

Many thanks again.

[GemmaR]

Hi @Paul830, 

You can email EducationOperations@suk.sas.com or ring on 01628 490423 and enquire about any books that we, SAS UK, have in stock. If we don't have them in stock, amazon is probably your best bet!

Hope this helps!

[Reeza]

There's two free SAS e-courses online. Is your goal to learn SAS or to become certified?

I would recommend taking the two e-courses first (or the course on Coursera) and then starting to practice towards your certification. 

---

@Paul830 wrote:

Hi Mark2010,

Many thanks.  I am using a book which was publish in 2007, so yes it is an old book.  Which I had hoped would be useful, but it would explain the errors.  I am also learning via the SAS site also.  I will now have to look into getting a more up to date book.  If you know of a supplier of learning material in the UK that would be helpful.

Many thanks again.

---

[Amir]

As @Mark2010 has advised a more up to date Preparation Guide is recommended.

An example of this kind of question being answered can be found elsewhere in this forum, e.g.:

https://communities.sas.com/t5/SAS-Programming/ERROR-Write-access-to-member-SASUSER-MYSALESDATA-DATA...

or

https://communities.sas.com/t5/General-SAS-Programming/SAS-university-edition-issues/td-p/310281

Amir.