SAS Programming Certification Practice Exam Help

[brianhoops1]

Hello,

I'm getting started on my practice exam and ran into an issue when creating the initial library. The instructions are the following (I'm using SAS OnDemand for Academics):

I entered the following to set up the library:

The log came back that these both were successfully created.

When I entered in just a basic code to view the tables I received " The table "RESULTS.OUTPUT04" cannot be opened because it does not contain any columns," window within SAS. This was the code I ran. Am I missing something or did I enter something incorrectly? (Instructions are below)

[Patrick]

Does the SAS log show any errors or warnings? If there are no errors then the SAS log will also tell you how many rows it could read from table cert.input04.

Run below code to list what tables are available under libref cert with how many variables and observations.

proc contents data=cert._all_;
run;quit;

[brianhoops1]

Thanks for the follow up. I ran the code and under Log I received " ERROR: Libref CERT is not assigned."

[Mark2010 · Accepted solution]

When you first access the eLearning that contains the practice exam, there is a section titled "Access SAS and Set Up Files for the Practice Exam (Required). Under there, there are links for ODA

Follow these and you should be all set.

[Mark2010]

I think you missed an important setup step. Before going into the practice exam itself, there is a page about setting up the data in ODA. You will need to upload and run some files that are part of a zip for that comes with the exam. This should populate the need input data sets.

[wxzhai]

there is a program you need to unzip and execute. All the folder and datasets for practice will be there. 

[wxzhai]

should be like this. I'm also using on demand. and attended the exam 2 weeks ago.