Search results for query: *

I'm drawing a blank here. The cube processes w/o error and I have several other dynamic sets in the cube, but this one set won't show up and I can't figure out why. I confirmed the MDX does return a set in SSMS.... Any ideas? CREATE DYNAMIC SET CURRENTCUBE.[Last 7 Days] AS...

I took your suggestion and swapped out LastChild with ClosingPeriod... I get the same column results but the [B/W] column is still spitting out -1.#IND. Any idea why that is?

...AS -SNIP- SELECT { {[Risk CSU Rate],[Manual CSU Rate],[Low Risk CSU Rate] ,[High Risk CSU Rate],[Current CSU Rate],[Delinquent CSU Rate]} * {[YearMonth].[Year Month].LastChild ,[YearMonth].[Year Month].LastChild.Lag(12) ,[YearMonth].[Year Month].[B/W]} } ON COLUMNS, {...

Thanks Paul! Didn't see the AS forums, just what I was looking for. Notorious P.I.G.

Yes sorry forgot that detail. Notorious P.I.G.

I have a query that works when I feed it a specific date, but can't seem to get it to work using variable select (LastChild, etc). Trying to create two subsets one for Current YTD and one for Last YTD (ie 1-2008 to 8-2008, and 1-2007 to 8-2007, based on the last date currently in dataset) Any...

Doh! That was a pretty stupid mistake.. Guess that's what I get for slacking for so many years... Thanks for the help works perfectly now! Notorious P.I.G.

Okay I was able to hack some more into this. the file is being created, all I need to know is how to point to the second row of each file, and how to get the regex working... open(OUTP, "> $f"); print OUTP $outfile; #data foreach ( sort @totalfiles ) { next if ($_ =~ m/^\./); #REGEX...

Been a while since I worked with Perl. Can someone help me out with this. I'm reading a directory of comma delimited files. I need to read in all files, add a few variables based on each file's name, and write out another file containing all files' info. Here's what I have so far, but can't...

I think your input datastep should look something like this: data test; infile indat end=eof ; input @001 ISSDT S370FPD4. @005...

You were on the right track Chris. Here is what eventually solved my problem: %do %while (%nrbquote(&xvar) ne %str()); Thanks for the help! Notorious P.I.G.

Basically each variable list in &credlistkeep needs to be processed through that loop. &credlistkeep is built in another macro shell, I inserted it here so you could see how it's being used. It will change regularly, but it will always contain at least one list of variables (var1-varN). I'll...

...acct11=substr(acct15,1,11); %let f = 1; do while (scan(&credlistkeep,&f,' ') ne ' '); %let xvar = %scan(&credlistkeep,&f,' '); array fx {*} &xvar; do i=1 to &mnths; fx{i}=fx{i}*-1; end; %let f = eval(&f+1); end; run; ------ERROR-------- 3828 data 3828...

...to exist... data globdata(keep=&globstatickeep &globlistkeep); set %xunc(glob.&fvar._globestar); run; data globdata1; set globdata; array tenure {*} tenur1-tenur&mnths; do x=1 to &mnths; if tenure{i} = 1 then tenurekeep=1; else tenurekeep=0; end; %let f = 1; do while...

The above example has worked in previous programs. Not that it's correct or anything, but it has worked in the past. :) If I understand correctly, my method of doing it is akin to saying "as long as there's 'something' keep processing"... but I'll try adding your suggestion and see if that...

...sas program in a data step %let f = 1; do while (scan(&globlistkeep,&f,' ') ne ); %let fvar = %scan(&globlistkeep,&f,' '); array fx {*} &fvar; do i=1 to &mnths; fx{i}=fx{i}*-1; end; if %let f = eval(&f+1); end; ---log excerpt of error MPRINT(BUILDHUB): * -----...

I think that's exactly what I need Chris. All I have to do if figure out how to incorporate it. :) Thanks! Notorious P.I.G.

...x 2 B x 3 C x I've been trying to summarize this data, summarizing all financial fields between classes (CLS * PCT_LVL) including a grand total at the end of the summary. Right now I'm only getting sums and percentages across PCT_LVL broken out by CLS, which is...

Thanks eclipse. I went back and started rebuilding the page one-by-one and stumbled onto a solution. I accidentally added an extra #break div right after the header and the #flash and #menu divs came back onto the screen. If I take out that extra #break they go away... I still can't explain...

Here's another update. I've verified this on 3 separate systems, but the #menu and #flash divs will load in IE only on the initial load of a fresh session. Once you refresh the page, then the #menu and #flash disappear. It makes me think this is a caching problem in IE. I tried adding...