Thanks, that works! Is there a web page that shows ALL keyboard shortcuts that exist by default in SAS Viya/SAS Studio? Adding: I tried asking Copilot after I asked the question here, however Copilot did not come up with the solution from @ChrisHemedinger , maybe if I try copilot again tomorrow it will find it. ... View more

Could you please provide more details? Which of the many SAS tools do you want to learn? What do you want to do with SAS?   Also please go back to your original post and change the title to a meaningful title that describes your problem in a few words. ... View more

All this variables (FruitWt, Color, Rind, Button, Wtloss) are numeric variables   It sounds like you are just stating this as a fact, rather than confirming this by running PROC CONTENTS. I have a rule here, when SAS says something is false and the human user says it is true, I believe SAS. (In my experience, SAS is right 99.99% of the time) So please check PROC CONTENTS. ... View more

The advice from @ballardw to represent Y and N with numeric values 1 and 0 should not be ignored. This applies to all SAS programming that you do now and in the future. If you are creating output (like a report or table) that you need to show others and Y and N is required in the output, then use a custom format to display 1 as Y and 0 as N.   However, I am still unable to understand the stated logic that takes me from the input data to the desired data. It simply is not clear.    Please try to write it again, in a new post in this thread (instead of correcting the original post) explaining the rules (in detail) you want to follow. As @ballardw would say, we need RULES and not EXAMPLES (although sometimes we need both). ... View more

@dsam wrote: I tried it, but month which is not numeric variable, order is messed up on x axis. Important concept: months and any calendar information in SAS data sets should be stored in NUMERIC variables. In fact, let me say that even more strongly: any calendar information in SAS data sets MUST be stored in NUMERIC variables. Character variables will not sort in the desired order for calendar information. ... View more

If I am understanding you properly, you will have to sort the data by the season and by the date of the race. Then you want to use the LAST. construct in SAS to in order to identify the last race of the season. Then it is easy to extract the information you want. See the documentation here, and the examples will be helpful.   Many people (including me) refuse to, or cannot, download attachments. The proper way to include a data set it to provide working SAS data step code (examples and instructions). ... View more

@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. ... View more

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. ... View more

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. ... View more

Agreeing! Let's do this! ... View more

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. ... View more

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. ... View more