Hello, My name is Mava, and I have submitted questions before, and I thank everyone for responding. Even though I have been using SAS for stats for 20 yrs, I want to get SAS certified in Base. I have been studying and doing the exercises in the 5th edition of SAS REVIEW for BASE certification? I am a PhD clinical epidemiologist, so I primarily deal with medical data. So I do epidemiology, grants, scientific writing, and learned more stats throughout the years (extra MS biostat classes) and took SAS courses under one learning path. But studying for this exam is hard on me b/c I have been doing things my way (with the correct results), and now there is all stuff I never really "read by the book" to do my programming. Also, I have a program, call STATTRANSFER that automatically converts other file types in SAS perm datasets (ds). Now, I am going through the proc import stuff, to study, and am getting so confused b/c there are a couple of ways to things, and then there is WIZARD, which is newer to me. So, here are my questions: Please do NOT send me links of videos (I looked up all I could and all topics on the web), and I need HELP with the answers for my questions. I also go back to Ron Cody's books. 1. How can you tell if a file is a fixed length record file? 2. Does the test include things or other programming needs NOT included in the review book? 3. Does the test include macro's 4. Does the test include SQL basics? 5. Can anyone, and I looked this up, and forgive me if I missed it, write code for me on how to bring in multiple excel sheets without using macros? 6. Can anyone, in basic terms - I mean basic terms, tell me what the a. difference is between VALIDVARNAME (I know what that is) and a VALIDMEMNAME is? I am NOT understanding VALIDMEMNAME and when to or not to use it. b. differences in literals, national, special, and pointer control variables? I printed out and am studying the simple sheets that were out there for definitions. Can anyone PLEASE give me examples of each of these? For example, examples of literals, examples of national examples of special examples of pointer control variables? I know that sounds like I am not good in SAS, but I deal with medical data basically. So I don't know if I used these before without knowing it. 7. If anyone out there took there took the exam and passed, please tell me if they deviate from the review book with questions. I am watching webinars, studying hard, doing all the exercises, looking up ways to do things, and studying Cody's book. Do they concentrate on the SAS processing a lot? Any hints would be so appreciated. I know the pass rate is rather low. I gave the sample test (via email) to my PhD biostat friend, and she was so perplexed and did not do well on the practice exam at all. And we both have used SAS for our whole lives. If you can answer any question at all, please put the question number in front of your response. If you can answer all, YAYE!! I know I will have more basic questions, like my PhD biostat friend will have. She is not taking the exam. So please, make no judgments on me for basic questions. I thank you for that. I thank you so very much, Mava.
... View more
