본문 바로가기

전체 글

 (510)
작업형 코드정리 (Senario)
SAS Certification Base Programming 연습문제 문자 → 숫자 자동변환에서 선행공백 관련 https://comp.soft-sys.sas.narkive.com/h97M7xdN/substr-function-with-numeric-argument substr function with numeric argument Discussion: substr function with numeric argument comp.soft-sys.sas.narkive.com compilation Step 에서 variable length 관련 http://sasreporter.blogspot.com/2009/07/sas-certification-sample-questions.html sas certification sample questions-part1 1. A raw dat..
SAS Crambible 정리 오답, 헷갈렸던 것 위주 정리 Q4. 데이터 읽기 - output Given the SAS data set SASDATA.TWO: X Y 5 2 3 1 5 6 The following SAS program is submitted: (문제 수정) data sasuser.ONE sasuser.TWO other; set sasdata.two; if X = 5 then output sasuser.ONE; if Y < 5 then output sasuser.TWO; output; run; Q. What is the result? data set SASUSER.ONE has 5 observation. data set SASUSER.TWO has 5 observation. data set WORK.OTHER has ..
SAS Crambible 103 ~ 139. https://normalpdf.tistory.com/82 SAS 관련 정리 1. 실행 단축키 : F3 2. 주석 달기 : Ctrl + / 3. Footnote statment : output 에서 아랫부분의 데이터와 상관없이 설정한 문자값을 보여주는 명령어 footnote1 'Sales Report for Last Month' footnote2 'Selected Products Only' foo normalpdf.tistory.com 1~102 번까지는 위 게시물에 정리되어 있습니다. 103. Input 으로 데이터 불러오기 : datalines; The following SAS program is submitted: data WORK.TEST; drop City; infile datalines; in..
Chapter 5. Reading SAS Data Sets 1. What statement is used to read a SAS data set in a DATA step? [SET statememt] 2. Which of the following is not created during the compilation phase? [Compilation phase] (b) During compilation, SAS creates the program data vector and the descriptor portion of the new data set. SAS creates the first observation during the execution phase. Comilation 단계에서는 PDV 와 Descriptor 가 생성되며, Execution 단계에서..
Chapter 4. Formatting Data Values 1. Which of the following is a valid name for a character format? [문자형 변수의 format] (b) a 라고 답해서 틀림. Character formats must start with a dollar sign followed by a letter or underscore. ★ A format name does not end with a period. The period is a required delimiter when using a format in a FORMAT statement. $country. : format은 period로 끝나면 안되기 때문에 오답 ! 2. You specify the variable to which a format a..
Chapter 3. Producing Detail Reports 1. Which observation or observations will be selected by the following WHERE statement? [WHERE statement 에서 대소문자 구분] (d) a 라고 답해서 틀림. Expressions in the WHERE statement are case-sensitive. This WHERE statement returns only those values that contains the exact character string shown, and the position of the substring within the value is not important. WHERE 문은 대소문자를 구별함을 주의 !! 2. Which statement ..
Chapter 2. Accessing Data 1. In this PROC CONTENTS output, what is the default length of the variable Month? [숫자형 변수의 기본 length] (b) d 라고 답해서 틀림. Monthis a numeric variable, and the default length of numeric variables is 8 bytes. 2. Which PROC step successfully prints a list of all data sets in the orion library without printing descriptor portions for the individual data sets? [PROC CONTETNS] (b) A PROC CONTENTS step pr..

티스토리툴바