|Getting Started with the SAS System Using SAS/ASSIST Software|
When you edit data one row at a time, only one row is shown per window.
|Tasks||Data Management||Edit/Browse||Edit Data|
First Row of HOUSES Table
The row number is located in the top of the window. Each window presents one row in the HOUSES table. Each window is called a record or a row. Each field in the window represents a column.
To move to different rows, select View from the menu bar. From the View pull-down menu, you can:
If you have too many columns to fit on one screen, each row has as many screens as necessary to display all the columns for the row. Use Next screen and Previous screen from the View pull-down menu to move from screen to screen within a row. The HOUSES table has only one screen per row.
You can also use the FORWARD, BACKWARD, RIGHT, and LEFT function keys to move from row to row and screen to screen.
To edit a row, position the cursor on the data you want to change, and type the new data over the old data.
For this example, display row 15 using the items from the View
menu or the function keys. Change the style to
Use this process when you want to add new information to the table. For example, you might want to add new houses for sale to the HOUSES table.
|Edit||Add New Record|
Adding a New Record
Type the data where the cursor is placed within each field after you press TAB. After you have typed all the data for the row, press ENTER. The numeric data aligns to the right of each field. The dollar sign and decimal are also added to the price after you press ENTER.
For this example, type the data as follows, and then press ENTER:
After you move to another row, the new row is assigned a row number.
If some rows are similar, you can duplicate a row and type in the data for the columns that are different.
For this example, display row number 1.
For this example, change the style to
If you make any changes to a row, you can cancel the changes as long as you have not moved to another row, saved the row, or ended the editing session.
XXXXXover the existing style.
|Edit||Cancel Current Changes|
|Creating a Subset of Your Data|
If you want to see only a part of the data (for example, if you only want to see all the houses for sale that are greater than 1500 square feet with three baths), you can create a subset of the data with a WHERE clause. The WHERE clause selects a subset of rows by comparing the values of the columns to the value you specify in the clause.
Select OK. As you move from row to row, only houses with more than 1500 square feet appear. The word Where appears at the top of the window to indicate a WHERE clause is in effect.
baths=3to select only the houses with three bathrooms.
The following is a list of some of the comparison operators that you can use in a WHERE clause (arithmetic, logical, and other operators are also available):
|LT or <||less than|
|GT or >||greater than|
|EQ or =||equal to|
|LE or <=||less than or equal to|
|GE or >=||greater than or equal to|
|NE or <>||not equal to|
|IN||equal to one in a list|
If you use character strings in the clauses, make sure they are enclosed in double
or single quotes and are in the correct case. For example, if you wanted to see only the ranch-style houses, you would type
style='RANCH'. The word RANCH needs to be in all capital letters because all the styles in the HOUSES table are in uppercase.
|Search||Undo last where|
Periodically, you may want to save any changes and additions you have made to the data so that they are stored permanently. The autosave feature saves the changes for you after 25 row modifications. You can change the autosave feature so that it saves data after any number of row modifications you specify. You can also save data at any time.
|Exiting the FSEDIT Window|
When you have finished editing the data, exit by following this selection path:
Top of Page
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.