Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PerlIsGood

    MDX Dynamic Set not showing up in cube

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

    MDX ParallelPeriod issue (SSAS Cube)

    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?
  3. PerlIsGood

    MDX ParallelPeriod issue (SSAS Cube)

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

    PeriodsToDate help

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

    PeriodsToDate help

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

    PeriodsToDate help

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

    RegEx help and file concatenate

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

    RegEx help and file concatenate

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

    RegEx help and file concatenate

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

    Works in PC SAS but not on Mainframe

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

    SCAN + list of variables in a macro

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

    SCAN + list of variables in a macro

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

    SCAN + list of variables in a macro

    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)...
  14. PerlIsGood

    SCAN + list of variables in a macro

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

    SCAN + list of variables in a macro

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

    SCAN + list of variables in a macro

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

    Proc Tabulate problem

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

    Proc Tabulate problem

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

    absolute div stacking problem

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

    absolute div stacking problem

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

Part and Inventory Search

Back
Top