Simple SAS Questions

[ThatGuy]

hahaha wow thanks dumples...let me try it..

[ThatGuy]

Nope it is still trying to go to the E drive and not the R drive for year 2006 any month...

[dumples]

Is it completing, but not hitting the condition or is it not completing and giving you errors in the log?

I think one thing you should do is put a

 
%put &month &year;

before your initial if statement and look at the log.

You might think that it's saying 9, but it's really saying 3*3 and that's why it might not be hitting the condition.

Again, just a thought...

[ThatGuy]

Awesome, I was not aware of how to show myself what was being looked at in the if statement. ty

[BassFreq]

Also try submitting

 
options symbolgen mprint mlogic;

That will tell you lots about whats going on in the macro.

[ThatGuy]

It's funny dumples. I put that statement in and the loop worked. I can't explain it but thanks for your help today!

[ThatGuy]

thanks bassfreq. This was my first macro.

[BassFreq]

My pleasure. Fun stuff.

fyi...to turn off all the extra macro stuff in the log, submit "options nosymbolgen nomprint nomlogic;

[ADoubleDot]

Is there an equivalent option to "Option Explicit" from VBA for the SAS data step? Soooooo annoying.

[Gareth Keenan]

new Topic!

I have a large data set, 1M+ rows, and There are two fields of interest. I'll call them POL and ITERATION. I've all ready sorted the data, but how can I take my table from the work library "table" and create a "table2" which only keeps all records for the greatest ITERATION for each POL. Example below.

Before
POL ITERATION
1 1
1 2
2 1
3 1
3 2
3 3
3 4

After
POL ITERATION
1 2
2 1
3 4

Anyone know how to do that?

Cheers!

Gareth Keenan