110 likes | 329 Views
Fisheries Data Analysis Using The SAS System. DATA Step Programming. Importing data from Excel and dBase File…Import Wizard. Fisheries Data Analysis Using The SAS System. DATA Step Programming. Creating a SAS data set from a previously defined SAS data set… the SET statement.
E N D
Fisheries Data Analysis Using The SAS System DATA Step Programming. • Importing data from Excel and dBaseFile…Import Wizard
Fisheries Data Analysis Using The SAS System DATA Step Programming. • Creating a SAS data set from a previously defined SAS data set… the SET statement. • Since you are referring to a data set that has already been defined to SAS there is no need to define columns, variables, etc. • You can give it a new name or can ‘write over’ the existing name.
Fisheries Data Analysis Using The SAS System DATA Step Programming. • Creating a SAS data set from a previously defined SAS data set… the SET statement. • KEEP and DROP statements and • KEEP and DROP options.
Fisheries Data Analysis Using The SAS System DATA Step Programming. • Creating a SAS data set from a previously defined SAS data set… the SET statement. • From a SAS data set previously stored on disk.
Fisheries Data Analysis Using The SAS System DATA Step Programming. • Creating a SAS data set from a previously defined SAS data set… the SET statement. • Concatenating SAS data sets. • End-to-end • Interleaving
Fisheries Data Analysis Using The SAS System DATA Step Programming. • Creating a SAS data set from a previously defined SAS data set… the SET statement. • Saving SAS Data Sets to Disk.
Fisheries Data Analysis Using The SAS System More PROC MEANS • PROC MEANS with • DATA= • CLASS • OUTPUT & PROC PRINT
Fisheries Data Analysis Using The SAS System PROC TTEST
Fisheries Data Analysis Using The SAS System PROC UNIVARIATE
Fisheries Data Analysis Using The SAS System Homework • Read the three dBase files in M:\WEEK04\HOMEWORK into SAS • (since this uses a ‘wizard’ you don’t have to show this work) • Concatenate the three SAS data sets into one new data set and save that set to your own hard drive space (may use either a local drive on your computer, such as your C: drive or your network U: or P: drives) • In a separate data step subset the data for only striped bass and white perch • Run a PROC TTEST on the s.b. and w.p data to test for differences in average size • Subset the original concatenated data again for only croaker and run a proc univariate on fish length data with your selection of options. • Read DiIorio pages 54-57 and the SAS Language Guide pages 151-155 (not ‘Updating’)