Gday RMP, I've tried a couple of places.  Here's the one I was trying to describe in my original post: In SAS DI Studio * navigate to the Cube * right click on cube * go to Maintain * click on Calculated Members... * click on Add on the window that pops up * select Custom calculations and click on Next The area which I was attempting to put a variety of different pieces of code was in the Formula box. Here's a couple of lines of code I tried (after clearing the Format field): * aggregate(qtd(Sum(YTD(),[MEASURES].[]).CurrentMember))  (with parent dimension left as MEASURES) * aggregate(qtd(Sum(YTD(),[AccPeriod].[All AccPeriod]).CurrentMember)) (with parent dimension left as MEASURES) * aggregate(qtd(Sum(YTD(),[MEASURES].[]).CurrentMember)) (with parent dimension left as [AccPeriod].[All AccPeriod]) * aggregate(qtd(Sum(YTD(),[AccPeriod].[All AccPeriod]).CurrentMember)) (with parent dimension left as [AccPeriod].[All AccPeriod]) * Aggregate([Time].[Months].CurrentMember.lag(1):[Time].[Months].CurrentMember.lag(12 ) ,[Measures].[Actual])  (with parent dimension left as MEASURES) * Aggregate([Time].[Months].CurrentMember.lag(1):[Time].[Months].CurrentMember.lag(12 ) ,[Measures].[Actual]) (with parent dimension left as  [AccPeriod].[All AccPeriod]) * Tail([Time].[YM].[MONTH].AllMembers ,13) (with parent dimension left as MEASURES) * Tail([Time].[YM].[MONTH].AllMembers ,13) (with parent dimension left as [AccPeriod].[All AccPeriod]) I'm sure I've tried more weird and wonderful formulas that I no longer remember, and none of them worked.  AccPeriod is defined as a Time dimension. Thanks. ... View more

Hi, The reason why i had asked was because i too was facing the same type of problem. The only differece being that i was defining my calclated member in the cube. So i too had ended up using infomap for my calculations. ... ... View more

A late comment: In general, when you fetch a lot of data from a big DWH, you want an ABEND if ANYTHING is incorrect. Then you can sit down and consider the structure of your tables, and what problem you really want to solve.    There are of course several technical ways of avoiding the the error message, but they do not really help you to get accurate and realiable SAS-programs. Please note that the use of LENGTH mergevar $ 32767; will increase the amount of computer resorces used. Regards  Anders ... View more

Hi Barry, Dyamic prompts attached to a filter was as close as I could get to finding a solution too.  I don't want this, as the majority of times, the user will not know what filters they want applied until they've seen the data.  If the solution to what I want require Information Maps I don't mind using them. It sounds as though the feature I'm afer doesn't exist. ... View more

SAS has a "feature" that it will use the value of an environment variable as the path for a libref without the user needing to code a LIBNAME statement. OS is a standard Windows_NT environment variable so you will see the same result for LIBNAME OS LIST statement on any version of SAS running on Windows NT. This feature I assume dates back to SAS's roots in the IBM mainframe environment where a DD line in JCL was required to make the assignment between a DDNAME and a physical file location. The real question is why would DI studio be using environment variables for DI defined libraries rather than just executing a LIBNAME statement or function call? ... View more

Where on the server do the files need to belong for it to be classified as on the server ? The Excel file does reside on the server's S: drive. This is not a mapped network drive. But if there is a better location for me to test this, I can try, I don't think I can write to the C: drive though. ... View more

Hi John By default Enterprise Guide 4.2 expects you to connect to a metadata server.  This holds all the details of your libraries etc. The Metadata Server talks to a workspace server that runs the acutall SAS code. The errors you are seeing are saying that EG cannot connect to a SAS server, which is why it isnt working because as you say in your post you have no sas server and are trying to use base SAS on your PC. In the EG connection profile make sure you have <do not use a profile> selected. And of course make sure you have SAS 9.2 base SAS install, EG 4.2 does not work with SAS 9.1 ... View more

You could just turn off all the notes with the 'nonotes' option... ... View more

call symput has only three type arguments. variable name , text and text expression. So you can try this: 1)call symput('yr', '2011' ); 2) year=year(today() ); call symput('yr', year ); Ksharp ... View more

Hi Nick R, Thanks for your suggestion. That works for me, now to integrate it into my job. ... View more

hi ... another non-GMAP-related suggestion ... you might find it easier to use one of the CAT functions when constructing links, this ... href_string = 'http://maps.google.com/?ie=UTF8&ll=' || trim(left(lat)) || ',' || trim(left(long)) || '&spn=0.074899,0.102654&t=h&z=' || trim(left(zoom)) || '&om=1'; can be replaced by this (I used multiple lines to make it look like your statement) ... href_string = cats( 'http://maps.google.com/?ie=UTF8&ll=', lat, ',', long, '&spn=0.074899,0.102654&t=h&z=', zoom, '&om=1' ); the CATS function implies TRIM+LEFT when you use a variable name ... View more

Looking at the SAS-generated code, it appears that SAS 9.2 does include the PROC PRINT option "LABEL" which causes the behavior you are seeing. I don't know of a way to change this code (maybe there is a template file somewhere - contact tech support if it is important enough?), however you can change the behavior with the SAS statement below (it converts the data-string to a comment): MACRO label /*LABEL*/ % Scott Barry SBBWorks, Inc. ... View more