To tell you the truth, I don't have a problem with getting a power of > 0.999 in this case. I do have a problem with your statement "no matter what ntotal value i enter". When I enter an ntotal value of 5 or less, the power decreases. The power of a test is: the probability that the test will reject the null hypothesis when the null hypothesis is false. So, with only 2 observation, the probability of rejecting H0: mean=0 when in fact H0 is false is 0.219. That seems like the right answer to me. With only 2 observations, and mean ne 0, you could easily wind up accepting the null hypothesis. When ntotal increases to 10, it seems very likely that you will reject the null hypothesis when it is false. ... View more

Show us your SASLOG for what you tried. You might also want to show us a portion of your data. ... View more

To be honest, I would try a different approach. I've gone through this, my view has evolved from picking a small number of variables, to saying that doesn't make sense and using a different approach in which all variables are used in the model. The problem is that there are many different definitions of "best possible independent variables". Also, forcing yourself to only 4 may or may not be harmful, and furthermore if your independent variables are correlated with one another, then least squares fitting and picking a few variables may not be the best approach at all. I would use PROC PLS and fit a model that includes all independent variables,and which accounts for correlation between the independent variables; and from there you could judge a small number of important variables (although that number may not be 4). ... View more

Yes, that is a very good introductory example, for a simple ordinal logistic regression. ... View more

Based upon my understanding of your description, and my understanding of ordinal logistic regression, I would the answer is YES! PROC LOGISTIC still applies here. ... View more

There are probably several techniques that might work here, depending on what assumptions you want to make about errors and objective function, etc. You might want to try ordinal logistic regression, since your dependent variables are really 6 different categories. See PROC LOGISTIC I might also go with PROC PLS, as your independent variables are most likely correlated with one another. There's also a Logistic version of PLS in the literature, although I think you'd have to code that yourself, as far as I know it doesn't exist in SAS. ... View more

I too would be interested in hearing if there is software designed to do this. At the time, I wound up writing SAS code to do search and replace inside of *.sas files in a directory(s), and I must say it usually worked, but there were a few problems that I never anticipated and never figured out why they were happening. ... View more

Yes, lines get truncated if they are too long for the program editor. That sounds to me like a reason to force everyone to use the Enhanced Editor. But I agree with Fareeza, in my opinion, productivity gains come with good coding, not with Enterprise Guide ... View more

However, if the macro variables are cast in concrete including all the parentheses, you could always try: Or use text manipulation functions to remove the parentheses (and any other unwanted characters) ... View more

data text; set data1; b+bal; v+val; run; ... View more

Assign a variable to the original data set that determines if the row number is odd or even (actually, this produces 0 for even and 1 for odd) odd_Even=mod(_n_,2); Then create a new data set by merging the odd rows with the even rows and assign the values to old_id, new_id old_Pl new_PL. The key part is the merge statement merge old_dataset(where=(odd_even=0) rename=(id=old_id pl=old_pl)) old_dataset(where=(odd_even=1) rename=(id=new_id pl=new_pl) drop=other); by loc; This will work if each LOC has exactly 2 rows. Otherwise, there are modifications you would need to the dataset and program if sometimes LOC can have fewer than or greater than 2 rows. ... View more

"statistical reporting" is somewhat vague, can you give examples? ... View more