Sub query convert Date

iwiebos04 — Thu, 27 Feb 2020 17:48:36 GMT

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);

Re: Sub query convert Date

PGStats — Thu, 27 Feb 2020 18:27:03 GMT

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;

Re: Sub query convert Date

iwiebos04 — Thu, 27 Feb 2020 19:06:11 GMT

Thanks a lot.

topic Sub query convert Date in SAS Programming

Sub query convert Date

Re: Sub query convert Date

Re: Sub query convert Date