Date: Wed, 24 Mar 2004 16:09:57 -0500
Reply-To: Venky Chakravarthy <venky.chakravarthy@PFIZER.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Venky Chakravarthy <venky.chakravarthy@PFIZER.COM>
Subject: Re: SQL vs. DATA Step
Since you are working in Pharma, a good mix of both is important.
Personally, I have found that there is a remarkable increase of SQL in my
code. There is constant pulling of data from various tables and I find that
SQL manages this more easily than the data step.
On the other hand as you approach the end of your program to output your
table, the data step seems to have a clear advantage. BY group processing
and transposing data with arrays can quickly get you to the required table
So both are important. The choice depends upon the task at hand and to some
extent upon the programmer's comfort level with the tool. Once you have
reasonable command over both, then the choice tends to be driven by the
task at hand, the way it should be.
Hope this helps.
On Tue, 23 Mar 2004 16:38:53 -0500, Ross, Michael D
>There seems to be two different ways of programming in the Sas world - Proc
>Sql and the Data Step. Could somebody help me see why I would want to use
>one versus the other. Maybe a list of Pro's and Con's.
>Thanks for your help!
>From: Philip Gallagher [mailto:PGall9898@AOL.COM]
>Sent: Tuesday, March 23, 2004 4:26 PM
>Subject: Re: Origins of FOO, thanks to andrea.wainwright
>I responded before I saw the note from Andrea Wainwright in which
>she said, in part,
>I remember there being three levels from some book I read:
>SNAFU - Situation Normal, All F*ed Up
>TARFU - Things Are Really F*ed Up
>FUBAR - F*ed Up Beyond All Repair
>Thanks, Andrea. I still maintain that Repair was originally Recognition,