Hi, I have a problem and I cannot figure out why this is happening.  I have some code values (this cannot be changed, eg cannot prefix it) and each of those values needs to has the corresponding data exported to an individual tab. I have the code to do this, it's not too tricky: data g;     input code $6. val;     datalines;  Q0603a 1  N0706a 1  V0706a 1  N0710a 1  N0710b 1  Q0710a 2  V0712a 3  N0712a 4  V0712b 1  Q0802a 3  V0804a 4  W0807  5  Q0811a 1  Q0811b 2  V0902a 1  N0903a 1  Q0905  1  N0911a 1  V1003a 1  W1003a 1  V0910a 1  Q1012  1  Q1101  1  V1101  4  Q1102  6  W1102  1  V1102  2  W1111  1  V1112  1  Q1202  2  N1202  3  T1301  1  N1301a 1  N1301b 1  Q1301  1  ;  run;  libname x pcfiles path = "C:\test.xls";  %macro exp(c);  data x.&c.; set g;     where code eq "&c.";  run;  %mend;  data _null_;     set g;     call execute(cats('%exp(', compress(code, '', 'kad'), ')') );  run;  libname x clear;  ^^ The above code has been simplified quite a lot, there's usually seven variables not just two.  New codes will come up over the course of the year, so this is why think need the call execute statement (I would usually use a proc summary statement to get the unique values I'm interested).  I've tried using proc export and even tagsets with no luck. When I run this, most of the tabs are labelled as expected, but there are some which have an underscore as the prefix. _W0807 _Q0905 _Q1012 _Q1101 _V1101 _Q1102 _W1102 _V1102 _W1111 _V1112 _Q1202 _N1202 _T1301 _Q1301 ^^ Actually, now that I've written this out, I think I see a pattern. These are the codes which are one character less. I cannot change these codes, they're fixed. I've just tried: %macro exp(c); %let c2 = %cmpres(&c.); data x.&c2.; set g;      where code eq "&c."; run; %mend; but that doesn't really help, the output is still the same. Right now, the solution is when the job has finished, someone manually opens the files and renames the tabs, ie removes the underscore. Does anyone have a solution for this (which doesn't involve VB scripting). We're running this on SAS Enterprise guide version: 5.1 (5.100.0.12269) Hot fix 7 (32-bit) Thanks. ... View more

Hi, We're running SAS 9.3 (TS1M2), Rev. 930_12w41, on Windows Server 2008 64 bit R2 SP1.  It's been running since October 2013. Audit Performance Management has been installed, and is running, however it doesn't show more than one weeks worth of data. How can I change this such that it shows more than just one weeks worth of data? When I look at the following directory on the compute server: F:\SAS\Config\Lev1\SASApp\WorkspaceServer\PerfLogs I can see logs going back more than just one week, yet when I look at WorkspaceTopUsers.html in APM only has the data for the past week, so I don't think it's an issue of the logs disappearing or not having them to begin with. I expect there's a number that I can update and as a result it will show more history? Thanks. ... View more

Gday, I have published an Information Map in SAS Web Report Studio. I want the users to be able to filter the report (using the Filter and Rank option, I don't believe there is another way), but I don't want them to be able to see the Edit tab. Ultimately, I don't want them to be able to edit the report that I have setup.  I don't mind if they save it elsewhere though (for now). I followed the instructions in this link: http://blog.saasinct.com/2011/05/12/web-report-studio-4-3-roles-and-hiding-the-edit-tab/ ^^ To remove the Edit tab, and that worked, but only when I had the Web Report Studio: Report Viewing role applied.  As a consequence the user was not able to use the Filter and Rank option. I changed the role of the group that a test user was in to Web Report Studio: Report Creation with the hope of allowing the user to filter the data.  This was successful, but the Edit tab returned. So, can I allow the user to use the Filter and Rank option but have the Edit tab hidden from them?  Or am I going to have to think about editing the roles such that they cannot save reports (I'm not even sure if this solution would work)? Thanks. ... View more

Gday, I have created two (with more to come) reports in Enterprise Guide.  They both contain a summary table and four graphs. These are to be published to SAS Web Report Studio. I have no problem doing that, however I'd like to be able to combine them such that they either show up in the Table of Contents or Section Data in SAS Web Report Studio. Can either of those options be done in Enterprise Guide or SAS Web Report Studio?  Perhaps I would have to have just one report with sections or contents defined?  I don't know how to do that in Enterprise Guide or otherwise. Thanks. ... View more