Date:         Mon, 21 Aug 2006 04:12:10 -0700
Reply-To:     RolandRB <rolandberry@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         RolandRB <rolandberry@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Simple string breaks SAS 8.2 and 9.1.3 SP4
Comments: To: sas-l@uga.edu
In-Reply-To:  <1156134658.042957.71100@m73g2000cwd.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Jacek schrieb:

> A friend of mine discovered that the following code breaks both SAS 8.2
> and 9.1.3 SP4
> I wonder if somebody could explain what happens.
>
> Thanks,
> Jacek.
>
> data test;
>     x=1; y=1; output;
>     x=2; y=.; output;
>     run;
>
> proc sql;
>     select x from test where y ne .;
>     quit;
>
> data _null_;
>     a = "% %str({})"; /* a = "% %str(())"; breaks it too */
>     put a;
> run;
>
> proc sql;
>     select x from test where y ne .;
>     quit;
>
> /* proc sql does not work anymore */

Thanks. It made me laugh. I always thought that SQL was evil in any
case.