HI, First you should sort by  "Value".  Then in a data step do something like: retain cum_value; if first.id then cum_value=0; cum_value=cum_value+value; *not tested Allu ... View more

hi , libname engine will also helps you ...for importing .... but try this .....i have excel (Y3DTR.XLS) having two sheets named PURCHASE , SWITCHES %MACRO IMPR(IMP,OUT_DAT,EXL_SHT); PROC IMPORT DATAFILE="&IMP" DBMS=EXCEL OUT=&OUT_DAT REPLACE; /*for oupput dataset for each SHEET */ SHEET="&EXL_SHT";    /*for specifying sheets  */ MIXED=YES; RUN; %MEND IMPR; %IMPR(C:\Users\galax_allu\Desktop\Y3DTR.XLS,PURCHASE, PUR); %IMPR(C:\Users\galax_allu\Desktop\Y3DTR.XLS,SWITCHES, SWT); Regards, Allu ... View more

hi try this, .........sample  , ds4 are dataset nothing to do......other than these i guess code works.... data have; input product type balance dollar6.0 @19 from_dt mmddyy10.@31 to_dt mmddyy10.; format from_dt mmddyy10. to_dt mmddyy10.; datalines;  12345 4001 $25    01/25/2009  02/24/2009 12345 4001 $25.25 02/25/2009  03/24/2009 23456 4002 $26    01/26/2009  01/26/2009 23456 4002 $26.27 01/27/2009  01/29/2009 ; run; data sample ds3 (Drop=y KEEP=i) ds4; set have; format i mmddyy10.; do i = '25jan2009'd to '24mar2009'd; /*Here you can change latest or up to date)*/ y=weekday(i); if y=1 then output ds3; else output ds4; end; i+1; run; proc sql ; SELECT  distinct i,balance FROM HAVE a, ds3 b where a.from_dt = (select max(from_dt) from have a1 where a1.from_dt<=b.i) group by b.i; QUIT; Regards, Allu ... View more

hi , try this....your SUNDAY will be in ds3.....other than SUNDAYS in ds4 data have; input product type balance dollar6.0 @19 from_dt mmddyy10.@31 to_dt mmddyy10.; format from_dt mmddyy10. to_dt mmddyy10.; datalines;  12345 4001 $25    01/25/2009  02/24/2009 12345 4001 $25.25 02/25/2009  03/24/2009 ; run; data sample ds3 (Drop=y) ds4; set have; format i mmddyy10.; do i = '25jan2009'd to '24mar2009'd; /*Here you can change latest or up to date)*/ y=weekday(i); if y=1 then output ds3; else output ds4; end; i+1; run; Regards, Allu ... View more

hi , use weekday like ... if weekday(to_date) = 1 .... Regards, Allu ... View more

hi, Long hypen   or 'em dash '  are special chcarcters .. Go to MS-word and replace     -  with     —    /* i have pasted  long hypen from ms word*/ .....go with following code.. data want; set abc; if find(trim(string),'—') then _id=id;       /* i have pasted  long hypen from ms word*/ run; Regards, Allu Message was edited by: Y ALLU ... View more

thanks Amir....is there any chance that this is in new versions???? like 9.3 or 9.4??    ................contain()......... example data xxx; input aaa; 12 2 131 22; runl where num  = contain(1)......./*Returns the   12 , 131 ....*/ or where num = cotain(12).........../*Returns the 12 I am sorry for syntax errors...............but please check for functions ...??         ......................will Any body in community help me.................... ... View more

thanks... ... View more

hi, check this ,,,,,please let me know the 'P' status is correctly working or not.... data want; set have;   by  patient; lagged_actl=lag(actldose); lagged_doseadj=lag(lagged_actl); if first.patient then do;   lagged_actl=.;   lagged_doseadj='';   end; if lagged_actl>actldose then doseadj='R'; else if lagged_actl=actldose and lagged_doseadj>=actldose then doseadj='P'; else if lagged_actl=actldose or lagged_actl=. then doseadj='N'; run; Regards Allu ... View more