Date:         Mon, 10 Mar 2008 15:15:14 -0400
Reply-To:     Bob_Abelson@HGSI.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bob_Abelson@HGSI.COM
Subject:      Re: Strange SQL behavior on PC sas--bug?
In-Reply-To:  <8AD8F86B3312F24CB432CEDDA71889F20598798C@ex06.GHCMASTER.GHC.ORG>
Content-Type: text/plain; charset=us-ascii

I ran this code on my PC and got the same result as Roy.

Bob Abelson
HGSI
240 314 4400 x1374
bob_abelson@hgsi.com



"Pardee, Roy" <pardee.r@GHC.ORG>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
03/10/2008 03:05 PM
Please respond to
"Pardee, Roy" <pardee.r@GHC.ORG>


To
SAS-L@LISTSERV.UGA.EDU
cc

Subject
Strange SQL behavior on PC sas--bug?






Hey All,

A collegue posted this to an internal listserv here & I suggested
tapping you kind folks about it.  Consider this code:

* ---------------------------- ;

data junk;
    x=5;
run;

data no_obs;
    set junk (where=(x=1));
run;

proc sql _method ;
  select  "I am a text literal" as lit,
          "&sysdate"d as datey format=mmddyy10.,
          count(*) as NumObs
  from no_obs
  ;

quit;

* ---------------------------- ;

When we run that on our unix machine, the literal & macro var get
processed & we get (as we expect):

lit                       datey    NumObs
-----------------------------------------
I am a text literal  03/10/2008         0


but when we run on our local PCs we get missings for the literal and the
macro var expression:

lit                       datey    NumObs
-----------------------------------------
                              .         0

When you look at the _METHOD output, there's an extra sqxfil step on the
PC output.

Is this just a matter of having different options specified on the 2
platforms?  Can anybody reproduce our PC results?

Thanks!

-Roy

Roy Pardee
Research Analyst/Programmer
Group Health Center For Health Studies (Cancer Research Network)
(206) 287-2078
Google Talk: rpardee