topic Re: SAS Programming Certification Practice Exam Help in SAS Certification

SAS Programming Certification Practice Exam Help

brianhoops1 — Tue, 14 Nov 2023 22:46:51 GMT

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)

Re: SAS Programming Certification Practice Exam Help

Patrick — Tue, 14 Nov 2023 23:42:06 GMT

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;

Re: SAS Programming Certification Practice Exam Help

Mark2010 — Tue, 14 Nov 2023 23:53:15 GMT

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.

Re: SAS Programming Certification Practice Exam Help

brianhoops1 — Tue, 14 Nov 2023 23:53:36 GMT

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

Re: SAS Programming Certification Practice Exam Help

Mark2010 — Wed, 15 Nov 2023 00:58:22 GMT

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.

Re: SAS Programming Certification Practice Exam Help

wxzhai — Wed, 15 Nov 2023 01:34:16 GMT

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

Re: SAS Programming Certification Practice Exam Help

wxzhai — Wed, 15 Nov 2023 01:36:48 GMT

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