When I was doing sample exam question of base certification, I am confused about one question. The question is following, and I change the code and run it, but I got different answer for second question. Can you please help me figure it out? Thanks so much!   data work.lowchol work.highchol work.misschol; set sashelp.heart; if cholesterol lt 200 then output work.lowchol; if cholesterol ge 200 then output work.highchol; if cholesterol ne '.' then output work.misschol; run; proc contents data=work.highchol; run; proc contents data=work.lowchol; run; ... View more

When I was doing practice exam, I am confused about several questions, please help me figure it out. Thanks so much! 1. Missing character value are represented with a blank, numeric missing value represent with ‘’.’ Is it right? 2. For this question, I thing the comma should be added in where in statement, but the correct answer does not include it 3. I am confused about the answer of this question ... View more

I am planning to take Programming Associate/Base Programming Specialist. I am confused whether INFILE/ARRAY/INPUT statement included in the exam. I check the exam guide, there is nothing related it. But when I do the practice questions, there are some related it. Thanks so much. ... View more

When I was doing practice exam, I need to follow up the instructions to set up the fil "cert" and write down two statement. I am not sure whether it's correct. And do I need to do the same things on the real exam? Thanks so much! libname cert "/folders/myfolders/cert/input"; %let outpath='/folders/myfolders/cert/output';   ... View more

I am currently taking Programming 2, lesson 3, level 2 practice. I cannot make sense the argument: park=substr(parkname,1,find(parkname, 'NP')-2); I make sense the substr argument is to read value from the first character in parkname column. Find argument is to find 'NP' string. But what does -2 stand for here? The third argument in substr is about how long the character we want to subtract. Why we use find argument here? Thanks so much!   ... View more

I am currently studying course Programming 2. In lesson (summarizing data), challenge practice. I am confused about code: if First.ParkName=1 and Last.ParkName=1 then output singleState; else output multiState; The question and answer are following:         For my understanding, first.parkname=1 means the first occurrence of one unique parkname,  last.parkname=1 means the last occurrence of that unique parkname. If we want create a table with unique parkname, we need to use fist.parkname=1 to collect all unique name. If we combine those two statement together, thus the unique name will be duplicate, which occur twice in the output table. Here is my concerns. Please help to figure out my confusion. Thanks so much.       ... View more

When I was doing the practice question from Programming 2 lesson 2. The question indicate to initialize trafficmax to 0. I did that, but from the answer, the retain statement is:retain traffixmax 0 MonthMax LocationMax. I am confused that add monthmax and locationmax on the end of statement. And what does that stand for? Thanks!   ... View more

I am confused about this question, why does the title statement t for the last PROC PRINT step cancel all the higher TITLEn statements? Thanks!   ... View more