Can you share your SP SAS code. I presume you are not using _webout in your SP? SP can be deployed with prompts in SAS VA ... View more

Hey Bruno, thanks for your input. this is what i use to convert sec into min and min into hr.  hourMinMsr= If Sum [_ByGroup_] ('timeSec'n) <=3600 return   Floor(( Sum [_ByGroup_] ('timeSec'n) / 60 )) + ( ( Sum [_ByGroup_] ('timeSec'n) Mod 60 ) / 100 ) else    (Floor(( Sum [_ByGroup_] ('timeSec'n) / 60 )) + ( ( Sum [_ByGroup_] ('timeSec'n) Mod 60 ) / 100 ))/60   The above scenario would display both sec in hours and min but user would have difficulty interpreting the data and differentiating between min and hours. To represent the data accurately, i think we can only use sec in min or sec in hour to accurately display the results. To combine sec in both min or hr will lead to more confusion. Let me know if you think otherwise or better solution. thanks.    TimeCat    timesecNum  MinMsr   hourMsr   hourMinMsr 0:06:04     364                6.04        0.10         6.04 1.11.24     4284              71.24      1.19         1.19   ... View more

Thanks Bruno,  I see it produce results in mm:ss, is there way to include hh:mm:ss as well, i have seconds in hours as well. like timesec = 4284 and i want to convert into 1:11:24 and summarize in bottom   Thanks for your input ... View more

Interesting article. I'm doing something similar like creating custom calendars using stored process webout. Once its used as a prompt in VA can i set interactions with custom calendar and list / crosstab ... View more