Date: Thu, 26 Apr 2007 17:57:37 -0400
Reply-To: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject: Re: Separating dataset into smaller datasets based on value of a
Content-Type: text/plain; charset="us-ascii"
The WWW uses IP addresses as indexing variables, so you should be able
to do the same. Knowing the form of an IP address, however, doesn't tell
us that much about how you have them stored. If a column in a typically
short transaction record, with no particular ordering of records, SAS
has many options for grouping records by IP address and operating on one
group at a time, so to speak. No need to create many different physical
datasets to process records BY IP address. A brief description of what
you are trying to accomplish and an example of the structure of the
dataset that you have could help SAS-L help you. Please also include
more specific dimensions (such as record length and what 'large' means
in this case).
From: firstname.lastname@example.org [mailto:email@example.com]
On Behalf Of Randall Powers
Sent: Thursday, April 26, 2007 4:18 PM
Cc: Randall Powers
Subject: Separating dataset into smaller datasets based on value of a
Hello, first time poster here.
I have a large SAS dataset which has a number of string variables. One
particular string variable is ip address (for example 555.987.65.43).
There are very, very many different ip addresses. What I wish to do is
separate the data into smaller datasets based on ip address, such that
each new dataset consists of rows pertaining to each specific ip
address. The number of ip addresses are such that I can't write code to
address each one (i.e. a series of if-then statements).
Does anybody have any suggestions how they would do this?
Many thanks in advance.