topic Re: SAS Certification Prep Guide Book Data set in SAS Programming

SAS Certification Prep Guide Book Data set

tholfikar — Tue, 14 Oct 2014 02:22:07 GMT

how i can practice using the data set in SAS certification prep Guide ( BASE programming for SAS 9 third Edition) in SAS Studio

is the data set for (SAS certification Prep Guide ) available online for free ?

thanks a lot

Re: SAS Certification Prep Guide Book Data set

Reeza — Tue, 14 Oct 2014 03:38:23 GMT

Yes, but you'll need to modify the code to set it up to run on SAS Analytics U version.

Re: SAS Certification Prep Guide Book Data set

prober — Tue, 25 Nov 2014 19:00:55 GMT

Is there any reference book for modifying?

Re: SAS Certification Prep Guide Book Data set

mehreen7 — Tue, 09 Dec 2014 03:06:07 GMT

1.) Open the text file http://support.sas.com/publishing/cert/sampdata.txt in an application that can work with text files.

2.) In the Menu bar, click 'Edit', and then scroll down to 'Find' and locate the function 'Find and Replace' and select it.

3.) In the 'Find' category, enter 'sasuser' and in the 'Replace' category enter 'basecert'. Select 'Replace All', and save the file under a name that you can remember.

You will use this edited text file to create and save data sets in SAS Studio in a user-defined library called 'basecert'.

4.) Open up SAS Studio as usual, and select 'Folders' and then select 'MyFolders'. Click the icon to create 'New Folder' and name this folder 'basecert'.

5.) Go to 'Libraries' an click the icon for 'New Library'. Under 'Name', enter 'basecert' (omit the quotations around 'basecert' when doing this). Under 'Path', enter '/folders/myfolders' (omit the quotation marks around '/folders/myfolders' when doing this).

6.) Click 'Code', and in the text editor called 'Program 1' paste the entire modified text file that you saved earlier. Now, save this new SAS program as 'basecert_setup'.

7.) Run 'basecert_setup' using the 'run' icon. Since my solution is not perfect, 3 errors will be generated. However, all the intended SAS data sets should be created.

I don't know how to get rid of the 3 error messages, but if someone figures out a solution please post it!

Re: SAS Certification Prep Guide Book Data set

prober — Thu, 11 Dec 2014 05:36:58 GMT

Finally the thread post SAS Certification program problem make sense.

Re: SAS Certification Prep Guide Book Data set

bdanielatl — Wed, 16 Nov 2016 20:27:29 GMT

I had to replace the SASUSER library with the WORK library, but it seems to have worked so far.

(Requires replacing some of the library refs in the code as well, e.g. clinic.admin -> work.admit)

Hope that helps. I'm working on an enterprise server with more restricted permissions.

Re: SAS Certification Prep Guide Book Data set

Cynthia_sas — Wed, 16 Nov 2016 23:32:24 GMT

The newest program for the Certification Prep Guide is here http://support.sas.com/publishing/cert/basecertguide3.html and has been posted here since 2015.

This is an older post. The original sampdata.txt wrote to the SASUSER library. The issue with the SASUSER library is that frequently EG users, SAS University Edition users and SAS OnDemand Users do NOT have access to the SASUSER library. We recommend following the instructions on the above web site to "redirect" SASUSER to a location where you have write access (such as WORK or a write-location directory) and then run the program you find on the web site.

If you do the "redirect", then you do NOT have to change any code -- because this:

libname sasuser '/folders/myfolders/certprep'; (assuming you make a folder called certprep) will allow you to use the programs that reference SASUSER and the redirected location will be the one used.

cynthia

Re: SAS Certification Prep Guide Book Data set

pgees — Wed, 20 Sep 2017 00:00:15 GMT

It works like magic! I had no error. Thanks for your distinguished SAS insight!

Re: SAS Certification Prep Guide Book Data set

tonderai — Thu, 01 Mar 2018 13:30:34 GMT

the site http://support.sas.com/publishing/cert/basecertguide3.html does not lead to any instructions it goes to sas books.

Re: SAS Certification Prep Guide Book Data set

Cynthia_sas — Thu, 01 Mar 2018 16:47:03 GMT

Sorry, that web site has changed.

-- Instructions for making the sample data for the 3rd Edition of the Prep Guide: https://support.sas.com/en/books/content-updates-base-prep-guide.html (instructions are correct, but the link on this page to get data is broken, use the link below)
--Link for program used in these instructions: https://support.sas.com/content/dam/SAS/support/en/books/data/sampledata.txt

Hope this helps,
Cynthia

Re: SAS Certification Prep Guide Book Data set

tonderai — Fri, 02 Mar 2018 09:21:22 GMT

thanks i used this link to get the instructions and it worked

https://support.sas.com/en/books/content-updates-base-prep-guide.html