MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS
SEMESTER 2, 2015
Lab exercise Week 6
1. Cleaning DATA from orion.price_current
a. Retrieve the following starter program p108e08.
proc means data=work.price_current n min max;
var Unit_Sales_Price;
run;
pr
Q1.
libname orion 'D:\math2871';
data work.allorders work.nostaff;
set orion.staff orion.orders;
run;
data work.allorders work.nostaff;
merge orion.staff (in=A) orion.orders (in=B);
by employee ID;
if A=1 and B=1 then output work.allorders;
else if A=1 an
SAS WORK PLACEMENT PROGRAM
GEORDIE TAIT ACADEMIC PROGRAM MANAGER
AUSTRALIA & NEW ZEALAND
C op yr i g h t 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .
OUTLINE SAS WORK PLACEMENT PROGRAM
Who is SAS?
Industries, Customers
What
COURSE OUTLINE
MATH2871
DATA MANAGEMENT FOR STATISTICAL
ANALYSIS
Semester 2, 2015
Cricos Provider Code: 00098G Copyright 2015 -School of Mathematics and Statistics, UNSW
MATH2871 Course Outline
Information about the course
Course Authority and lecturer: D
MATH2871
Data Management for Statistical
Analysis
Session 2, 2015
School of Mathematics and
Statistics, UNSW
Lecturer
Dr Leung Lung Chan
Office: Red Centre 1036
Email: [email protected]
Best method of contact
Put MATH2871 in the subject of your
UNSW SCHOOL OF MATHEMATICS
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS
ASSIGNMENT 4
TOTAL MARKS 20 (10 % of final grade)
Number of Questions: 4
Due: 9:05 am (at beginning of Week 12 lecture)
Please hand-in your assignment with the assignment coversh
UNSW SCHOOL OF MATHEMATICS
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS
ASSIGNMENT 3 SOLUTIONS
Q1. [10 marks]
SAS code This is just one way of coding for Q1. Any alternative code will be
accepted.
proc format;
value period low-3000 = 'Short'
3000-<80
UNSW SCHOOL OF MATHEMATICS
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS
ASSIGNMENT 2
TOTAL MARKS 20 (10% of final grade)
Number of Questions: 2
Due: 9:05 am (at beginning of Week 6 lecture)
Please hand-in your assignment with the assignment covershee
UNSW SCHOOL OF MATHEMATICS
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS
ASSIGMENT 1
TOTAL MARKS 20 (10% of final grade)
Due: 9:05 AM (at beginning of Week 4 lecture)
Please hand-in your assignment with the assignment coversheet. No coversheet, no mar
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS
SEMESTER 2, 2015
Lab exercise Week 8 answers
1. Defined Ranges in User-Defined Formats
a. PROC PRINT step is given as the following.
proc print data=orion.nonsales;
var Employee_ID Job_Title Salary Gender;
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS
SEMESTER 2, 2015
Lab exercise Week 5
1. Reading a Comma-Delimited Raw Data File.
a. Open p107e01. Add the appropriate LENGTH, INFILE and INPUT statements to read the
comma-delimited raw data file named, ne
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS
SEMESTER 2, 2015
Lab exercise Week 4
1. Adding permanent attributes Work.youngadult.
a. Submit p105e04. Notice the format and labels stored in the descriptor portion of Work.youngadult.
b. Add a LABEL and
Chapter 1 : Overview of foundation SAS
Describe the functionality of Foundation SAS.
Describe the structure and design of Foundation SAS.
1
What Is Foundation SAS?
Foundation SAS is a highly flexible and integrated
software environment that can be used in