Hi, I have a dataset like this: data A;     input code $ type $12.;     cards;     ASD1    6,8,14     ASD2    14     ASD3    4,8,14     ASD4    4,8,14     ASD5    14     ASD6    1,2,4,8,11     ASD7    5     ASD8    2,5 run; How can I transfer this dataset to following form: ASD1 6 ASD1 8 ASD1 14 ASD2 14 . . . ASD8 2 ASD8 5 Thanks in advance for any help! ... View more

Hi, I am trying to generate missing value with "IFN" function, like this, proc sql;     create table E0 as     select    A.stkcd,             A.year,             ifn(missing(A.sales)+missing(B.sales)+missing(C.sales)=0,std(A.Sales,B.sales,C.sales),"") as std     from firmchar.CAL_Earnings as A     left join firmchar.CAL_Earnings as B on A.stkcd=B.stkcd and A.year=B.year+1     left join firmchar.CAL_Earnings as C on A.stkcd=C.stkcd and A.year=C.year+2; quit; Well, it seems generating missing value with IFN function is NOT allowed. Yet I do not want calucalte standard error if any one of three variables is missing. So, is there any way to solve this? say, some similar alternative functions. Many THX!!! ... View more

Hi, I want get a variable (num) in sql procedure this is sql code: proc sql;     create table rm as     select    distinct year(date) as year,week(date) as week,sum(_COL7) as rm     from    stk.MarketIndex as A     group by year(date),week(date); quit; and  then data rm2;      set rm;      num=_N_; run; can I do it in sql? THX! ... View more