Wonderful Blog... Nicely explained the entire process .. animated graphs with the images of countries is unique, Good research, during this covid-19 situation these types of visualisation are very help full for the government.. really nice work done.. keep it up.. ... View more

Hello  Irozzelle,   For the said example in your reply you can try using Group Role for Year or also can try with Lattice Rows or Columns in the graph so you will get each year specified values in your graph report only you will not need to create info window or report link.....   Assign the roles : (Y) Sales -"Measure value" (X) State - "Category" Group or Lattice - Year .   Please let me know if you need more info for the same...     Regards; Jim ... View more

Hi!!!     You will have to create a Prompt and configure it in to your code property and also have to call that macros in your sas code with & in where clause or any other where you required to be produce on coditional basis.   Exp:   create prompt : Prompt Name :Gender, Its value will be "Male" , "Female"   Now I will write code for stored process and use this prompt in the code to get the resolt on coditional basis.   Proc print data=ABC; where gender="&gender"; run;   !!!Instad of proc print you can use proc report in your case !!!     Now on this store process proerty you will have to add this prompt(Gender) so as an when you will call this stored process it will prompt you for the Gender value and once you will enter it will process accordingly.     Let me know if you requred more information for the same.     Regards; Jim ... View more

If you don't mind, can you please elaborate your question with sample example, so can understand better way to provide you the perfect solution..   Regards; Jim ... View more

You can try with multipule "and" Function in (SASVA)order to aggregate more then one condition.   Pls find the below attached image let me know if you need more clearity on it....     Thanks ... View more

Thanks For the reply: Actually the Periodic Operators works for month, Qtr, Year, and so on I can not do the aggregation on the basis of Weekly as the week will be in number (Measure) formate and in Periodic it will required Date format.... ... View more

Okay!! Thanks for the Solution... I was wondering if this can be done in SASVA on the fly calculation only because there are some other parameters also need to include further and accordingly Avg.P Price will changes so on, With coding it will be static solution... ... View more

Hello Sanjeev,   Just to confirm if you have one variable called language with the value of Two diff language in to your entaire dataset then please try with the global filter with drop down list which has selection of language so that the below entier report will be filterd with selected language data values..   Pls tell me if no need more clearity on it..........     Jim... ... View more

Hello,   Try using Info Window for that section that will solved your issue. Bcos I feel some permission issue for that link sections. so in that case info window will work users must have rights for meta data views and report view rights.   Jim... ... View more