# SAS
SAS SQL procedure 정리
SQL: 데이터의 검색, 요약, 정렬, 출력 등을 프로시저내에서 한번에 처리할 수 있는 장점이 있어 매우 효율적 Calculated의 활용:Case when 명령어 조건식 사용때 select문에서 새로운 열 이용, Where문 사용때도 적용 proc sql; sele
SAS BASE DUMP
Q1. this question will use data set sashelp.shoes.Write a SAS program that will:1\. Read sashelp.shoes as input.2\. Create the SAS data Set work.sorte

SAS_공단자료 분석하기
가설구체적으로 설정하기 (어떻게 분석할껀지 생각해서)분석에 필요한 여러 정의들study population (어떤 사람을 포함할까)exposure (효과를 보고 싶어하는 메인 독립변수)outcome (종속변수)covariates (어디까지 붙여서 진행할껀지)analys

sas_공단자료 구성
사람들의 일반적인 정보 (성별, 연령, 거주지 등)자격 : 돈을 내야되는 의무를 가진 사람들 (피보험자)\-자격 db랑 개인 고유번호 (RN_INDI) 기준으로 연결코호트 자료의 특성을 가지고 있음(병원을 방문한 후 계속 follow up)사망은 년/월 까지만 주므로
SAS Crambible 20
Given the SAS data set PRICES: PRICES prodid price producttype sales returnsK12S 5.10 NETWORK 15 2B132S 2.34 HARDWARE 300 10R18KY 21.29 SOFTWARE 25 53
SAS Crambible 19
The following SAS program is submitted:data work.passengers; if OrigPassengers = then OrigPassengers= 100;TransPassengers= 100;OrigPassengers= .;Total
SAS Crambible 18
The SAS data set PETS is sorted by the variables TYPE and BREED.The following SAS program is submitted:proc print data = pets;var type breed;sum numbe
SAS Crambible 17
Which ODS statement option terminates output being written to an HTML rile?A. ENDB. QUITC. STOPD. CLOSE답은 D입니다.위 문제는 그냥 외우는 문제입니다. ODS HTML END, ODS H
SAS Crambible 16
The following SAS program is submitted:data work.accounting;set work.department;length jobcode $ 12;jobcode='FA1';run;The WORK.DEPARTMENT data set con
SAS Crambible 15
Given the SAS data set PRICES: PRICES prodid price producttype sales returnsK12S 5.10 NETWORK 15 2B132S 2.34 HARDWARE 300 10R18KY 21.29 SOFTWARE 25 53
SAS Crambible 14
Given the SAS data set AGES: AGES AGEThe variable AGE contains character values. The following SAS program is submitted:data subset;set ages;where age

SAS Crambible 13
문제 잘못됨son Travis, -> son, Travis로 변경해야 함The following output is desired:Obs relation firstname1 son TravisWhich SAS program correctly reads in the raw
SAS Crambible 12
The following SAS program Is submittad:data work.sales;do year = 1 to 5;do month=1 to 12;x+1;outputend;end;run;How many observations are written the W
SAS Crambible 11
The following SAS program is submitted:proc sort data = work.employee;by descending fname;proc sort data = work.salary;by descending fname;data work.e
SAS Crambible 10
Which program displays a listing of all data sets in the SASUSER library?A. proc contents lib =sasuser.all; run;B. proc contents data =sasuser.all; ru
SAS Crambible 9
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below: WORK.EMPLOYEE WORK.SALARY fname age name salary Bruce 30 Bruce 25000Dan 40 Bruce 3500
SAS Crambible 8
The following SAS program is submitted:data work.sets;do until (prod gt 6);prod + 1;end;run;What is the value of the variable PROD in the output data

SAS Crambible 7
The following SAS program is submitted:data one;addressl= '214 London Way';run;data one;set one;address = tranwrd(address1, 'Way', 'Drive'); run;What

SAS Crambible 6
Given the raw data record DEPT:The following SAS program is submitted:data bonus;infile 'dept';input dept$ 1-11 number 13-15;insert statement hererun;
SAS Crambible 5
The following SAS program is submitted:footnote 1 'Sales Report for Last Month';footnote2 'Selected Products Only';footnote3 'All Regions';footnote4 '