Lab05_Fall2011 - EXST 7003 Lab 05 Fall 2011 EXST 7003, Lab...

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

View Full Document Right Arrow Icon
EXST 7003 Lab 05 Fall 2011 1 EXST 7003, Lab 5: Data Transformations and Hypothesis Testing in SAS Week of: September 26 th – September 30 th DUE: October 4 th (section 1) or October 7 th (section 2 and 3) at the beginning of lab The Program The program which will be utilized in this lab, which each student will individually write, refer to, and answer questions about, is provided below. This program is discussed herein, and will be presented during lab. dm 'log;clear;output;clear'; OPTIONS nodate nocenter pageno=1 ls=78 ps=55; Title1 'EXST 7003 Lab 5'; Title2 'Your name'; DATA one; INFILE 'C:\ Documents and Settings\PAWS_ID\desktop\shoedata.txt' DLM=’,’; LENGTH region $ 25 product $ 15 subsidiary $ 15; INPUT region $ product $ subsidiary $ stores sales inventory returns; ID=_N_; lsales=log(sales); DROP inventory returns; RUN; ODS RTF FILE=’C:\Documents and Settings\PAWS_ID\output05.doc'; PROC CONTENTS data=one; Title3 'Proc contents of data set one'; RUN; PROC PRINT data=one; Title3 'Proc print of first 10 data lines from file'; WHERE ID<=10; RUN; PROC UNIVARIATE data=one PLOT NORMAL; VAR sales; Title3 'Proc univariate analysis of untransformed sales data'; Histogram sales; RUN; PROC UNIVARIATE data=one PLOT NORMAL; VAR lsales; Title3 'Proc univariate analysis of transformed sales data'; Histogram lsales; RUN; PROC TTEST data=one H0=5 ALPHA=.01; VAR lsales; Title3 'Proc ttest test of lsales equal to 5 at 0.01'; RUN; ODS RTF CLOSE; QUIT;
Background image of page 1

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

View Full DocumentRight Arrow Icon
EXST 7003 Lab 05 Fall 2011 2 The data The data set to be utilized for this week’s lab consists of sales, inventory, and returns data for a large, multi-national department store (e.g. Macy’s). The data set has been stored as a file, separate and external to the SAS program, much like the file that was utilized in last week’s lab. This file was originally stored as a Microsoft Excel spreadsheet file, but was converted into a comma separated values (CSV) file which will be read in by the SAS software package using a suitable statement structure. A CSV file is an ordinary ASCII-text (can be read by Windows Notepad) file, wherein individual values are separated by specified diacritical marks [in this case, commas (,)]. SAS is capable of reading other similar files; however, these files must be written in ASCII-text format (to check this, you can – and should – always try and open your file from a given text file reader, like Windows Notepad). This technique provides an easy way to have the SAS software read a lengthy or complex data file for processing; it is a technique which is most useful, especially for the analysis of complex research or field data. Note that it is necessary and imperative that the desired file exist on a drive and folder the SAS software can access. This data is similar to the department store data used in Lab 4; however, it is not the full data set – records from certain countries and regions have been deleted from the data set. Transformations
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/28/2011 for the course EXST 7003 taught by Professor Moser,e during the Fall '08 term at LSU.

Page1 / 4

Lab05_Fall2011 - EXST 7003 Lab 05 Fall 2011 EXST 7003, Lab...

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

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