Exercise_Week4_Answer - MATH2871 DATA MANAGEMENT FOR...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS SEMESTER 2, 2010 Lab exercise Week4 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 a FORMAT statement to the DATA step to create the following PROC PRINT report. The labels need to be changed for Customer_Gender, Customer_BirthDate, and Customer_Group. The format needs to be changed for Customer_BirthDate. (Not necessary because Customer_BirthDate is already in the correct format.) Hint: Do not forget the option in the PROC PRINT step that enables the labels to appear. libname orion 'P:\Math2871'; data work.youngadult; set orion.customer_dim; where Customer_Gender='F' and Customer_Age between 18 and 35 and Customer_Group contains 'Gold'; keep Customer_Name Customer_Age Customer_BirthDate Customer_Gender Customer_Group; label Customer_Gender='Customer_Gender ' Customer_Group= Customer_Group ; run ; proc contents data=work.youngadult; run ; proc print data=work.youngadult label; run ; Customer Customer_ Customer Obs _Gender Customer Name BirthDate Customer_Group Age 1 F Sandrina Stephano 09 JUL1979 Orion Club Gold members 28 2 F Cornelia Krahl
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/12/2011 for the course ASB 1001,2522, taught by Professor Nicole during the One '09 term at University of New South Wales.

Page1 / 4

Exercise_Week4_Answer - MATH2871 DATA MANAGEMENT FOR...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online