topic Re: Select all in SAS Programming

Select all

JamesKF — Fri, 01 Feb 2013 11:55:00 GMT

Hi, I have been trying the Select all query (*) in SAS Entersprise Guide and it is not going. Could somebody help please.

The query is

SELECT * FROM table

WHERE Date is '31MAR2011'D;

VD — Fri, 01 Feb 2013 13:00:28 GMT

Looks like it is something to do with the WHERE statement.

1. Use '=' or 'in' instead of 'is'.

2. Check that the date format is correct.

Ankitsas — Sat, 02 Feb 2013 08:58:04 GMT

Hi James,

Below is the code you should use to get the desired output.

proc sql;

create table table-name as

SELECT * FROM table

WHERE Date = '31MAR2011'D;

quit;

Thanks,

Ankit

Kongnyuy — Mon, 04 Feb 2013 09:20:11 GMT

Thanks Guys.