본문 바로가기

분류 전체보기

 (509)
Chapter 12. SAS Formats and informats Q. Suppose you do not specify the LIBRARY=option and your formats are stored in Work.Formats. How lonw do the exist? only for the current SAS session. If you do not specift the LIBRARY=option, formats are stored in a default format catalog named Work.Formats. The libref Work signifies that any format that is stored in Work.Formats is a temporary format; it exists only for the current SAS session..
Chapter 11 . Processing Data with Do Loops Q. Which statement is false regarding the use of DO Loops? They can be used to combine DATA ane PROC steps. ( X ) - DO loops are DATA step statements and cannot be used in conjunction with PROC steps. - Dp loops 는 DATA step statements 이며 PROC step 과 결합하여 사용할 수 없다. [ 옳은 보기 ] They can contain conditional clause. ( O ) Then can generate multiple observation. ( O ) They can be used to read data. ( O..
Chapter 10. Combining SAS Data Sets Q. Which program combines Work.One and Work.Two to produce Work.Tree? - 데이터 옆으로 붙이기 (VarX 공통변수 존재) - data work.three; set work.one ; set work.two; run; This example is a case of one-to-one matching, which requires multiple SET statements. Where same-named variables occur, values that are read from the second data set replace those that are read from the first data set. Also, the number of observ..
Chapter 9. Creating and Managing Variables Q. Given the following data set, Which program creates the output shown below? 주어진 데이터셋 변수명 Stock Num Finish Style Item Price 생성된 output 변수명 Stock Num Finish Style Item TotalPrice data test2; set cert.furnture; if finish='oak' ane price < 200 then delete; TotalPrice+price; drop price; ------------------→ DROP statement run; proc print data=test2 nobs; run; Finish가 'oak' 이고 Price 가 200 보다 작은 값을 삭..
Chapter 8. By-Group Processing Q. BY statement 사용과 관련하여 틀린 것은? ( FIRST. and LAST. are stored in the data set. ) When you use the BY statement with the SET statement, the DATA step creates the temporary variables FIRST. and LAST. They are not stored in the data set. The data sets. listed in the SET statement must be indexed or sorted by the values of the BY variable or variables. The DATA step automatically creates two variabl..
Chapter 7. Understanding DATA Step Processing Q. Which of the following is not written to the output during the compilation phase? The first observation → observation은 execution phase 전까지 쓰여지지 않는다 ! During the compilation phase, the program data vector (PDV) is created. The program data vector (PDV) includes two automatic variables _N_ , _ERROR_ [ Written to the output during the compilation phase ] The data set descriptor the _N_ and _ERRO..
Chapter 6. Creating Report Q. Which PROC PRINT step below creates the sample output with the label and variables being displayed? (Hint : PROC CONTENTS output is shown first to assist you.) [ data set 에 라벨이 저장되어 있는 경우 ] proc print data=cert.laguardia label ; id date ; var boarded transferred flight ; where flight ='219' ; run ; DATA =option : specifies the data set that you are listing ID statement : replaces the Obs colu..
chapter 5. Identifying and Correcting SAS Landuage Errors Q. SAS program이 spelling errors 를 포함하고 있다고 가정하면, Which set of steps should you perform, in the order shown, to revise ane resubmit the program? Correct the errors. Clear the SAS log. Resubmit the program. Check the Output window. Check the SAS log. To correct errors in programs when you use the Editor Window, you usually need to recall the submitted statements from recall buffer to the Editor Wi..

티스토리툴바