Page 92 - SAS_manual

First.var: Created during data step execution when there is by statement used.

Last.var: These variables are temporary in nature.

Program 7.40: Output:

First.var : has value 1, if SAS process first observation to a new value for given variable other wise zero.

Last.var : has value 1, if SAS process first observation to a new value for given variable other wise zero.

Here class_gender is the sorted data of sashelp.class.

7.12 PROC IMPORT:

The IMPORT procedure reads external data and writes the data to a SAS data set.

1) Import wizard:

To use the Import Wizard, follow these steps.

1. Select File ►Import Data.

2. Do not select Microsoft Excel Workbook. This is for 64-bit Office, not 32-bit Office.

3. Select Microsoft Excel on PC Files Server, as shown in this image, and click Next.
4. The Connect to Ms Excel dialog box appears. Click Browse

SAS HANDBOOK | VISIT:: http://nikhilanalytics.com 92