I can think of two ways to avoid this. 1) Don't put spaces in front of variable names in Excel 2) Write a macro to remove underscores if they are the first character of a variable name. ... View more

PROC MEANS with at BY variable; or PROC SUMMARY with a CLASS variable ... View more

> I want to analyze a model which is composed of : > - 1 binary response (conform or not) > - 5 quantitative variables (time, temperature...etc) > > My objective is to see which variables are linked to > a conform response and which one are linked to a > non-conform response. > > So, I would like to make a PLS regression but under > SIMCA software, the response must be quantitative > (which is not my case here). How can I do a logistic > PLS regression under SAS ? > > By advance, thanks a lot, You could certainly set up your response as numeric 0 or 1 variable, pr the logistic transform of probabilities conform or not, and run it that way. PROC PLS would certainly accept that. Whether or not that's better than doing a logistic regression, as Peter suggests, depends on the exact nature of your data, and that is something I can't comment on. Message was edited by: Paige ... View more

Not sure you can "verify" normality with 4 individuals. With 4 individuals, I doubt that whatever 4 numbers you have would fail a normality test. Just seems unlikely to me with real data. I would do the t-test, myself. If you are worried about convergence problems in PROC MIXED because of 4 individuals (which is something I don't normally worry about), you should probably also be worried about the validity of Wilcoxon on 4 individuals; and also worry about the power of the test being very low. ... View more

PROC TTEST with the PAIRED statement should work. If you want to get more fancy, you could used PROC MIXED with the REPEATED statement. ... View more

If you move the %put statement inside the macro, everything works. Another responder has explained how %global also fixed the problem, but I would recommend instead of %global, you do all macro commands involving your macro variables INSIDE the macro. ... View more

The real time took longer, but the CPU time was approximately the same. This would indicate to me that the problem isn't SAS, its the other things your computer is doing. ... View more

PROC DATASETS NOLIST LIBRARY=WHSE; ... View more

If you hit F1 to open SAS Help, and in the Index tab, search for SYMBOL Statement Syntax, you will find a table (scroll down) showing the value and the symbol. Message was edited by: Paige ... View more

Did you check the SAS docs? PROC MIXED has an OUTP= option in the MODEL statement. ... View more

One solution: PROC MEANS, BY SAMPLE with an OUTPUT statement, puts all your means into a dataset. Then, use another data step to count the times the mean is in the desired range, and the number of times it is not in the desired range. ... View more

Steve I agree with your comments. My point is that E(X), E(Y), etc. etc. are quantities that cannot be computed via simulation. E(X), E(Y) and the other moments are integrals, and SAS doesn't do integrals. You cannot evaluate integrals via simulation. You can however obtain an ESTIMATE of E(X), or E(Y), or E(the short piece divided by the long piece) via simulation. ... View more

You can't find E(the short piece divided by the long piece) via simulation, if I am understanding you properly, that E is Expected value. You can find the mean of the randomly generated numbers. ... View more

Use the OUTPUT statement to store the results, then PROC PRINT with whatever format you want. ... View more