Date:         Tue, 12 Oct 2004 11:37:51 -0400
Reply-To:     Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject:      Re: data mining
Comments: To: Daniel Reyes <junkdalejreyes@YAHOO.COM>

First things first: creating a SAS dataset may be difficult. It appears
that addresses and within-structure identifiers have embedded blanks, and
that blanks are also the field delimiters. There are conventions for this
(quoting, using two consecutive blanks between fields), but it does not
appear that your file uses either of these.

The ugliest record is

   102 Main St 3rd FL N 0

I can see that the address has three "words" and the WSI has two, but the
computer cannot; consider

   103 Red River Road #4 N 0

where the five words are split 4/1 rather than 3/2.

On Thu, 7 Oct 2004 10:39:41 -0700, Daniel Reyes <junkdalejreyes@YAHOO.COM>
wrote:

>I have a dataset of what we call basic street
>addresses--locations in which more than one address
>may be found, like apartment buildings.  Examples
>include:
>
>101 Main St Y 2
>101 Main St Apt1 Y 0
>101 Main St 2FL N 0
>
>102 Main St Y 3
>102 Main St 2 N 0
>102 Main St 3rd FL N 0
>102 Main St BSMT N 0
>
>103 Main St Y 4
>103 Main St #4 N 0
>103 Main St STE6 Y 0
>103 Main St ATTC Y 0
>
>Each record of the BSA will have a "within-structure"
>identifier (eg, 1 or BSMT, etc), EXCEPT for the first
>instance when sorted by the address.
>
>Each record has a flag set called INCENSUS (Y or N).
>
>Each record has a flag set called NUMFAM (numeric,
>0-999).
>
>I want to extract all BSAs (and their corresponding
>records) in which the number of the NUMFAM flag DOES
>NOT equal the total of good census records for the BSA
>(Ys).
>
>Therefore, for the example above, I ideally would like
>to see this in the output:
>
>102 Main St Y 3
>102 Main St 2 N 0
>102 Main St 3rd FL N 0
>102 Main St BSMT N 0
>
>103 Main St Y 4
>103 Main St #4 N 0
>103 Main St STE6 Y 0
>103 Main St ATTC Y 0
>
>Hope someone can help...please email me directly
>
>Thanks.
>Dan
>
>
>
>__________________________________
>Do you Yahoo!?
>Y! Messenger - Communicate in real time. Download now.
>http://messenger.yahoo.com