Unformatted text preview:

Slide 1Sources of DataRecognize File TypesSlide 4Show File Extensions (Suffixes) in XPTypes of FilesSAS and EG filesSearchingFiles in Enterprise GuideShortcutsEG and CodeExternal SAS filesWhere are SAS Data Sets StoredLibrariesLibrariesChange the Default File LocationSlide 17Other OptionsCustom Code for GraphicsPermanent StoreLoading Data The Easy WaySlide 22Importing the Easy WaySlide 24Slide 25Slide 26Slide 27Slide 28Playing with dataSlide 30Slide 31Slide 32Slide 33Descriptive StatisticsSlide 35Working with Data in WindowsHRP223 – 2009Sept 28th, 2009 Copyright © 1999-2009 Leland Stanford Junior University. All rights reserved.Warning: This presentation is protected by copyright law and international treaties. Unauthorized reproduction of this presentation, or any portion of it, may result in severe civil and criminal penalties and will be prosecuted to maximum extent possible under the law.Sources of Data•Toy data–For statistics classes, you may be able to type in the data directly into a SAS code file.•Excel–For small amounts of HIPAA safe data you can use Excel with validation.•Text files with columns of numbers and text–Exports created by databases frequently provide a text file full of data and a program for loading it into SAS.•SAS –Native SAS datasets created by somebody else.Recognize File Types•Windows adds a period and a suffix that is a couple letters long to the names of files to indicate what program uses the file. By default the suffix is hidden.23 Uncheck415Follow these steps to show file extensions (suffixes) in Vista.Show File Extensions (Suffixes) in XP23 Uncheck415Types of Files.pdf Adobe portable document format.zip archives full of compressed data.xls Excel prior to 2007.xlsx Excel 2007 and later.csv comma separated values (text which Excel likes).txt text files .sas SAS code files.egp Enterprise Guide projects.sas7bdat SAS data files.htm or .html web pagesSAS and EG files•.sas files are text files full of instructions that a programmer can write and/or edit.•.egp files are not.Searching•Because the contents of .egp files are incomprehensible (without special tools) you will have trouble searching for things inside of projects.•This affects me when I can’t remember the name of a project and to find it I want to search for key words in the code (like the principal investigators name or the name of the source data file).–I can not find a tool to search the contents of all the .egp files on my hard drive.Files in Enterprise Guide•You can (and should) save SAS code files outside of the EG project to make it easy to search.•Most people create EG projects that reference data files that live outside of EG.–SAS datasets–Excel files –Text files full of dataShortcuts•Windows indicates a “shortcut” to a file that lives elsewhere with an arrow in the bottom left corner of an icon.•EG uses the same symbol to denote a shortcut to a file outside of the project.EG and Code•You can write and store your “code” instructions to SAS inside of the EG project or you can create a short cut to the code file which lives outside of EG.Right click and choose New > Program Look at the process flow No shortcut iconExternal SAS files•You can easily save a code file outside of the project by choosing Save Program As… from the File menu or clicking the Save or Save As … from the program tab (when the code is open).ShortcutWhere are SAS Data Sets Stored•While SAS can refer to files using their windows path, it is easier to type a short name instead of a long path. •SAS calls the short names “libraries”.•EG automatically knows about a couple places where data can be stored.–It creates a temporary work folder whenever EG starts.–It creates a permanent sasuser folder when EG is installed.•The locations for data are called libraries.Libraries•By default the data goes into the sasuser library. This is a very bad idea. •You will end up with every file in one folder. •Anybody using SAS can access that folder. So there are significant HIPAA issues.•Right click on a file and pick Properties to see where it is stored.Libraries•You can see the contents of libraries by going to the Server List window and opening the local libraries “file drawer.” If you accidentally close the window use the View menu.Double click the dataset to browse it.Change the Default File Location•On every machine you, use you should change the default file location to the work library. Do this once per machine.Click 1stClick 2xOther Options•To save your sanity, make this change to the options.Check this box onCustom Code for Graphics•Analyses in SAS 9.2 can have extra high resolution graphics. Permanently turn them on.Permanent Store•I suggest that you save your data into the temporary work library by default. •If you have a huge file which you only want to import once, or if you want to keep a permanent copy of a SAS data file, you will want to set up a permanent library.–This is just a fancy way of specifying what folder SAS should use to save the .sas7bdat data files.Loading Data The Easy Way•First fix the problematic registry entries that are described in the instructions on installing SAS.www.stanford.edu/class/hrp223/2009/install/ •If you have mixtures of characters an number variables in a column in Excel programs reading the data (including SAS) can drop the cells that have character data without warning.SASRImporting the Easy Way•The most bulletproof way for importing with EG 4.2 is to use the import wizard.1st rename the node to match the library name2nd add a line to the flowchart connecting the library to the import. It just looks good.Playing with data•Once the data is imported you can add code “nodes” to the flowchart or use the graphical user interface to tweak the data and do analyses.Complex changesQuick and easy subset and sortingIt gives you more options as you add in sort variables.SQL is built behind the scenes.Context sensitive menus help you describe the data you are browsing.Descriptive


View Full Document

Stanford HRP 223 - Working with Data in Windows

Download Working with Data in Windows
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Working with Data in Windows and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Working with Data in Windows 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?