목록문제풀이/기타 (140)

나루다루

SAS BASE Q31.

QUESTION NO: 31Given the AIRPLANES data set : AlRPLANES TYPE MPGF-18 105C-130 25Harrier 75A-6 110 The following SAS program is submitted:data gt100;set airplanes(keep = type mpg load);load = mpg * 150;run; The program fails to execute due to syntax errors. What is the cause of the syntax error? A. MPG is not a numeric variable.B. LOAD is not a variable in the data set GT100.C. LOAD is not variab..
문제풀이/기타 2018. 10. 30. 02:08
SAS BASE Q30. 대소문자 구분 [수정]

QUESTION NO: 30The following SAS program is submitted:data test;set chemists;if jobcode= 'Chem2' then description = 'Senior Chemist';else description = 'Unknown';run; The value for the variable JOBCODE is: JOBCODEchem2 What is the value of the variable DESCRIPTION? A. chem2B. UnknownC. Senior ChemistD. ' ' (missing character value) Answer: B # 문제 수정 - it -> if로 수정 - 전체적으로 보기 편하게 수정 # 문제 풀이 - 데이터..
문제풀이/기타 2018. 10. 30. 02:03
SAS BASE Q29. varnum

QUESTION NO: 29The following SAS program is submitted: proc contents data = sashelp.class varnum;run; What does the VARNUM option print? A. a list of variable namesB. the total number of variablesC. a list of the variables in alphabetic orderD. a list of the variables in the order they were created Answer: D # 문제 풀이 - varnum : 데이터셋 안 변수들이 만들어진 순서를 보여준다. - varnum = variable number
문제풀이/기타 2018. 10. 30. 01:58
SAS BASE Q28. @

QUESTION NO: 28The contents of the raw data file PRODUCT are listed below:24613 $25.31 The following SAS program is submitted:data inventory;infile 'product';input idnum 5. @10 price;run; Which one of the following is the value of the PRICE variable? A. 25.31B. $25.31C. . (missing numeric value)D. No value is stored as the program fails to execute due to errors. Answer: A # 문제 풀이 - @10 : 데이터의 10..
문제풀이/기타 2018. 10. 30. 01:53
SAS BASE Q27. month , weekday

QUESTION NO: 27The following SAS program is submitted:libnametemp 'SAS data library';data work.new;set temp.jobs;format newdate mmddyy10.;mdate= month(newdate);ddate= weekday(newdate);run; proc print data = work.new; run; The variable NEWDATE contains the SAS date value for April 15. 2005. What output is produced if April 15, 2005 falls on a Friday? A. Obs newdate mdate ddate1 04/15/2005 APR 6B...
문제풀이/기타 2018. 10. 30. 01:44
SAS BASE Q26. proc sort [수정]

QUESTION NO: 26Given the SAS data set WORK.AWARDS: WORK.AWARDS FNAME POINTS MONTHAmy 2 4 Amy 1 7 Gerard 3 3 Wang 3 3 Wang 1 12 Wang 1 8 The following SAS program is submitted: proc sort data = work.awards; by descending fname points; run; How are the observations sorted? A. FNAME POINTS MONTH Wang 3 3 Wang 1 12 Wang 1 8 Gerard 3 3 Amy 2 4 Amy 1 7 B. FNAME POINTS MONTH Amy 2 4 Amy 1 7 Gerard 3 3 ..
문제풀이/기타 2018. 10. 30. 01:36
[SAS BASE] informat 정리

덤프 문제 풀다보면 자주 나오는 것 중 하나가 informat과 format이다. - format : 데이터를 불러 온 후, 형식(format)을 변경. data를 출력하는 형식 - informat : 데이터를 불러 올 때, 형식(format)을 변경. data를 읽어오는 형식 format은 data를 불러와서 작업하다가 data 형식을 바꾸고 싶을때 사용한다. 즉 data를 출력하는 형식이다. - proc format문을 사용한다.informat은 data를 불러오는 단계에서 형식 설정을 한다. 즉 data를 읽어오는 형식이다. - data 쓰기 단계에서 format을 지정한다. 결국 명령어는 같지만, 어느 위치에 쓰이냐에 따라 format과 informat이 나눠지게 되는 것이다. 많이 쓰이는 명령어..
문제풀이/기타 2018. 5. 30. 13:21
[SAS BASE] Q58. first & last & if

QUESTION NO: 58 The following SAS program is submitted: data work.total;set work.salary(keep = department wagerate);by department;if first.department then payroll = 0;payroll + wagerate;if last.department;run; The SAS data set named WORKSALARY contains 10 observations for each department, and iscurrently ordered by DEPARTMENT. Which statement is true? A. The BY statement in the DATA step causes ..
문제풀이/기타 2018. 5. 28. 12:38
Prev 1 ··· 10 11 12 13 14 15 16 ··· 18 Next