Transcript השימוש בEquation Editor- וב

‫‪ SAS‬למתחילים‬
‫מרכז המחשבים‬
‫מרץ ‪2008‬‬
‫אירית חסיד‬
‫טל‪04-8293694 :‬‬
‫דוא"ל‪[email protected] :‬‬
‫מטרות‬
‫► היכרות עם ממשק ‪SAS Enterprise Guide‬‬
‫► ייבוא נתונים ‪,‬ועבודה עם נתונים‬
‫► יצירת דוחות ‪.‬‬
‫► הדוגמאות והתרגילים עושים שימוש בקבצי הנתונים‬
‫הקיימים במחשבים בהם הותקנה התוכנה בכיתה בתיקייה‪:‬‬
‫‪d:\sas-course\zqjegqr4\egqr4‬‬
‫את קבצי התרגילים ניתן לשמור ב‪d:\sas-course :‬‬
SAS Enterprise Guide Structure
► To
begin work with SAS Enterprise Guide
 1. create a project
 2. add data to the project
 3. run tasks against the data.
Navigating the SAS
Enterprise Guide Workspace
Main Window
► To
reset all windows to their original
positions, select Tools -> Options from the
menu bar.
► Select Reset Docking Windows -> OK.
Using SAS Enterprise Guide
‫כניסה לתוכנה‬
start > Programs > SAS >
Enterprise Guide 4
‫חלונות עיקריים‬
‫סרגלי כלים‬
Active Data
displays the active data item in the Project Explorer and process flow. You can
use the drop-down list to select a new active data item, or you can select
the data item from the Project Explorer or process flow.
Control
enables you to control the processing of code, tasks, queries, and stored
processes.
Project
‫ם‬
enables you to add new items (project, process flow, stored process, data, code
and note) to the current project.
View
enables you to open the nine separate windows that comprise the SAS
Enterprise Guide application and minimize or maximize the workspace.
Standard
enables you to manage your files. For example, from this toolbar you can
create new files, save existing files, cut and paste text, delete text, and
search for text.
‫ייבוא נתונים‬
‫►‪1‬‬
‫►‪2‬‬
‫►‪3‬‬
‫הפיכת קבצי נתונים מסאס לאקסל‬
‫► סידרת תרגילים מספר ‪...1‬‬
Common Data Formats
SAS Data Tables
► Names
can be 1 to 32 Characters long.
► Labels for the columns can be up to 256
characters in length.
Adding a Local Excel
Spreadsheet to the Project
► File
-> Open -> Data… from the menu
bar.
► Select Local Computer to find the data
source in your Windows directory.
► Navigate to the location of the data and
verify that the Files of type field contains a
value of All Known Data Files(*.*). Doubleclick on the file.
To insert a column, select Data -> Columns ->
Insert from the menu bar.
‫► סידרת תרגילים מספר ‪...2‬‬
Getting Started with Tasks
Creating a Listing Report
► By
default, SAS Enterprise Guide generates
results in HTML format. To generate results
in the PDF and RTF formats, right-click on
the List Data task in the Project Explorer or
Process Flow window and select
Properties.
► Select Results in the Selection pane. Select
the Override the preferences set in
Tools -> Options, HTML, PDF, and RTF
check boxes. Select OK.
Using Variable Parameters in
Tasks
► Parameters
(macro variables) can be used
in tasks, queries, and code.
► Select Tools -> Parameters (Macro
Variables) Manager to open the window.
‫► סידרת תרגילים מספר ‪...3‬‬
Select Data tab
► select
columns to output
► assign aliases and labels
► apply formats
► group data
► perform summary functions
► eliminate duplicate rows
► The
properties of a column that can be modified
include the Alias (name), Label, and Format.
► To add all columns from a table into a query,
right-click on the table name and select Add All
Columns to Selection. For tables with many
columns, it might be helpful to arrange the column
names in alphabetical order by selecting Sort by
Column Names.
Creating New Columns with an
Expression
‫► סידרת תרגילים מספר ‪... 4‬‬