Date: Tue, 28 Sep 2010 11:14:25 -0400
Reply-To: bbser2009 <bbser2009@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: bbser2009 <bbser2009@GMAIL.COM>
Subject: Re: proc append with force option
In-Reply-To: <201009281213.o8SAkdY1029138@willow.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"
Thank you so much, Art. That certification does have several typos or
errors.
Anyway, thank you for confirming this, which adds confidence to me taking
the certification exam. :)
Max
-----Original Message-----
From: Arthur Tabachneck [mailto:art297@NETSCAPE.NET]
Sent: September-28-10 8:14 AM
To: SAS-L@LISTSERV.UGA.EDU; Bbser 2009
Subject: Re: proc append with force option
Max,
I looked at the example you indicated and, like my colleagues indicated,
the example is wrong.
In fact, they appear to be describing the results of using proc append,
but with clinic.append as the base and clinic.therapy as the data. But,
even if that were the case, the order of the records doesn't match (i.e.,
the records from clinic therapy are shown first).
Also, interestingly, if that were the case (i.e., if clinic.append was use
as the base), the force option wouldn't have been needed.
Hopefully, someone from SAS publishing is reading the list today!
Art
--------
On Tue, 28 Sep 2010 01:26:42 -0400, bbser2009 <bbser2009@GMAIL.COM> wrote:
>Thanks for your confirmation, Art.
>Well, my example is kind of like this:
>
>Appending the second to the first below using force option:
>
>obs x
>1 1
>
>
>obs x y
>1 2 2
>
>then i get:
>
>obs x
>1 1
>2 2
>
>
>Regards, Max
>
>-----Original Message-----
>From: Arthur Tabachneck [mailto:art297@NETSCAPE.NET]
>Sent: September-27-10 11:32 PM
>Subject: Re: proc append with force option
>
>Max,
>
>I really should read the subject line before responding to a post.
>
>You had asked about proc append. If the file you identified as the base
>file had two variables, and you used the force option, yes I would expect
>the base file to only contain the two variables).
>
>Can you show the example you tried to show with your link?
>
>Art
>---------
>On Mon, 27 Sep 2010 23:16:43 -0400, Arthur Tabachneck
><art297@NETSCAPE.NET> wrote:
>
>>Max,
>>
>>The link you provided doesn't bring up a specific page, thus I'm not sure
>>what the example is. If it is a set, followed by two filenames, I would
>>expect the resulting file to include all of the variables identified in
>>either file, with those not existing on one of the files to be set to
>>missing.
>>
>>Art
>>---------
>>On Mon, 27 Sep 2010 23:03:30 -0400, bbser2009 <bbser2009@GMAIL.COM>
wrote:
>>
>>>I do not understand the example on Page 383, SAS base programing, 2nd
Ed.
>>>This is about appending two SAS data sets.
>>>
>>>In this example, the BASE= data set has two variables Num and Sex, the
>>DATA=
>>>data set has three varaibles Num, Sex, and State.
>>>I would expect in this case, the resulting data set only has two
>variables
>>>Num and Sex, instead of three as given in the example.
>>>
>>>Can anyone help me check this out? You may see this example by copy and
>>>paste this link below and then find the link named contents and then
>>choose
>>>the page number 383.
>>>
>>>http://books.google.ca/books?
>>id=QrAIWGwF0sYC&printsec=frontcover&dq=base+pro
>>>graming,+sas,+2nd&source=bl&ots=Z2vyv9_lZ8&sig=AvoUUIOENKJMnkB9kcaVsNlVP
7
>8
>>&h
>>>l=en&ei=DVihTMmuA5KonQf-y8W-
>>Aw&sa=X&oi=book_result&ct=result&resnum=3&ved=0C
>>>BsQ6AEwAg#v=onepage&q&f=false
>>>
>>>
>>>
>>>Thanks a lot in advance, Max
| 
