A collection of past exams and study materials are held by the library. The list below includes all available in print and digitally. Print copies are available at the Circulation Desk for 2-hour loan. Digital copies are only accessible by McKinney Law affiliates.
I failed my first attempt at the SAS 9.4 Base Programming -- Performance-based exam today. The one major issue I had was accessing the files used for the exam. For the project part of the exam, we need to manipulate datasets in the files in the input folder. However, when I attempt to manipulate the datasets, the error message read that I was not authorized to modify the files. I spent more than an hour of my exam trying to figure this out. What am I not getting here? Are we supposed to know code to modify authorized files? Or is there some kind of password we use to be able to modify the files? I feel like there is something simple I am not getting here.
You *could* do it that way, but using PROC DATASETS to copy all the files is a much more broad-spectrum approach than I was suggesting. During the project portion, anytime you are asked to work with a data set you have control over where you store the results. So, yes, you need to establish your own library like you did in your LIBNAME statement, but then you just need to use it when you store the results you create.
For example, if you are asked to sort a data set, then use OUT= in PROC SORT to save it to your library. If you are modifying data in a DATA step, then make sure your DATA statement saves the results in your library rather than trying to overwrite the data you are provided. (These are both good programming practices anyway, but in the testing environment they are required.) @Mark2010 gives a pretty good run down of the process in his example videos - but maybe you ran into an issue that I'm not understanding. In any case, I cannot imagine a scenario where you would want to copy over all the data sets - this is a timed exam, so I'd advise test-takers to be spending their time only working with the required data sets!
I watched the videos from @Mark2010 several times and did not see any examples of how I can do what you explained in your last response. He mentions the write-protected files, but no examples of how he accesses the data.
The first example sorts the read-only data set SasHelp.Cars and saves the result in your Work library as MyCars. This uses the OUT= option to avoid sorting the data set in place which is the default of PROC SORT.
The second example is adapted (because I don't remember the exact details) from @Mark2010's video where he demonstrates the testing environment. It reads in the SasHelp.Shoes data set, which is also read-only for you, and subsets the data. The subset is stored in the Example library, which I created with the LIBNAME statement. (Note, when doing this you need to make sure the path you select points to a location where you have write-access.)
If you're still having an issue knowing when/how to work with files using read- vs write-access. I'd suggest taking a look at either the certification guides, a SAS book (full disclosure, I'm an author of one, but there are lots of options that would cover this content), or even digging into the SAS documentation. The syntax can vary from PROC to PROC on how to save your data (or use ODS OUTPUT to simplify the syntax), so there is no "one size fits all" approach to this topic.
SAS documentation is also helpful for all sorts (pun intended) of questions you may have while learning SAS and preparing for certification exams. I tend to use Google with a prefix of "SAS 9.4" such as in this case I would search for "SAS 9.4 PROC SORT OUT="
I hit the first result from Google, click on examples and see that even the basic examples of PROC SORT include an OUT= statement (which is a best practice in my opinion because it doesn't alter your original data set).
The exam files are similar in structure to what you describe in the "S:\ > workshop > cert." paragraph, but the specific directory names will be different. The exam provides the specific instructions to access the correct directories for input and output data sets.
In real exam, it was described that file is located at "C:/Cert" and within Cert folder, there was 4 folders: Input, Errors, Output, and Programs. Input data was in the "Input" folder. I had assigned the = libname input "C:/Cert/Input"; After using this libname reference in the set statement= set input.input28; but i was not getting data in output window. Also, I had checked the properties of "Input" folder and size was 0 bytes. I saw the all input datasets name but after executing the proc sort with set statement, it was null at output tab. I belived that Virtual Lab was not loaded with data or any contents.
@bsd70 just a note of caution about discussing exam materials in public forums - It is a violation of the candidate agreement. You haven't crossed the line but you are close. Specific exam concerns should be addressed to certif...@sas.com via email.
That being said, I assure you that your input data folder contained the data sets (I checked your lab as you tested recently and the data is still there). Given that all exam labs are simply copied from a master template virtual machine at the start of your exam, there is 0 chance that corruption in the template could result in the data being missing. It's possible if the bits got scrambled in the copy that the entire lab would not work (though I've never seen this occur), but no-way could there be missing files.
Trust that your SAS is executing your code exactly as you have written it, and if it's not working right, the problem is the code. It's like a magic genie. If you tell it "Make me a peanut butter sandwich", don't be upset when you are suddenly turned into a PB sandwich. This takes a combination of humility to accept that the code isn't right and confidence that you have the skills to fix it. It is possible that your code was syntactically correct and produced no errors, but was logically wrong. You may have used one libname in your LIBNAME statement and another in your PROC SORT. And a note on PROC SORT: It is important to understand where the sorted data is created by default without any additional options. The A00-231 Exam Content Guide is your friend here.
I am sorry about if any. I reviewed previous post about this issue to get knowledge and I have written my experience. I have used the contents as given in the publicized content materials. My intension is learning and share good vibes. I have reviewed documents and videos before taking exams as per link given. I will do so again if I am missing any.
The Tennessee State Board of Accountancy is notified when a candidate has met the education requirements and passed the Uniform CPA Examination. The National Association of State Boards of Accountancy (NASBA) transmits to the Board a candidate file containing CPA exam grades and education transcripts.
Currently, there is an 8-10 week delay from the time you were notified you passed your last exam for receipt of candidate files. Please contact NASBA if you have questions about where you are in their process.
Software suite designed for creating, editing, and taking tests and exams. It is widely used in education, exam preparation, and certification fields, as well as in the corporate environment for conducting internal assessments of employee knowledge.
The Professional Exam Simulator will assist you in preparing for the exam and evaluating your knowledge. The application can both assess your knowledge and facilitate self-learning. It features a user-friendly interface, hints display, customizable testing parameters, result evaluation, and much more.
ProfExam provides all the necessary tools for creating, managing, and taking exams and tests, making the exam preparation process more efficient and convenient for users. It includes two key applications:
ProfExam Simulator is an exam preparation and exam simulator program designed to help you prepare for exams effectively. It provides training and testing on various types of questions similar to those encountered in real exams. With its user-friendly interface and conditions closely resembling actual exam situations, ProfExam Simulator ensures a comprehensive and realistic preparation experience.
ProfExam Creator is a powerful visual editor for creating and editing exams and tests, ideal for exam preparation. It supports various question types. The program can import exams from TXT/RTF/PDF files and offers a user-friendly interface for easy exam management. Whether you are preparing for certification exams or conducting knowledge assessments, ProfExam Creator ensures a smooth and intuitive exam creation experience.
If you're interested in purchasing both applications, consider the ProfExam Suite package. It includes both the Exam Creator and Exam Simulator, and also offers a discount for purchasing them together.
ProfExam Creator - a powerful tool that enables users to create diverse exams and tests. With it, users can easily generate questions of various types, organize them into sections, set exam parameters, and much more.
ProfExam Simulator - an application designed for taking exams and tests created in ProfExam Creator. It offers realistic testing conditions and various modes such as exam mode, preparation mode, and training mode, allowing users to effectively prepare for exams.
In the first part of the level 1 certification exam it tells you to create a new list using the SKU.csv file they give you. The SKU.csv file you download ends up being multiple files in one folder. When I try to import the one of the attached files (SKU) into my new list (P3 SKU) nothing happens on my screen. Then on the next question when I try to import the file (SKU Volume.csv) into the new module nothing happens as well.
Can you check your SKU list?, have you define parents for SKU list? ,If yes and still you are not able to add item in SKU list, then please send some screenshot of your SKU list and after import what error are you getting and also mapping.
93ddb68554