Date:         Mon, 10 Mar 2008 15:19:13 -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: Strange SQL behavior on PC sas--bug?
Comments: To: "Pardee, Roy" <pardee.r@ghc.org>
In-Reply-To:  <8AD8F86B3312F24CB432CEDDA71889F20598798C@ex06.GHCMASTER.GHC.ORG>
Content-Type: text/plain; charset="us-ascii"

Roy:
On my office PC running MS Windows XP and SAS V9.1, the program produces
the expected (your Linux SAS) results. The same results appear in a
dataset after a CREATE TABLE ... AS ... statement.

no_obs fits the definition of CJ Date's TABLEDEE (header with empty
tuple) definition. Earlier I suggested that SAS add a TABLEDEE to the
SASHelp library.
S

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Pardee, Roy
Sent: Monday, March 10, 2008 2:55 PM
To: SAS-L@listserv.uga.edu
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