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;
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.
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
Thanks Guys.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.