Hello,  how I perform the granger causality test on panel data using Dumitrescu and Hurlin (2012) using SAS I have panel data.  Thanks   ... View more

Hello,  How to obtain previous observation by id Have secid sas_date      TNA 1        201501           345 1        201502         234 2        201501          278 2       201502           876   want  secid sas_date      TNA 1        201501           . 1        201502         345 2        201501          . 2       201502           278 ... View more

Hello I want to convert $50. to numeric. this is the dataset. when I run proc corr I have a error in the log "in list does not match type prescribed for this list"    ... View more

Hello,  I want to match names between tow database. the names are not exactly the same. I want to apprximate and after that make a hand check  I run this program but it gives no match proc sql ; create table results as select secid, FUND_NAME_MS, FUND_NAME from imf_samplenew , Infra_CRSP where imf_samplenew.FUND_NAME_MS eqt Infra_CRSP.FUND_NAME ; quit ; thanks ... View more

Hello,  I want the program not calculate flux and age if it is the first secid. I write this but it does not work. it still calculate for the first secid. What is wrong with this  if first.secid then call missing(flux, age); thanks data ageyear; set inception; Age = yrdif(Inception_date, sas_date,'Actual'); flux=(TNA-lag1(TNA)*(1+mret))/(lag1(TNA)); if first.secid then call missing(flux, age); run; ... View more

Hello how to drop column variable form the output of proc means? I was able to drop le column label by using NOLABELS thanks ... View more

Hello,  when I run the program below there is no error in the log but the variable EPU is empty "." proc sql; create table test1 as select Distinct R.*, B.EPU from test as R left join EPU_Data as B on R.sas_date=B.sas_date order by R.Secid, R.sas_date; quit; ... View more

hello I want to obtain the previous date. my date format is YYMMN6. for example I have 201501, I want that the program give the previous month 201412 thanks ... View more

hello  I want to select the first observation by secid and grp. I try this but it give me the first observation by secid only data first_by_group; set rolling12; by secid grp; if first.secid and first.grp then output; run; ... View more