data have; DateVar='November 2014'; run; data prep; set have; month = substr(datevar,1,3); year = scan(datevar,2,' '); run; data want; format new_date monyy7.; set prep; new_date = input(put(trim(month)||trim(year),$char7.),monyy7.); run; ... View more

If you need the display to look like this I would keep this column as your display, you can use substr() to cut up the format and then go with the MONYY. format for any calculations that need done. ... View more

I just looked at the output and it helps to complete the order by line: proc sql; create table want as select *,measure-sum_measure as calculated_value from( select *,sum(measure) as sum_measure from have group by id) order by id,measure; ... View more

It would be better to give an example of what you have and a small dataset that provides an example of what you are looking for.  I think this is what you want, let me know if this helps: data have; infile cards; input ID measure; cards; 1 1 1 2 1 3 1 4 1 5 2 2 2 4 2 6 2 8 2 10 ; proc sql; create table want as select *,measure-sum_measure as calculated_value from( select *,sum(measure) as sum_measure from have group by id) order by id; ... View more

here's another option but I like Hai.Kuo's better: data have; infile cards dsd; input ID Var1 Var2 Var3 Var4; cards; 1,.5,.,.,. 1,.,.5,.,. 1,.,.,.5,. 1,.,.,.,.5 2,.7,.,.,. 2,.,.7,.,. 2,.,.,.7,. 2,.,.,.,.7 ; proc sql; create table want as select distinct id, max(var1)as var1, max(var2)as var2, max(var3)as var3, max(var4)as var4 from have group by id order by id; ... View more

can you provide a small example of data that you have and data that you are trying to get? ... View more

Give an example of the dataset that you have and what you want your output to be.  The way you are writing this doesn't make sense. ... View more

That's the only other way I would think to do it.  I'm curious to hear how the performance changed from sort / last. ... View more

See if this gives you what you want,  I added x to the group by line: proc sql; create table start as select *,sum(duration) as SumDuration from have group by crsp_fundno,x; data want; set start; prop = duration / SumDuration; run; ... View more

Looks like your math is off, not sure if this is what you want but try this: data have; infile cards dsd; input crsp_fundno begdt enddt x $ duration; cards; 139,19941230,19980629,,1277 139,19980630,19991230,,548 139,19991231,20000629,MLGE,181 139,20000630,20000831,LCGE,62 2761,19981231,19991230,,364 2761,19991231,20000629,LCGE,181 2761,20000630,20020629,LCCE,729 2761,20020630,20080330,LCGE,2100 2761,20080331,20130331,LCGE,1826 ; run; proc sql; create table start as select *,sum(duration) as SumDuration from have group by crsp_fundno; data want; set start; prop = duration / SumDuration; run; ... View more

run this code, you should get what you are looking for: data have; infile cards dsd; input crsp_fundno begdt enddt x $ duration; cards; 139,19941230,19980629,,1277 139,19980630,19991230,,548 139,19991231,20000629,MLGE,181 139,20000630,20000831,LCGE,62 2761,19981231,19991230,,364 2761,19991231,20000629,LCGE,181 2761,20000630,20020629,LCCE,729 2761,20020630,20080330,LCGE,2100 2761,20080331,20130331,LCGE,1826 ; run; proc freq data=have;table x / out=want;run; ... View more