| Date: | Thu, 23 Aug 2001 09:57:14 -0700 |
|---|
| Reply-To: | Steve <guitarzealot@YAHOO.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Steve <guitarzealot@YAHOO.COM> |
|---|
| Organization: | http://groups.google.com/ |
|---|
| Subject: | Dates on between not working? |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
OK, I used this PROC SQL on the mainframe and it worked fine.
But when I tried it on on my PC using SAS 6.12 I did not
get the rows back. Is there something on the PC SAS that is
different with PROC SQL? Any ideas?
Thanks
Steve
PROC SQL;
CREATE TABLE QTR3 AS
SELECT * FROM DATA3
WHERE INVDATE BETWEEN '01JUL01'D AND '30SEP01'D ;
NOTE: Table WORK.QTR3 created, with 0 rows and 2 columns.
The input is
INFILE 'D:\SASLEARN\CBACK.TXT';
INPUT @1 DMEMO $10.
@12 INVDATE YYMMDD10.
;
| 
