I currently do most of my work in Enterprise Guide and am seeing SAS Studio in my future as we transition to Viya. I have a couple of projects set up with sequential and parallel processing. Do process flows in SAS Studio work pretty much the same way they do in Enterprise Guide? ... View more

This is the template I am using.   proc template; define statgraph BarChart_PCT_by_Group / store=sasshare.templat; dynamic dvTitle1Align dvTitle1Text dvTitle1Color dvFootnote1Text dvFootnote1Color dvFootnote2Text dvFootnote2Color dvX1LabelText dvY1LabelText dvMeasure1Format dvGraphfilltype dvGraphfillcolor dvGraphdataskin dvViewMax ; begingraph / collation=binary; EntryTitle halign=dvTitle1Align dvTitle1Text / textattrs = (color = dvTitle1Color size=14pt) ; Entryfootnote halign=center dvFootnote1Text / textattrs = (color=dvFootnote1Color weight=bold size=12pt); Entryfootnote halign=center dvFootnote2Text / textattrs = (color=dvFootnote2Color weight=bold size=10pt); legendItem type=marker name="byGroupMarker" / markerattrs=(symbol=trianglefilled size=9 color=ggr) label="State Average" labelattrs=(color=ggr); layout overlay / xaxisopts=( tickstyle=inside tickvaluevalign=top display=(TICKVALUES) label=dvX1LabelText griddisplay=off tickvalueattrs=(weight=normal size=10pt) ) yaxisopts=( display=(LABEL) label=dvY1LabelText linearopts=(tickvalueformat=dvMeasure1Format viewmax=dvViewMax) labelattrs = (family="" color=black weight=bold style=normal size=12pt) ); barchart X=category Y=Measure1Value / stat=mean barlabel=true barlabelattrs=(family="" color=black weight=normal style=normal size=12pt ) barlabelformat=dvMeasure1format filltype=dvGraphfilltype fillattrs=(color=dvGraphfillcolor) dataskin=dvGraphdataskin; scatterplot x=category y=Reference1Value / markerattrs=(symbol=trianglefilled size=9 color=ggr) datatransparency=.2; layout gridded / valign=top ; discretelegend "byGroupMarker" / halign=left across=1 border=false backgroundcolor=whitesmoke valueattrs=(size=9) outerpad=0 ; endlayout; endlayout; endgraph; end; run; ... View more

If you are using the same item as a filter and a category for a bar chart, that behavior would be expected. ... View more

I think that the only way to do this is to write DATA step code to post-process the file to retrieve the information that you need.   Vince DelGobbo SAS R&D ... View more

I'm currently struggling working with the Theme Designer in 7.4. I've found that to change the background behind the Graphs object, I need to use the Application Frame component. The Color seems to affect the Report Designer view, while the Gradient colors need to be changed in order for it to affect the Report Viewer. ... View more

Hello @Raven01,   several things I would like to mention here.   1- For fixing the problem, I think we are overestimating and having as a given here that the LASR admin account actually has the permissions. I would start from this point.   Just to be clear, the successful asignment of the libraries, means that you have RM (Read Metadata) on those libraries, but perhaps you do not have Read, Write Metadata or Write on those libraries, of the SAS folders where the tables are going to be registered.   2- In your case, I would use AutoLoad or ReloadOnStart. Have you checked those functionalities on the VA Administration guide?  https://communities.sas.com/t5/SAS-Visual-Analytics/Auto-start-up-of-LASR-server-after-system-reboot/td-p/146754 http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n1s2hnpd892n7fn1dp18x2xgffel.htm   (Specially, since you use Public LASR Library, it would make sense to me if you use AutoLoad)     This approach would help you to not re-invent the wheel. If there is something maintained by SAS, why should you? I mean, custom code is always an option and that is why SAS leaves it open, but AutoLoad works really well.   I hope it helps.   Kind regards, Juan ... View more

We have had a similar request, and subsequently concluded that this type of functionality is not currently available in VA (we are on 7.4). If I understand correctly, you essentially need to store an aggregate measure to be referenced at a different level in a hierarchy. Aggregate measures cannot be used as parameters in this way. All behind-the-scenes data manipulations operate on the row level data. Aggregations are controlled by report object selections and filters, and they cannot be stored or processed dynamically outside the object and then referenced within the object. A stored process could accomplish this, but stored process objects and other report objects cannot share interactions. The solution we arrived at was storing additional rows in our dataset that include the aggregate measures, in your example this would be "no. of months" and "no. of days." Calculated items could then be created to display in the line chart, and possibly work with the date hierarchy.   It is a convoluted approach, but we haven't arrived at a better solution. I'll be curious to learn if you find something better. ... View more

Any updates on this issue?   I am experiencing the same problem in VA 7.4. I've cleared browser cache and cleared the VA cache through the Administrator options. This allows me to see the results of the Stored Process after Report Viewer Refresh, but they do not appear on initial load. I've also noticed slighlty different behaviors between different browswers. Could the problem be caused by both browser and operating system caches? ... View more

I think an External Link and a bit of JavaScript in a Stored Process may be the simplest solution for this. I'm not an expert in working with Stored Processes or JavaScript, but I was recently able to put something together that allows me to open a new browser tab to a url determined by an attribute of a GeoMap Object.    I used the External Link to pass the selected attribute as a parameter to a stored process that contains script that opens the new browser tab. There is probably a more efficient way of doing this, but I used the location.replace function because the process was opening two new tabs when called. I believe one was the location of the Process itself and the second was the url that I wanted.    For now, I just have two options hard-coded in an if-then statement in the script. Eventually I want to have this set up to reference a lookup table that inlude many more url's.    Hope this helps.     %global district; data _null_; file _webout; if "&district" in ('COLUMBIA 93 (010093)') then put " <script> function myFunction() { location.replace('https://www.cpsk12.org/'); } </script> <body onload='myFunction()'> </body> "; else if "&district" in ('JEFFERSON CITY (026006)') then put " <script> function myFunction() { location.replace('https://www.jcschools.us/'); } </script> <body onload='myFunction()'> </body> "; else put " <script> function myFunction() { location.replace('https://dese.mo.gov/'); } </script> <body onload='myFunction()'> </body> "; run; ... View more