About PaigeMiller

PaigeMiller · ‎04-01-2026

@dsam wrote: my code is below: I have x axis values like in months such as D1 D28 2 3 4 6 12 18 24 36 but for one subject it is plotting month 18 after month 48 even though data is sorted properly by numeric variable. title 'Percent Predicted FEV1 for Individual Subjects in Four 4D-710 Dose Cohorts'; proc sgplot data= combo; xaxis grid type= discrete discreteorder= data; series x = month y= RESTRESN/ group=subjid; scatter x=month y= RESTRESN/ group= subjid ; xaxis label= 'Month'; yaxis label= 'ppFEV1 (%)'; by cohort; run; When you have multiple XAXIS statements, the second one replaces whatever is specified in the first.

PaigeMiller · ‎04-01-2026

One solution, of course, is to manually add line breaks when the line gets long and might pass the right edge of the window. I have done this in the SAS application workspace (I don't use Enterprise Guide) for the last 700 years. I don't even think about it any more, its a habit.

PaigeMiller · ‎03-31-2026

Are you running this in SAS/Studio? If so, SAS/Studio cannot access files or folders on your local computer's hard drives. You have to create libraries on the server where SAS/Studio is running. You mentioned SAS On Demand, here is how I use the LIBNAME statement libname mydata "/home/paige.miller3"; data mydata.class; set sashelp.class; run; Of course, you would have to use a different folder than PAIGE.MILLER3, it has to be a folder the exists in your SAS On Demand.

PaigeMiller · ‎03-31-2026

Agreeing! Let's do this!

PaigeMiller · ‎03-31-2026

Check your syntax in the WHERE statement carefully. You want to use a macro variable but have left off the & in front of the macro variable name.

PaigeMiller · ‎03-30-2026

This is great to hear @ivarenho . So many visitors only want the answer to their programming problem and learn nothing useful so next time they have similar problems. So many visitors to this forum receive the same advice about creating a working program without macro variables first, and they ignore the advice and move on to struggle mightily with macros.

PaigeMiller · ‎03-30-2026

@SASdevAnneMarie wrote: I thought that proc pls centered and scaled variables by default. Yes it does. My mistake, VARSCALE is an additional option to help with crossproducts of model variables (if you have any). This was precisely to compare the PCR and PLS outputs. Outputs as in measures of fit? Because there's really no point in comparing loadings or scores between PCR and PLS.

PaigeMiller · ‎03-30-2026

I believe you want the VARSCALE option in PROC PLS. VARSCALE specifies that continuous model variables be centered and scaled prior to centering and scaling the model effects in which they are involved. The rescaling specified by the VARSCALE option is sometimes more appropriate if the model involves crossproducts between model variables; however, the VARSCALE option still might not produce the model you expect. For more information, see the section Centering and Scaling. For more advanced centering and scaling methods, use PROC STDIZE. I always feel uncomfortable when PCR is chosen for METHOD, as this logically (based upon the criterion being optimized) will produce worse fits than METHOD=PLS. Maybe there are valid reasons for using PCR instead of PLS, but in general PCR will not fit as well as PLS.

PaigeMiller · ‎03-27-2026

@ivarenho wrote: The date from June 1980, please correct me if I'm wrong but that has to be in the quotation marks because it's making a calculation? Certain types of calculations can be done in SAS without quotation marks. It depends on whether or not quotation marks are required to create valid SAS code. In some cases, quotation marks are invalid at that point in the SAS code and will cause SAS to generate errors. This is why @D_Dunlap said you really should first generate working SAS code without macros variables, and hard-code the values that the macro variable will take — and if it works without quotes, then you don't need to quotes when you use the macro variable. If it doesn't work unless you put the quotes in, then you need the quotes when you use a macro variable. This is why @Tom said "The code that results once the macro processor is finished needs to be actual valid SAS code." So please, do yourself a favor and first create working (emphasis on "working") code without macro variables and hard coded values where the macro variables will go. Then using the macro variables correctly will be a much easier task.

PaigeMiller · ‎03-26-2026

Perhaps this will work for you https://communities.sas.com/t5/ODS-and-Base-Reporting/Color-background-of-group-name-in-proc-report/m-p/689395#M24539

PaigeMiller · ‎03-26-2026

Just a quick addition to the correct answer from @Ksharp : the RETAIN statement, when used properly, allows you to carry data forward to the next row, and allows it to change when your rules require it to change (when PAY=2 do not carry the data forward).

PaigeMiller · ‎03-26-2026

So, @jitb , I would like to briefly summarize the responses so far. In order for you to have the best chance of getting good replies in the future, please keep these things in mind: When you are having problems, we need a clear explanation of what you are trying to do. Do not assume that because you posted code that doesn't work, we know what you want. We also need to know you think the correct answer is, or at least the correct thing for the code to be doing. We need a portion of your SAS data set, or we need made up data as long as it illustrates the problem. Please follow these instructions and examples to provide the data. If there are errors in the log, please show us the LOG (start to finish) for the DATA step or PROC that you are having errors in. Do not show us tiny portions of the log.

PaigeMiller · ‎03-25-2026

It would be extremely helpful if you showed us the ENTIRE log for this data step (not a small portion of the log). Also, as far as I can tell, there is no need for %sysfunc here, yet you chose to use it even though no macro variables are present. As far as I can tell, there is no need for %str here, yet you chose to use it even though no macro variables are present. If payment_amount and term are data set variables, %sysfunc and %str cannot access the values of a data set variable. Therefore, %sysfunc sees text as the second argument of the REPEAT function. The text is term-1 which is not a number, and not a reference to a data step variable, hence the error. So if you remove %sysfunc and %str and their associated parentheses, this might work.

PaigeMiller · ‎03-25-2026

Go through the SAS Communities and read the original post in old threads (you can pick the New Users community if that is appropriate for you). Don't read the answers, just read the original post. Provide your own answers. I think 2018 was a good year.

PaigeMiller · ‎03-23-2026

random intercept / subject=PRVDR_NUM(hrrnum) group=PAC_1 type=vc; So here HRRNUM is nested within PRVDR_NUM. That's 2943 x 306 = 900,558 different combinations. I can understand why SAS is telling you this will take a very long time. Further, with 160,391 observations, the data will be very sparse in some of the combinations of HRRNUM and PRVDR_NUM; in other combinations of HRRNUM and PRVDR_NUM, there will not be any data. So, this is an overspecified model as well, you can't estimate everything.

Online Status	Offline
Date Last Visited	yesterday

Re: A SAS Macro to Use ODS to Direct Graphics Output to a Specified Fo...

Re: proc pls : saving the model

Re: Combine the variable values vertically

Re: Combine the variable values vertically

Re: A SAS Macro to Use ODS to Direct Graphics Output to a Specified Fo...

Re: proc pls : saving the model

Re: proc pls : saving the model

Re: proc pls : saving the model

Re: proc pls method pcr plots

Re: How do organize he data to use ANOVA

Re: LSD test in PROC GLIMMIX

SAS Studio, SAS Server search/navigation bar

Re: PROC REPORT: How to apply same color to group headers and column h...

Re: Flag data based on dates (first and last)

Re: Long name of variables for proc import

Re: proc pls method pcr plots

Re: Create a new Calclation based on multiple conditions

Re: Why I Still Trust This Community More Than Any AI Assistant

SAS Viya/SAS Studio — how to convert code to lower case?

Re: How to plot "A" outside of the plotting area in base graphics?

Re: why is my x axis going out of order even though i have it sorted w...

Re: Text Wrap in Enterprise Guide?

Re: Every time I try to make a permanent data set I get a library does...

Re: SAS Studio, SAS Server search/navigation bar

Re: SAS Programming Essentials Lesson 3 Demo: filtering rows using mac...

Re: SAS Programming 1: Essentials Demo: Filtering Rows Using Macro Var...

Re: proc pls: center and scale

Re: proc pls: center and scale

Re: SAS Programming 1: Essentials Demo: Filtering Rows Using Macro Var...

Re: PROC REPORT: How to apply same color to group headers and column h...

Re: how to create a new visit date

Re: Using REPEAT function to calculate IRR

Re: Using REPEAT function to calculate IRR

Re: Daily SAS Problem?

Re: ERROR: Model is too large to be fit by PROC GLIMMIX in a reasonabl...

SAS Quant Community

SAS Global Forum