proc sql;
create table slc.NEWSYS_201610_1 as
select *
from Slc.NEWSYS_201610
where Open_DT between "01Jan2019"d and "31JAN2020"d;=
(select Open_DT between "01Jan2019"d and "31JAN2020"d ;
Open_Date = datepart(Open_DT)
format Open_DT datetime. Open_Date date9);
run;
above is my query
Below is the error message.
Please what am i doing wrong. I am new to SAS
NOTE: Table SLC.NEWSYS_201610_1 created, with 0 rows and 72 columns.
34 ! =
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
35
36 (select Open_DT between "01Jan2019"d and "31JAN2020"d ;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
37 Open_Date = datepart(Open_DT)
_________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
38
39 format Open_DT datetime. Open_Date date9);
Correct syntax:
proc sql;
create table slc.NEWSYS_201610_1 as
select
*,
datepart(open_dt) as open_date format=date9.
from Slc.NEWSYS_201610
where datepart(Open_DT) between "01Jan2019"d and "31JAN2020"d;
quit;
Correct syntax:
proc sql;
create table slc.NEWSYS_201610_1 as
select
*,
datepart(open_dt) as open_date format=date9.
from Slc.NEWSYS_201610
where datepart(Open_DT) between "01Jan2019"d and "31JAN2020"d;
quit;
Thanks a lot.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.