equivalent date_part function in sas
19,470
data have;
timestamp='01JAN2012:08:48'dt;
run;
proc sql;
select datepart(timestamp) format=mmddyy10.,
timepart(timestamp) format=time.,
month(datepart(timestamp)),
year(datepart(timestamp))
into :date , :time, :month, :year
from have;
quit;
%put DATE: &date;
%put TIME: &time;
%put MONTH: &month;
%put YEAR: &year;
Author by
swingfuture
Updated on June 04, 2022Comments
-
swingfuture almost 2 years
I have a sql statement to extract date object. It runs fine in Postgres but not sas. Part query is like this:
(case when date_part('month',run_date)::integer < 10 THEN '0'|| date_part('month',run_date)::varchar(1)|| date_part('year',run_date)::varchar(4) else date_part('month',run_date)::varchar(2)||date_part('year',run_date)::varchar(4) end) as our_date
In sas, there's no date_part function. I tried datepart function. But it's not performing the same functionality. How could I make that sql statement run in sas? Thanks.