Everything is in Hadoop.   Say, I create data set 1, then add it data set all (which doesn't exist at this point), then I create data set 2, then add it to all (which now exists), then create dataset 3 and add it to dataset all,  and so on.  I know how to do this with proc append, but not with sql.  Will the code above do this?   ... View more

I want to loop through and create the dataset in the first pass through the loop and then keep adding to it in subsequent passes.  It will exist in the second pass so this won't work for me.  Great idea though, thanks.  ... View more

That is the answer to the question I asked, but I need for it to work in hiveql and all the macro stuff won't work there.  Still, thanks! ... View more

This is going to trip up SAS 9 programmers. ... View more

Yes, in reality I am multiplying the fraction by some data from an input dataset.  I took all that out to focus in on the behavior of the fraction which is zero with or without an input dataset.  ... View more

Proc sort is an exception to this rule,  correct? ... View more

Yes, this is what I meant.  Will the procs that are not cas enabled like proc freq still work if you specify an input dataset that is in cas memory and an output dataset that is in cas memory.   ... View more