Sample 31447: Counting the Number of Observations in a BY Group in SAS® Enterprise Guide
 |  |  |  |
SAS Enterprise Guide can be used to create a new variable in a data set that is a count of the number of observations in the BY group. The following steps demonstrate how to perform this task.
- Copy and run this DATA step program in a code node to create the sample data set:
/* Create sample data */
data old;
input state $ accttot;
datalines;
ca 7000
ca 6500
ca 5800
nc 4800
nc 3640
sc 3520
va 4490
va 8700
va 2850
va 1111
;
run;
- Select the OLD dataset in the Process Flow, then select Data > Filter and Query to open the Query Builder.
- Drag the STATE and ACCTTOT variables over to the Select Data tab, and then drag over a second copy of STATE. The Query Builder will rename the second copy STATE1.
- Select the STATE1 row to activate a drop-down box in the Summary column.
- Select Count from the drop-down box and note that STATE1 is renamed
COUNT_OF_STATE.
- In the Summary groups box beneath the list of variables, click the Edit Groups button.
- Move STATE from the Available columns box over to the Group by box, and then click OK.
- Click Run to run your query.
The final output dataset will look like this:
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.
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.
SAS® Enterprise Guide can be used to create a new variable in a data set that is a count of the number of observations in the BY group.
| Type: | Sample |
| Date Modified: | 2008-03-18 15:48:04 |
| Date Created: | 2008-03-12 16:29:39 |
Operating System and Release Information
| Product Family | Product | Host | Product Release | SAS Release | ||
| Starting | Ending | Starting | Ending | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Datacenter Server | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Server | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Professional | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows NT Workstation | 4.1 | 9.1 TS1M3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Windows Vista | 4.1 | 4.2 | 9.1 TS1M3 | 9.2 TS2M0 | ||