About PaigeMiller

PaigeMiller

@wateas wrote: [added to my original post] The reason I want an F-value from a contrast statement is because I want a single figure that represents treatment effect magnitude which I can use to compare across different response variables. The response variables here are various measurement of soil properties, and having a sense of the degree to which different levels of "treatment 1" (e.g., compost or biochar) affects the different measurements of soil properties would be useful to me. I can't use LSMESTIMATE for this purpose, because the response variables are all on different scales, and so effect magnitudes expressed in absolute terms don't work. You run PROC GLIMMIX with the appropriate LSMEANS or LSMESTIMATE statement once for each response variable. LSMEANS or LSMESTIMATE replace the need to determine a working CONTRAST statement.

PaigeMiller

The article tells you it comes from someone named Peter Schneider.

PaigeMiller

Yes, I'm all set now. I enabled scripts for sas.com and it works. Thanks!

PaigeMiller

I see the problem. I have a security plug-in for Firefox called NoScript, it works when I set this to its lowest security level, but not when I set it to the highest security level.

PaigeMiller

This is not working in Firefox 143.04 on Windows 11. I click the check box and the web page doesn't change, it still shows the "non-discussion" topics.

PaigeMiller

I think we need to see the code that creates data set MYMAP. Please post code in the proper code box (it has the little running man icon) as you did in earlier threads.

PaigeMiller

I agree with QBF, there are a lot of things in your code and problem statement that either don't make sense, or need a lot more explanation, or raise eyebrows. I'm not at all sure your question is the one I gave a solution for — is the problem really that you want cyan lines but you never told SAS to draw a cyan line? I think it would be a positive thing to re-write this whole problem statement with a goal of making it much clearer. And don't make the mistake of assuming that we know what you are doing or we can figure out what you are doing, because as I said, I have no idea what data set _test_mm_ind is doing or why it is even included.

PaigeMiller

Nowhere in your code do you ask for a CYAN colored line. This should work, I'm too lazy to fix all of your lines, I only fixed one line, you can fix the rest of the lines as needed. refline &_ref_2./axis=x lineattrs=(color=cyan thickness=2 pattern=solid); By the way, it not clear what the data set named _test_mm_ind has to do with anything. You included it without giving an explanation of what it does or why it is important.

PaigeMiller

@SASdevAnneMarie wrote: Hello Experts, I would like to display my data as 2025100513 (yyyymmddtt). My code seems do not work and I can not find the right format here : SAS Help Center: Working with Dates and Times By Using the ISO 8601 Basic and Extended Notations. I have this error message : ERROR: Format name B8601DT10.0 not found or the width and/or decimal specified for the format used are out of range. Thank you for your help. This my code : %let Ma_Date=%sysfunc(compress(%sysfunc(datetime(),B8601DT10.0),T)); It is telling you that the format you have chosen is not wide enough. B8501DT must have a width of between 15 and 26. So this works: %let Ma_Date=%sysfunc(putn(%sysfunc(datetime()),B8601DT15.0)); %put &=ma_date; If you don't want the minutes and seconds in the output, you can use the %substr function to chop off the last 4 unwanted digits.

PaigeMiller

Nesting of %IF statements in open code is not supported Nested %IF is not supported in open code. The code in red is a nested %IF, in other words an %IF within another %IF. You cannot code this way outside of a macro. Your code seems like it should run inside a macro.

PaigeMiller

The residuals need to be (approximately) normally distributed, not the raw data. The raw data can have any distribution, and if the residuals are normally distributed, then GLM is appropriate.

PaigeMiller

Your very general question can only be answered with very general answers. You read the dynamic data into SAS, then you use SAS to write to a PDF file in the desired format. I also suspect that there are tools other than SAS that would be better for this task, but I have no idea what those other tools would be. You might want to ask companies that create bills what they use.

PaigeMiller

@ballardw I hadn't thought about what a use could be for code like "N=%left(&sam)", but if you are right, or if you are wrong, I think there is probably a better way to handle it. It is a constant struggle to get people to explain the big picture of what they are trying to do, they only want to talk about the specific coding problem they have, they don't want to get into the big picture. This particular request seems like it is an instance of the XY Problem.

PaigeMiller

I would add to @LinusH 's request that you should explain in words (not code) what you are trying to do. And why do you apparently want to store SAS code in a data set variable? For example your code includes this: visit1="N=%left(&sam1)";

PaigeMiller

If ever there was an argument for not writing your own code to do this type of calculation, this thread is it.

Online Status	Offline
Date Last Visited	yesterday

Re: Issue with CONTRAST statement in GLIMMIX

Re: SAS slop on the internet

Re: SAS Community OF edition (only forums)

Re: SAS Community OF edition (only forums)

Re: SAS Community OF edition (only forums)

Re: How to do multiple refline with varied colors by flag?!

Re: How to show multiple reference lines with varied colors based "the...

Re: How to show multiple reference lines with varied colors based "the...

Re: Datetimes format

Re: macros %else %if... %then %do generated error

SAS Community OF edition (only forums)

Re: The variable never been referenced in the keep statement %3F%3F%3F...

Re: How to get weighted stdev in SQL/SAS?!

Re: do while is not working

Re: How can I incorporate Excel like data bars in ODS Output?

Re: Datetimes format

Re: Best approach to analyze data skewed to the left with GLM

Re: How to get weighted stdev in SQL/SAS?!

Re: How to get weighted stdev in SQL/SAS?!

Re: How to get weighted stdev in SQL/SAS?!

Re: Issue with CONTRAST statement in GLIMMIX

Re: SAS slop on the internet

Re: SAS Community OF edition (only forums)

Re: SAS Community OF edition (only forums)

Re: SAS Community OF edition (only forums)

Re: How to do multiple refline with varied colors by flag?!

Re: How to show multiple reference lines with varied colors based "the...

Re: How to show multiple reference lines with varied colors based "the...

Re: Datetimes format

Re: macros %else %if... %then %do generated error

Re: Best approach to analyze data skewed to the left with GLM

Re: Pdf bill creation with dynamic data

Re: What do when referencing a macro variable which value is 0?

Re: What do when referencing a macro variable which value is 0?

Re: How to get weighted stdev in SQL/SAS?!

SAS Global Forum