dmcloughlin Tracker

Re: %logParse usage

dmcloughlin — Tue, 10 Jan 2017 16:23:29 GMT

Agreed on the name!

I actually managed to solve this myself earlier but hadnt got around to updating this. I had been trying the full path approach you mentioned below, but discovered that i didnt need the quotes - when i removed these, the code worked fine.

- use the full path

%logparse(\\serverxx\esa.log, myperfdata);

%logParse usage

dmcloughlin — Tue, 10 Jan 2017 11:02:38 GMT

I am trying to use the logParse Macro, but having some issues being able to reference the logfile which i am redirecting to the server - I have searched the community responses to this, but i cant find anything that solves my issue.

The code I am submitting :


options fullstimer;

%let files \\serverxx ;
%let logParse = \logparse.sas;
%let passInfo = \passinfo.sas;

%include "&files.&passInfo";
%passInfo;
 

filename  logfile "\\serverxx\esa.log" ;

proc printto log= logfile  ; 
run; 

 
data esa;
	set benefit.esa_history (where=(date_data_Extract > "01dec2016"d));
run;

%include "&files.&logParse";
%logparse(logfile , myperfdata);

When i submit this and call the %logparse file - i dont seem to be able to be passing the correct reference to the log - i am using the filename in this instance, but have also tried the full path and other options to no avail.

On submitting the code above - i recieve the following message in the log which appears to suggest SAS is looking in the default SASAPP folder?


NOTE: Variable abovemem is uninitialized.
ERROR: Physical file does not exist, C:\SAS\Config\Lev1\SASApp\logfile.

Appreciate any thoughts / advice on how to solve this.

Thanks.

Visual Statistics - options in decision tree

dmcloughlin — Thu, 30 Apr 2015 21:37:35 GMT

Hi,

I was building a decision tree in VS today, and was pulling my hair out trying to get a way of being able to zoom in on the decision tree - having extended my desktop onto my 2nd screen at home, I can see the issue: The show diagnostic plots and show tree overview (which appears to be the only way i can access the ability to zoom into the tree?) - are excluded from view on the smaller screen - there is no scroll bar option to reveal them - does anyone know of another way of accessing these check boxes other than through the properties pane?

Not a great screenshot - but you can see that in the smaller screen - these two options are missing.

Visual Statistics - Generating Cluster ID - viewing in VA

dmcloughlin — Mon, 20 Apr 2015 21:41:02 GMT

Hi,

I am generating a cluster ID variable using the k-means clustering capability within VS - I would then like to view this field, but need to go back to VA to do this. The only option I can see to do this is by going to file, extended features and then going to view data in VA.

When i do this, I lose the Cluster ID created in VS, so the only way I can get the value at present is by exporting the model code and applying to the same underpinning SAS dataset and doing some analysis in EG. Is this likely to be a permissions issue, or is it not possible to bring the data back into VA from VS? I am guessing I dont have write access within VS, but not sure how to check.... no log etc.

PS I am working on a demo environment with no access to MC to check user permissions.

Re: New SAS Visual Analytics 7.1 certification - do you plan to do it?

dmcloughlin — Thu, 12 Mar 2015 20:50:05 GMT

I have just been accepted to do this - not sure about exam preparation - any tips!?

Are there any example questions available?

Re: Period calculations in VA using Financial Year

dmcloughlin — Mon, 10 Mar 2014 12:41:25 GMT

Thanks for this Peter - I had considered this - and this is useful thanks!

I think that its safe enough to say that it is not possible to use the period calculations with a financial year at present - perhaps this is something that SAS can look at developing for future iterations.

Re: Period calculations in VA using Financial Year

dmcloughlin — Thu, 06 Mar 2014 21:51:20 GMT

Yes I have seen the documentation, and used the functionality with standard years and months - but the issue is that I need to define the financial year as a date field - I was wondering if there is a workaround that anyone has used or come across.

Period calculations in VA using Financial Year

dmcloughlin — Thu, 06 Mar 2014 14:53:20 GMT

I am currently on client site in UK where the company operates in financial years which are between April and March - ie we are currently in FY13/14. I am currently summarising datasets in EG using a character field which I have created in the format using intnx (FY2013_14) - I am trying to introduce VA, but would require the ability to use the period calculations on financial years. It appears that the period calculations require date format - does anyone have any suggestions on how to achieve this? Someone has suggested a custom format - but not sure how that would work.

eg - I am looking to do something like this, where "%Movement" uses the period calculations:

Year	Expenditure	% Movement
FY2008_09	£100,000
FY2009_10	£110,000	10.0%
FY2010_11	£120,000	9.1%

Thanks,

Damian

Re: Using Period to Date Calculations

dmcloughlin — Wed, 05 Mar 2014 21:32:25 GMT

HI - was wondering if anyone has a way of using the period calculations with a financial year field - or can think of a workaround? on site at an org who use financal years - so need to be able to calculate differences across these as opposed to years.