About Oscarboots

Oscarboots · ‎05-04-2016

Thanks TriciaAanderud, I was just waiting for SAS Support to come back to me. It seems the problem was a change I made when going to 'Tools' >> 'Load Text Analytics Stop List'. I had changed the directory path when it should have stayed as shown in the SAS®Visual Analytics: Fast TrackCourse Notes. I hope this might help someone one day who has accidenatlly or deliberately changed it. Cheers

Oscarboots · ‎04-14-2016

Hi Forum, I've seen docs on how to use the Word Cloud for version 7.1 & I have loaded the ENGSTOP file to the server but the checkbox for 'Use Stop List' is Greyed Out. Is there some rule(s) about when it's available to use? Thanks

Oscarboots · ‎02-24-2016

Hi Again, I haven't been able to discover why the data changed between EG & VA but I did notice there were some values in my data that were LC. I can't explain the changes when I uploaded to VA but as a workaround, I used the 'UPCASE' Function in EG for the field & the fileds are now as I need them. Thanks.

Oscarboots · ‎02-17-2016

Hi Forum, I have a project created in SAS EG 7.1 running on Windows 7 & I have the States in Upper case (UC). When I upload the table Lasr Public folder, I find the States values have changed to a variety of Upper & lower Case combinations. Does anyone know what can cause this? Thanks

Oscarboots · ‎01-21-2016

Thanks for confirming Sam, I've created a way to do it by reformatting my data to contain Weekly data Sales Count Fields for the Current Week, Last Week, Last Month & Last Year. This allowed me to create an Aggregated Measure to calc my Week on Week etc ... I would find a weekly option useful as a future suggestion to develop. Btw, I saw the code behind the Aggregated Measure options & wondered if it's possible to alter the code to suit Weekly in the meantime? ParallelPeriod(_Sum_, 'ProductTotal'n, 'WeekStarting'n, _Inferred_, _Inferred_, 0, _Full_, {Date}) - ParallelPeriod(_Sum_, 'ProductTotal'n, 'WeekStarting'n, _Inferred_, _Inferred_, -1, _Full_, {Date}) I've been trying to find more info about the 'Parallel Period', 'Inferred' & 'Full' terms in the code but can't find anything that helps me understand it & alter it to enable the Weekly option, any suggests?? Cheers Peter , (Oscar(Boots) is my Dogs nickname) : ).

Oscarboots · ‎01-20-2016

After further playing around, I think I've discovered the answer. I could be wrong but I don't think VA has the Aggregated measures set up for Weekly periods, just Month/Quarter/Yearly? I'm using 7.1 so maybe this has changed but I would be interested to know how anyone has created a Week on Week % Change. Once I converted my Weekly formatted date to Month & Yearly, I used those fields to use in the Aggregated Measures & all is well !! Can't say I saw any limitations in my search for the answer?? Anyway, in case someone has the same issue, there it is (or is for me anyhow ...) Cheers : )

Oscarboots · ‎01-20-2016

Hi Again, I've found that by playing around with the aggregation of the measure that I can get results for 'Difference from Previous period'. I've changed the measure to Count instead of Sum which shows a result but I do need to Sum my measure for the report. I find it strange that I can't get this to work as I thoght it would be fairly straightforward. Has anyone had the same issue?? Thanks

Oscarboots · ‎01-18-2016

Hi Forum, I'm using SAS VA 7.1 on Windows & 32 bit & have created a table of data that has weekly counts by State. So I've added a Crosstab Object to the Report builder & added Weekending (Date) to 'Columns', State to 'Rows' ($) & Counts (Float) as a Measure. I use the 'Create - Difference from previous Period' & add that new calc to the table. I'm just getting blanks between the Count rows & can't work out why. Can anyone advise what's possibly wrong here? Thanks

Oscarboots · ‎12-10-2015

Hi bart_steps & Hussain, Apologies bart_steps for not answering sooner, I wasn't aware of the post. As this was a while ago, I can't remember the fix but I did get it from SAS tech Support so I'd give them a try. In the end I changed to .csv format to upload the files. Cheers

Oscarboots · ‎10-18-2015

Thanks SASKiwi, I have the Admin Access with SAS EG, can you explain the steps to take? Do you mean create a new program in SAS EG that executes existing SAS Graphs on a schedule? I'm interested in any ideas you've used to get this done. Thanks

Oscarboots · ‎10-17-2015

Thanks jakarman, I'm looking for a workaround that doesn't use Task Schedluer. I've tried creating a vbs script through the Scheduler & have a Batch file execute it. Has anyone created a workaround using whatever to run a SAS Graph at a scheduled time? Thanks

