a********a 发帖数: 346 | 1 How can I transfer the data structure from one to two? Basically I want to
get the visit date difference for other visits to visit 0, and value
difference for other visits to visit 0. Thanks
data one;
input id visit date ddmmyy10. value;
format date ddmmyy10.;
datalines;
1 0 1/1/2010 0.5
2 0 3/1/2010 0.8
2 2 5/1/2010 1.5
2 4 7/1/2020 0.3
3 0 4/5/2010 1
3 2 6/5/2010 0.9
;
r |
|
s****d 发帖数: 244 | 2 各位大神,我用下面的代码合并两个数据库,但是合并后的数据库中prices都为
missing value。请教是怎么回事啊?谢谢!
data bm;
set bm;
rename standard_and_poor_s_identifier=gvkey
historical_CRSP_permno_link_to_C=permno
data_date=date
company_name=cname
common_shares_used_to_calculate=cshr
var7=eps
Market_Value___Total=market;
format date ddmmyy10.;
cyear=year(date);
quarter=qtr(date);
run;
data mylib.prices;
set mylib.prices;
format date date9.;
cyear=year(date);
quarter=qtr(date);
run;
proc sql;
cr... 阅读全帖 |
|
d******9 发帖数: 404 | 3 A=input(date, ddmmyy10.)
datevar=put(A,date9.) |
|