You can't! //Fredrik ... View more

HI! Try this: - Convert the character date to sas date using your input function. Lets say you call it date_num - create a new date variabel which is 2 months greater than the new date variable using intnx('month',date_num,2). Lets say you call it date_num_plus2 - in VA create a prompt on date_num_plus2. Add a date parameter and assign it to the prompt. - Create a data filter that selects month <= the parameter. - In your visualizations use rank and pick the highest 6 on date_num.   Some work, but I think it would work 🙂 //Fredrik ... View more

I do like this:   LIBNAME aaa SASIOLA TAG=aaa PORT=000 HOST="aaa" SIGNER="http://aaa/SASLASRAuthorization" ; /* Remove existing table from LASR if loaded already */ %macro deletedsifexists(lib,name); %if %sysfunc(exist(&lib..&name.)) %then %do; proc datasets library=&lib. nolist; delete &name.; quit; %end; %mend deletedsifexists; %deletedsifexists(MEBELA, im_medbedom); proc copy in=fromLIB OUT=aaa; select myTable; quit; %macro registertable( REPOSITORY=Foundation, REPOSID=, LIBRARY=, TABLE=, FOLDER=, TABLEID=, PREFIX= ); /* Mask special characters */ %let REPOSITORY=%superq(REPOSITORY); %let LIBRARY =%superq(LIBRARY); %let FOLDER =%superq(FOLDER); %let TABLE =%superq(TABLE); %let REPOSARG=%str(REPNAME="&REPOSITORY."); %if ("&REPOSID." ne "") %THEN %LET REPOSARG=%str(REPID="&REPOSID."); %if ("&TABLEID." ne "") %THEN %LET SELECTOBJ=%str(&TABLEID.); %else %LET SELECTOBJ=&TABLE.; %if ("&FOLDER." ne "") %THEN %PUT INFO: Registering &FOLDER./&SELECTOBJ. to &LIBRARY. library.; %else %PUT INFO: Registering &SELECTOBJ. to &LIBRARY. library.; proc metalib; omr ( library="&LIBRARY." %str(&REPOSARG.) ); %if ("&TABLEID." eq "") %THEN %DO; %if ("&FOLDER." ne "") %THEN %DO; folder="&FOLDER."; %end; %end; %if ("&PREFIX." ne "") %THEN %DO; prefix="&PREFIX."; %end; select ("&SELECTOBJ."); run; quit; %mend; /* Synchronize table registration */ %registerTable( LIBRARY=%nrstr(/Path/to/LASRLib) , REPOSITORY=%nrstr(Foundation) , TABLE=%nrstr(myTable) , FOLDER=%nrstr(/Path/to/metadataFolder) ); Works great and the RLS is still there 🙂 If you stlll have problems with RLS, you can add them using scripts after your reload: http://documentation.sas.com/?docsetId=bisecag&docsetTarget=n1sjpmdvbsgp7bn1vpx0hsvsizcz.htm&docsetVersion=9.4&locale=sv   //Fredrik   ... View more

Make sure you have two category variables one for quarter and one for month. Then create a parameter that will contain the value from the drop-down (example: The drop-down contains two values Quarter or Month)   Create a new calculated item that check the value of the parameter and then select which category variabel to use, example och calculation:   IF [parameter] = 'Quarter' then quarter ELSE month   Use this new item as category in your graph.   In your example you have two different graphs and that is not possible since you can not change visualization upon a value in a list box.   Am I somewhat on it? //Fredrik ... View more

Hard to tell from that screen but it's definitely 6.x or 7.x. Looks like the windowing system freaked out, have happened to me as well 🙂 //Fredrik ... View more

A cross-table with column subtotals might do it? //Fredrik ... View more

I have had a similiar problem and solved it by building my own graph in the graph builder. There I had the possibility to choose my own color for the labels 🙂 //Fredrik ... View more

As @Sam_SAS says assign it as category role of the button bar, I translated my swedish to english, my bad 🙂 //Fredrik ... View more

Oki! Create a new calculated item, use your date variabel and "treatAs" number. Set aggregation to max. Add a button bar and set your date variabel as category, then rank and pick the highest 1 from your calculated variable. This will make your button bar show only the highest date in your data. //Fredrik ... View more

What do you want to do more specific? The easiest way is to add a list table and then sort in descending date order and look at the first row 😉 //Fredrik ... View more

DO you have two different meassures one for current and one for YTD? That should be the first step, add them in a table and check that they work 🙂   If so I think you could do the following: - Create a new parameter and assign it to the button bar. - Create a new calculated meassure that select either current or YTD depending on the parameter. (IF [parm] = 'Current' then current_var else YTD_var) - Use that new meassure in your report.   Might help or am I out in the blue 🙂 //Fredrik ... View more

There might be some help following these links: http://support.sas.com/documentation/cdl/en/bimtag/65708/HTML/default/viewer.htm#p0eutmr76b63uwn17zvy36mw6yle.htm http://documentation.sas.com/?docsetId=bisecag&docsetTarget=p03h42tf0s7ogyn1pqtsesbu3xuk.htm&docsetVersion=9.4&locale=sv Otherwise add user credentials in your link (&user=&pass=) //Fredrik ... View more

Maybe one of these? Firewall is not open for that specific user to access VA? User has no access to DNS-server for resolving domain? //Fredrik ... View more

Hi! What you can do is to add a text-input box and assign a parameter to that box. Then add a filter to your drop down that uses that parameter to filter out values.   In the filter you can use "upcase(var) contains upcase(parm)" to make it possible to search for parts of the value regardless of case.   Hope this helps 🙂 //Fredrik ... View more