Working With SAS_2

Working With SAS_2 - Working With SAS Rajesh Chandwadkar...

Info iconThis preview shows pages 1–12. 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
Working with SAS SAS Data Library Importing files with import wizard Import Ms-Excel file Import Ms-Access table Import txt files, multiple rows Importing files with Proc import Importing data from multiple text files RDBMS tables using SAS/ACCESS
Background image of page 2
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 3

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 4
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 5

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 6
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 7

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 8
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. Windows 'c:\workshop\winsas\prog1' UNIX '/users/prog1' OS/390 'edc.prog1.sasdata' Making the Connection
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.employee employee Temporary SAS Filename The libref work can be omitted when you refer to a file in the work library. The default libref is work if the libref is omitted.
Background image of page 10
Creating library reference using Window option
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
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 / 34

Working With SAS_2 - Working With SAS Rajesh Chandwadkar...

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

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