DATA Step, Macro, Functions and more

Select all

Reply
N/A
Posts: 1

Select all

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;

Frequent Contributor
Frequent Contributor
Posts: 94

Re: Select all

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.

Occasional Contributor
Posts: 14

Re: Select all

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

N/A
Posts: 1

Re: Select all

Thanks Guys.

Ask a Question
Discussion stats
  • 3 replies
  • 195 views
  • 0 likes
  • 4 in conversation