Recent content by PerlIsGood

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