Question

我用q语提取标语。该公司在Pogres实施罚款,但不是as。部分问题是:

(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

在斜体内,没有休息日期。我试用了日期。但它没有发挥同样的功能。我怎么能用 s子发表这一q语呢? 感谢。

Answer 1

rel=“noreferer”> DATEPART

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;

Answer 2

I think you can just use

MONTH(run_date)

以及

YEAR(run_date)

友情链接