24746 - Determine the last observation in a data set

Sample 24746: Determine the last observation in a data set

/* Create sample data */

data company;
  input division :$12. employees;
datalines;
sales 150
support 200
research 250
accounting 50
shipping 35
;

/* Calculate the total number of employees in each group. */
/* On the last observation of the data set, write out the */
/* resulting total.                                       */

data _null_;
  set company end=last;
  file print;

  /* Sum statement syntax has an implied RETAIN */
  total + employees; 

  /* For every iteration of the step, write out the values for */
  /* DIVISION and EMPLOYEES.                                   */
  put @1 division  @15 employees;

  /* On the last iteration of the step only, write out 4 dashes   */
  /* starting at column 15, move the internal pointer to the next */
  /* line and at column 15 write out the value of TOTAL.          */ 
  if last then put @15 '----' / @15 total;   

run;

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

sales         150
support       200
research      250
accounting    50
shipping      35
              ----
              685

Type:	Sample
Topic:	SAS Reference ==> DATA Step SAS Reference ==> Statements ==> File-handling ==> SET ==> with END=

Date Modified:	2008-02-28 15:24:51
Date Created:	2004-09-30 14:09:10

Product Family	Product	Host	SAS Release
			Starting	Ending
SAS System	Base SAS	All	n/a	n/a

E-mail This Page

Knowledge Base

Sample 24746: Determine the last observation in a data set

Operating System and Release Information

E-mail:
Password