Hi all, Is there away to adjust the length of the bottom control when placing the bottom control  in the page control area? In this example i want to adjust the  length of the bottom control  when using date variable Best Regards   ... View more

Hi Experts, I tried to run this code and got out of memory error: connet time out exception   proc sql; create table bda.temp as select a.*, (today()-input( substr( date,1,10),yymmdd10.))/365 as age from bda.aaa as a ; quit;   now i  want to try do it with pass-through to hadoop and create the age calculation by using hive functions can someone share with me some code? i am pretty new to this kind of feature   Best Regards ... View more

Hi ,  When we are using Count Distinct for a measure , and using the measure in A cross table, the sum for the count distinct is for all table and not the different categories . For example, a table with Males and  Females The Total count distinct will be for all ( Male + Female ) and will be total of 19 . But in the table (F, M) you will have more cases. lets say 9 females and 11 males.( One Female is also a Male )  . I want the ability to show Total of 20 using only the count distinct measure   gender     countdistinct   count   M                  10                10 F                   9                 10   TOTAL         19                20     Is it possible?   ... View more