Working With SAS_LT1

Working With SAS_LT1 - WorkingWithSAS RajeshChandwadkar...

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

View Full Document Right Arrow Icon
    Working With SAS  Rajesh Chandwadkar 
Background image of page 1

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

View Full DocumentRight Arrow Icon
    BASE SAS  Working with Library  Creating SAS Data Set  In stream data List Input, Column input, Formatted input Different delimiters (space, comma, Tab) Importing data (External Files) Infile Statement (txt file) Import Wizard (Txt, Excel, Access) Programming with SAS Data sets (If-Else, Do) Merging SAS Data Sets  Working with Proc SQL
Background image of page 2
    The functionality of the SAS System is  built around the four data-driven tasks  common to virtually any application: 1.  Data access  2.  Data management  3.  Data analysis 4.  Data presentation. Data-Driven Tasks
Background image of page 3

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

View Full DocumentRight Arrow Icon
    Process of delivering meaningful information: 80% data-related access scrub transform manage store and retrieve 20% analysis . Turning Data into Information
Background image of page 4
    DATA  Step SAS  Data   Sets Data PROC  Steps Information Turning Data into Information
Background image of page 5

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

View Full DocumentRight Arrow Icon
    DATA steps are typically used to create SAS data sets. PROC steps are typically used to process SAS data sets (that is, generate reports and graphs, edit data, and sort data). A SAS program is a sequence of steps that the user submits for execution. Raw Data DATA Step Report SAS Data  Set SAS Data  Set PROC Step SAS Programs
Background image of page 6
    A SAS data library is a collection of SAS files that are recognized as a unit by SAS. OS/390: userid .mysas.files Windows: c:\mysasfiles UNIX: /users/dept/mysasfiles SAS Data Library SAS File SAS File SAS File OS/390 (MVS) A SAS data library is an operating system file. Directory-based A SAS data library is Systems a directory. A SAS data set is a type of SAS file. SAS Data Libraries
Background image of page 7

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

View Full DocumentRight Arrow Icon
    FILES LIBRARIES You can think of a SAS data library as a drawer in a filing cabinet and a SAS data set as one of the file folders in the drawer. SAS Data Libraries
Background image of page 8
    Regardless of which host operating system you use, you identify SAS data libraries by assigning each a library reference name ( libref ). libref Assigning a Libref
Background image of page 9

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

View Full DocumentRight Arrow Icon
    work sasuser ia work - temporary library sasuser - permanent library When you invoke SAS, you automatically have access to a temporary and a permanent SAS data library. You can create and access your own permanent libraries. ia - permanent library SAS Data Libraries
Background image of page 10
    LIBNAME libref ' SAS-data-library ' <options>; Rules for naming a libref: must be 8 characters or less must begin with a letter or underscore remaining characters are letters, numbers, or underscores. Assigning a Libref You can use the LIBNAME statement to assign a libref to a SAS data library. General form of the LIBNAME statement:
Background image of page 11

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

View Full DocumentRight Arrow Icon
    libname ia 'c:\workshop\winsas\prog1'; libname ia '/users/prog1'; libname ia 'edc.prog1.sasdata' disp=shr; Assigning a Libref Examples: Windows UNIX OS/390
Background image of page 12
    When you submit the LIBNAME statement, a connection is made between a libref in SAS and the physical location of files on your operating system.
Background image of page 13

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

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

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 75

Working With SAS_LT1 - WorkingWithSAS RajeshChandwadkar...

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

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