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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.