SAS Advanced programming

이번부터는 SAS Advanced programming 공부한 것을 요약하는 포스터를 작성하겠습니다:) 중요한 것들 위주로 정리할 생각이고, 최소 CH1 당 하나의 포스터에 목표로 작성을 진행하겠습니다!! proc sql; select jobcode,avg(salar

Chapter 2 - Performing Advanced Queries Using PROC SQL Eliminating Duplicate Rows from Output proc sql; select distinct flightnumber, destination

proc sql outobs=15;title 'New York Employees'; select substr(firstname,1,1) || '. ' || lastname as Name, jobcode, int((today() - dateofbirth)/365.25)

정리 후 중요 내용 및 헷갈리는 거 반복 학습할 부분:intersect all, intersect corr 부분과 outer union의 corr차이를 잘 구분할 것!!!PROC SQL eliminates duplicate (nonunique) rows in the t

row를 추가하는 방법을 총 3가지 방법을 소개하고 있는데... 하나씩 한번 살펴보기로 하자:)코드 설명: 핵심은 insert into ~ setset을 이용한 row 추가 부분이라고 할 수 있음:)proc sql; insert into work.discount (de

Example: Creating a Simple Indexproc sql; create unique index EmpID on work.payrollmaster(empid);Example: Creating a Composite, Unique Indexproc sql;

proc sql; create view sasuser.raisev as select empid, jobcode, salary format=dollar12.2, salary/12 as MonthlySalary format=dollar12. from payrollmas

proc sql outobs=5; select flightnumber, destination from sasuser.internationalflights; reset number; select flightnumber, destination from sasuser

Macro 단원 시작!!교재로 주 공부symbolgen: specifies the log messages about macro variable references are displayednosymbolgen:speficies the log messages about m

Using CALL SYMPUT to Create Macro Variables\*\*\*\* %let crsnum=3; data revenue; set sasuser.all end=final; where course_number=&crsnum; total+1; if p

%macro prtlast; proc print data=&syslast (obs=5); title "Listing of &syslast data set"; run;%mend;코드 설명:&syslast: 마지막 최근 데이터 셋!!%macro printdsn(dsn,va

%macro prtlast; %if &syslast ne NULL %then %do; proc print data=&syslast(obs=5); title "Listing of &syslast data set"; run; %end; %else %put No data s

Chapter 13 - Creating Indexes기본 simple index 형식 (1) data simple (index=(division)); set sasuser.empdata;run;기본 simple index 형식 (2) data simple2 (index

filename qtr1 ('c:\\data\\month1.dat''c:\\data\\month2.dat' 'c:\\data\\month3.dat');data work.firstqtr; infile qtr1; input Flight $ Origin $ Dest $

data work.data3; merge data1 data2; by x;run;proc sql; create table work.data3 as select \* from data1, data 2 where data1.x=data2.x;quit;교차 데이터 셋의 결합

proc print data=capacity (obs=4);run;data capacity; modify capacity; CapEcon = int(CapEcon .95); CapBusiness = int(CapBusiness .90);run;proc print d

proc fcmp outlib=orion.functions.dev; function ReverseName(name $) $40; return(catx('',scan(name,2,','),scan(name,1,','))); endsub;quit;options cmplib