Thanks, I see. ... View more

Solutions to the odd numbered problems are available at the back of the book. For even numbered problems, please check these links https://www.slideshare.net/AyapparajKarmeham/sas-ron-cody-solutions-for-even-number-problems-from-chapter-7-to-15-52961764 https://www.slideshare.net/AyapparajKarmeham/sas-ron-cody-solutions-for-even-number-problems-from-chapter-16-to-20 ... View more

I still don't understand what you are asking.  In this code: char3=input(char1, $4.); num4=input(char2, dollar10.2); char5=put(age, 4.); You are using 2 informats and 1 format.    The results of input(char1, $4.) is the same as you would get with left(substrn(char1,1,4)).   This function call, input(char2, dollar10.2) , says to read the first 10 bytes of CHAR2 and interpret it as a number after removing any dollar signs, commas, or percent signs from the 10 bytes. And if the string does not have a period to mark the decimal place then assume the last two digits in the string are after the decimal place.   This function call, put(age, 4.) , will create a string of four characters. The digits will be right aligned in the four characters (padded in front with spaces).  So if AGE=40 the result will be two spaces followed by the digit 4 and the digit 0.   ... View more

The default is to use space as the delimiter and to treat multiple delimiters as one.  That makes sense when space is the delimiter because you normally use multiple spaces to make the data columns align for when humans view the file.  To treat adjacent delimiters as marking a missing value you need the DSD option.  But when you use the DSD option the default delimiter is now going to be a comma instead of space.  So to use asterisk instead of comma you need to use the DLM option to override the default delimiter.  Note that the DSD option will also change how quotes are treated.  Quotes around values are removed and any delimiter enclosed in quotes is treated as part of the data and not as a delimiter. ... View more

@ballardw wrote: @PaigeMiller wrote: Can you actually type a data set that represents the desired output? I thought you did originally, my code produces that data set, but then you asked more questions and seemed to want something else.   So, it's still not clear what result you want, or why you have created the following data set using two SET statements. You have not explained, and I am asking you to please explain, provide details, more than the two words "try this", and SHOW us what you want if it is different than what you asked for in your first message. It's also not clear to me why you have removed the MISSING option from my TABLES statement in PROC FREQ, as I would think you want that based on your original explanation.   @PaigeMiller  I think your responded to @anming thinking that was the OP @mmea . I believe anming is proposing an alternate solution? My apologies to @mmea for the mis-understanding. ... View more

Without the + the 3 means you want to read the variable NAME using COLUMN input instead of LIST MODE (modified or not). ... View more

Hi:   The best resources to study for the Base Programmer Specialist exam are the resources provided by SAS -- not by web sites that are not affiliated with SAS and who may have incorrect material. The web site you posted is showing exam numbers that are NOT used anymore. The exam codes they list are not in use anymore.     The practices and activities in Programming 1 and Programming 2 training classes are also good resources for practicing -- do all of the practices and all of the challenge practices. Then the Certification Prep Guide https://www.sas.com/store/prodBK_72102_en.html?storeCode=SAS_US has a set of questions at the end of each chapter in the book that are also good practices for the exam. Also, study this content guide: https://www.sas.com/content/dam/SAS/documents/technical/certification/content-guide/specialist-base-programming.pdf to be sure you are comfortable with all the topics that can be on the Base Programmer exam.     We provide a FREE Practice Exam that mimics the questions on the graded exam. That is also a good resource. You'll find a link to the Practice Exam on the web page for the exam: https://www.sas.com/en_us/certification/credentials/foundation-tools/base-programming-specialist.html      I hope these resources that we provide help you prepare for the exam.   Cynthia ... View more

Yes, because a value in quotes is considered a character value so SAS converts it to a number before it can do math on the value.   @anming wrote: data work.retail; cost = (20000); total = .10 * cost; run; to assign a value to cost, 20000 or (20000) both work. "20000" or '20000' also work but a log note shows that a char is changed to a numeric value.     ... View more

I think that when you remove the period then SAS stops recognizing the format but then starts to interpret the number as the column number.  It then takes the single digit and places it in weight . I could not replicate getting the "7" using datalines .    data test2; infile datalines; input @1 height 2. @4 weight 1; *Chnaging this 1,2,3,4,5; datalines; 36 95 ; run; replacing: returns 1 3 2 6 3 . 4 9 5 5 About the unexpectedness: I don't thin this syntax is itself "expected", so being unexpected syntax I'm sure the result is unexpected too.  ... View more

Hi: A00-211 and A00-212 are not active exams anymore. Since we do not distribute our exams to sites like this, they do not have permission to use these exams. The questions in the Prep Guide at the end of each chapter and the practices inside the classes and the free Practice Exam should all be sufficient to help you study for the exam. Cynthia ... View more

:Var1 - :Var4 describes a range of macro variable names in proc SQL, as in   select style, sqfeet into :type1 - :type4 notrim, :size1 - :size3 from sasuser.houses;   ... View more