Oscarboots · ‎10-17-2015

Hi Forum, I need to schedule some EG Graphs that are saved to a LAN Network drive & Windows Scheduler is unreliable for doing this. I can get the SAS EG Scheduler to create the vbs file which is fine but how do I automate that vbs to run at a scheduled time? Previously we had used a Batch file (prompted by the Windows Task Scheduler) & then executed the .vbs file that executed the SAS Graph. Since a move to a new Server this no longer works. I think the Windows Scheduler won't reliably run files that are not sitting on the PCs 'C' Drive. I'm using SAS EG 7.1 & also have SAS Visual Analytics 7.1 & need to have these SAS EG graphs run automatically. I'm using Windows 7. Thanks

Oscarboots · ‎08-26-2015

Hi Forum, I've created 2 bar charts with over 1 years data each in SAS VA 7.1 & put them into their own containers side by side as I want compare the same data in each but for different months. First up, I'm setting up both charts together for the one month of August 2014 and the colours in the bar chart match exactly for the sales $ ranges I have in there. When I go to change the month of the second Chart to another month, the colours of the $ ranges change? I'm using a Slider to select one month of dates with the Date Picker to do this & can't seem to get the $sales ranges to stay the same. Example, I have $10-$20 sales in my Stacked Column for August 2014 which is coloured Blue. As I move across to the next chart on the right, I'm expecting the Blue parts of the Bars in the Chart to be $10-$20 but they are not. I've tried making a duplicate of chart & using that but the same problem occurs. Does anyone have a method to overcome this?\ Thanks

Oscarboots · ‎08-18-2015

Hi Explore_SAS, My needs were only for a table of data so I haven't tested that. I would try creating this in SAS EG with Prompts & then create an SP from that Project. Hope this helps

Oscarboots · ‎08-15-2015

I've found the answer thanks to SAS Support & various you tube videos. The steps are; Open an existing Project in EG (7.1) Go to File >> New >> Stored process (SP) I name the SP & check the directory I select Replace with code from 'This Project' I highlight one of the Graphs & click Next so that the script drops automatically into the script area in the correct place Once the SAS script drops in, remove the line "create table ...." as this why no results are shown - the script wants to create a table not a report. I have both 'Streaming' & 'Package' checked before running Run the Process to see the table results as a SAS Report. Now go to SAS VA & create a Report using a 'Stored Process' Object from the Objects selection Once the report is completed & saved, create a Report schedule by going to File >>> Distribute Reports while in the Create Reports area of SAS VA I haven't been able to find a similar instruction to this anywhere so I hope this helps others in the same situation.

Online Status	Offline
Date Last Visited	‎05-31-2016 02:14 AM

Re: SAS VA Version 7.1 Visualisation Stop List Greyed Out

SAS VA Version 7.1 Visualisation Stop List Greyed Out

Re: Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Re: Aggregated measures not showing results?

Re: Aggregated measures not showing results?

Re: Aggregated measures not showing results?

Aggregated measures not showing results?

Re: Problem Uploading .xlsx file to VA

Re: Automating SAS Enterprise Gude Graphs with Batch & vbs only, no Wi...

Re: SAS VA Version 7.1 Visualisation Stop List Greyed Out

Re: SAS VA Version 7.1 Visualisation Stop List Greyed Out

Re: Aggregated measures not showing results?

Re: Sankey Diagrams in SAS VA

Re: Select Case expression in SAS EG 5.1 Expression builder

Re: Sankey Diagrams in SAS VA

Re: Stored Procedure to trigger a SAS EG Graph

Re: Multiple Charts side by side with different Date Ranges

Re: SAS VA Version 7.1 Visualisation Stop List Greyed Out

SAS VA Version 7.1 Visualisation Stop List Greyed Out

Re: Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Re: Aggregated measures not showing results?

Re: Aggregated measures not showing results?

Re: Aggregated measures not showing results?

Aggregated measures not showing results?

Re: Problem Uploading .xlsx file to VA

Re: Automating SAS Enterprise Gude Graphs with Batch & vbs only, no Wi...

Re: Automating SAS Enterprise Gude Graphs with Batch & vbs only, no Wi...

Automating SAS Enterprise Gude Graphs with Batch & vbs only, no Window...

SAS VA Charts comparison change colour of bar values

Re: Stored Procedure to trigger a SAS EG Graph

Re: Stored Procedure to trigger a SAS EG Graph