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?

The ParellelPeriod code below has worked in other queries, but plugging it into this one is not giving expected results and I can't figure out why. I've also included a simplified view of the output. Simply put I just want the rate increase/decrease between 2/2009 and 2/2010... Any help would...

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...

Man where's the edit key when you need one. I've solved all probelms now except for one: How to I pass multiple list arguments to SCAN without receiving the following error? %let credlistkeep= tot_bal1-tot_bal25 tot_credit1-tot_credit25; data credmis(keep=&credstatickeep &credlistkeep)...

Okay I'm lost. I've added the change you recommended and now I'm getting error that I can't seem to identify. In the first step below, I'm getting 0 obs due to errors, but it doesn't say what error. In the second step I have an unclosed DO loop that doesn't seem to exist... data...

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...

Having some problems building a macro using a list of variables that is later used in a scan loop. Here is the following bits of code: ---in macro shell %let globlistkeep= tot_bal1-tot_bal25 tot_credit1-tot_credit25; ---in separate included sas program in a data step %let f = 1; do...

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.

I'm trying to summarize data that look like this: Example Data CLS PCT_LVL VARS1-VARSx 1 A x 1 B x 1 C x 2 A x 2 B x 3 C x I've been trying to summarize this data, summarizing all financial fields...

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...