请教个问题

shiyiming

sas如何返回某日是一个月的第几周

shiyiming

[code:1rh8d9d3]data _null_;
mydate='20NOV11'd;
i=intck('week.2', intnx('week', intnx('month', mydate, 0, 'b'), 0, 'b'), mydate);
put i=;
run; [/code:1rh8d9d3]

shiyiming

谢了

shiyiming

[quote="shiyiming":1v9e2y5e][code:1v9e2y5e]data _null_;
mydate='20NOV11'd;
i=intck('week.2', intnx('week', intnx('month', mydate, 0, 'b'), 0, 'b'), mydate);
put i=;
run; [/code:1v9e2y5e][/quote:1v9e2y5e]
施主：有一事不明，缘何在此week.2 & week 混合使用？京剧

shiyiming

to 京剧
week的作用是用函数intnx获得本周的第一天（周日）。
week.2的作用是用函数intck计算两个日期之间有几个周一（中国人貌似习惯周一是每周的第一天）。

shiyiming

oh, thanks.jingju

shiyiming

sorry, try May 1, 2011.

data _null_;
mydate='1MAY11'd;
i=intck('week.2', intnx('week', intnx('month', mydate, 0, 'b'), 0, 'b'), mydate);
put i=;
run;