목록Study/SAS BASE (100)

나루다루

SAS Base 시험 준비/합격 후기/복원 문제

드디어 SCBP를 땃다! * SAS Base 시험 준비시험 준비는 10월 말부터 총 2주정도 준비했다. 빡세게는 안하고, 하루에 1~3시간 정도 투자했던거 같다. 원래 계획은 덤프인 Crambible 문제 풀고 Kill test까지 마무리 한 다음에 시험을 보는거였는데.. 시간이 부족해서 크램바이블 140번까지와 기출문제들만 보고 시험을 쳤다.크램바이블의 경우 문제를 풀고 유튜브에 있는 해설(click)을 들었다. 해설이 나와있는 140번까지만 들었으며 직접 실습도 병행했다.다른 후기들을 보면 실습 필요없다고 하는데, 나 같은 경우는 실습을 해야 직성이 풀리는것도 있고 모르는게 많았기 때문에 sas university edition을 통해 실습을 진행했다. (sas university edition은 대..
Study/SAS BASE 2018. 11. 24. 23:27
SAS BASE Q91. 오름차순/내림차순 정렬

QUESTION NO: 91The following program is submitted:proc sort data=SASUSER.PROJECTS out=PSORT;by Code descending Date Cost;run; Which of the following is true concerning the submitted program? A. The descending option applies to the variable Code.B. The variable Code is sorted by ascending order.C. The PSORT data set is stored in the SASUSER library.D. The descending option applies to the Date and..
Study/SAS BASE 2018. 11. 3. 01:50
SAS BASE Q90. proc format / Q39 참조

QUESTION NO: 90The following SAS program is submitted:proc format;value score1 - 50 = 'Fail'51 - 100 = 'Pass';run; proc freq data=WORK.COURSES ;table Exam;format Exam score.;run; The variable Exam has a value of 50.5. How will the Exam variable value be displayed in the FREQ procedure output? A. FailB. PassC. 50.5D. . (missing numeric value) Answer: C # 문제 풀이 - Q39번과 똑같은 문제
Study/SAS BASE 2018. 11. 3. 01:41
SAS BASE Q89. proc contents & _all_

QUESTION NO: 89The following program is submitted:proc contents data=_all_;run; Which statement best describes the output from the submitted program? A. The output contains only a list of the SAS data sets that are contained in the WORK library.B. The output displays only the contents of the SAS data sets that are contained in the WORK library.C. The output displays only the variables in the SAS..
Study/SAS BASE 2018. 11. 3. 01:38
SAS BASE Q88. merge & in

QUESTION NO: 88Given the SAS data set WORK.EMP_NAME: Name EmpIDJill 1864 Jack 2121 Joan 4698 John 5463 Given the SAS data set WORK.EMP_DEPT: EmpID Department2121 Accounting3567 Finance4698 Marketing5463 Accounting The following program is submitted:data WORK.ALL;merge WORK.EMP_NAME(in=Emp_N)WORK.EMP_DEPT(in=Emp_D);by Empid;if (Emp_N and not Emp_D) or (Emp_D and not Emp_N);run; How many observati..
Study/SAS BASE 2018. 11. 3. 01:10
SAS BASE Q87. 날짜 변수

QUESTION NO: 87The following SAS program is submitted:data WORK.DATE_INFO;X="01Jan1960" D ;run; What variable X contains what value? A. the numeric value 0B. the character value "01Jan1960"C. the date value 01011960D. the code contains a syntax error and does not execute. Answer: D # 문제 풀이 - "변수"D : 해당 변수를 날짜변수(숫자형)로 바꿔준다. - 이 문제에서는 변수 다음에 띄어쓰기가 있으므로 오류가 난다. - sas에서 1960-01-01 = 0이다. (기본 설정) (01..
Study/SAS BASE 2018. 11. 3. 01:04
SAS BASE Q86. substr & scan & %

QUESTION NO: 86Given the data set WORK.EMPDATA: Employee_ Manager_ID Job_Title Department ID120101 Director Sales Management 120261 120102 Sales Manager Sales Management 120101 120103 Sales Manager II Sales Management 120101 120104 Administration Manager Administration 120101 120105 Secretary I Administration 120101 Which one of the following where statements would display observations with job_..
Study/SAS BASE 2018. 11. 3. 00:44
SAS BASE Q85. Excel Worksheet

QUESTION NO: 85The Excel workbook REGIONS.XLS contains the following four worksheets: EAST WEST NORTH SOUTH The following program is submitted: libname MYXLS 'regions.xls'; Which PROC PRINT step correctly displays the NORTH worksheet? A. proc print data=MYXLS.NORTH; run;B. proc print data=MYXLS.NORTH$; run;C. proc print data=MYXLS.'NORTH'e; run;D. proc print data=MYXLS.'NORTH$'n; run; Answer: D ..
Study/SAS BASE 2018. 11. 3. 00:18
Prev 1 2 3 4 ··· 13 Next