If I am understanding you properly, and you have a long HTML output where you need to fix the 5th analysis, you need to re-run the analysis program that produced all of the long HTML output, making the fixes in there.   To explain what is happening, when you use ODS HTML (or other ODS destination), SAS creates a file containing all of the outputs you just created by sending everything to an HTML file (or other file). It also creates a set of indexes, which is what you are seeing on the left of the Results window, these let you navigate quickly to parts of the output HTML file. Deleting the index has no impact on the HTML file, it only prevents you from navigating there using the Results window. So if you want the fifth analysis in the HTML file to change, you have to fix the program that created the HTML file, and then re-run it. ... View more

&sasworklocation — is the for EG only? I don't seem to be able to use it in base SAS 9.4 ... View more

I feel like I am missing something. The following code, using HTML, creates the plots as .png files in whatever folder you specify.   ods html path="C:\Users\xxxxxx\Documents\temp1" gpath="C:\Users\xxxxxx\Documents\temp1"; proc sgplot data=sashelp.class; scatter x=height y=weight; run; proc sgplot data=sashelp.class; vbar age/response=height; run; ods html close; PaigeMiller_0-1787596602698.png   ... View more

It occurred to me today that not all forums have seen this decrease in traffic. The Adobe Community forums seem just as active and lively as ever. I have no statistics to back this up, but I use the Adobe forums almost daily.   Perhaps the difference is that SAS is a programming language while all Adobe products have a point and click interface. Or perhaps this is totally off the mark. ... View more

Quoting @Kurt_Bremser :   "why do you need to do this?"   Help us all out, which helps you as well ... explain to us the real problem you are trying to solve, not just the one piece of code where you are getting stuck. Normally, the real problem is that you are trying to create a table or a plot or analysis. People here have lots of experience to help you get there, but we need to know where it is you want to go. See the XY problem. ... View more

Please explain in a lot more detail what you mean by "I want to vertically expand the plot". ... View more

Length and format are two different characteristics of your variable named X. Just because you have set the length of X to be $200, the format of X has not been set, so SAS guesses at what you want, and in this case it guesses wrong. If you set the format in PROC REPORT, the problem goes away.   proc report data=xxx; columns x; define x/format=$200.; run;   or, an alternative solution, with PROC REPORT unchanged from your original code   data xxx; length x $200; format x $200.; x = '-1'; output; x = '-10'; output; x = '-100'; output; x = '-10'; output; x = '-1'; output; run;   PS: maybe I'm going off on a tangent here, but storing numerical values as text strings is generally a problematic thing to do, while storing numerical values as numbers is highly recommended, and also solves the problem.   data xxx; x = -1; output; x = -10; output; x = -100; output; x = -10; output; x = -1; output; run; ods excel file="&workpath.\XXX.xlsx" style=Plateau; ods excel options (sheet_name="XXX" tab_color="white" flow="tables"); /* Even simpler would be to use PROC PRINT here */ proc report data=xxx; columns x; define x/display; run; ods excel close; libname prvfndgs xlsx "&workpath.\XXX.xlsx"; data yyy; set prvfndgs.XXX; run;     ... View more

You can use PROC TRANSPOSE as in this example:  https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/n01rzqgzs8vq1bn10h1wtx914kyf.htm   If you want actual code, you will need to provide data in a usable form, as seen in these examples and instructions.   PS: I understand that a key person wants the data in this form; but please understand that is the only reason to do this. If you are programming for yourself, and want to use the results in further analyses, tables or plots, you would never do this transpose. As stated by @Kurt_Bremser , this transposed arrangement of the data makes all other programming much more difficult. ... View more

@FreelanceReinh wrote:   Yes, it looks like those mathematical inaccuracies occurred too frequently in Copilot's training data. Sadly, it's not just using words wrong. It doesn't do calculations properly either. One day I was lazy and asked Copilot to compute MPH for my walk, in which I walked 3 miles (exactly) in 56 minutes and 36 seconds. Copilot walked me through the math and for the first step, Copilot told me that 56 minutes and 36 seconds is 56.61 minutes. Can you spot the error? (it's a small error but certainly not round-off error) There was another math error in the next calculation as well. ... View more

I asked an AI chatbot (Copilot) why traffic is way down at internet help sites. The answer:   Traffic on StackOverflow and similar help sites is down because several structural shifts all hit at once, and the data is now overwhelming: generative AI replaced most routine Q&A, moderation friction pushed newcomers away, and expert contributors withdrew when their effort stopped being rewarded. The collapse is not subtle — question volume is down 29× from its peak, and many sites are back to launch‑year activity levels.   Interesting how Copilot does not seem to recognize that multiplication and division are not the same thing. Down 29x is not the same as 1/29th. I do realize that many people make this same mistake in their speech and in their writing. ... View more

It would still help if you would be specific, instead of using the very vague word "processing". I'm sure many people here have good ideas on how to handle large data sets, but we can't help you unless we know what you going to do next.   Also, how big is this data set, in terms of rows and columns? ... View more

I would like to suggest that splitting data sets like this is rarely needed and is rarely a good idea, and it usually makes the next steps in your programming more difficult. If you tell what you plan to do next with this data, we could advise on a better approach.   If, for example, you want to perform a regression analysis on each split, you can do so like this (and of course this method applies to almost every PROC even if it is not regression)   data large_set1; set large_set; id=mod(_n_,10); run; proc sort data=large_set1; by id; run; proc freq data=large_set1; by id; model y=x; run;   ... View more

Partial Least Squares ought to be mentioned here. In my opinion, it is the best modeling tool when you have collinearity among the X variables, and is widely used in some areas, like spectroscopy (and of course is used in many other areas). Please see the paper by Tobias (of SAS Institute), in which he takes 1,000 highly correlated predictors, and still obtains a useful model, without all the time-consuming messiness of reducing variables. Also see the paper by Bartell (from JMP) here. ... View more

Perhaps the %NRSTR function will work here. But yes, definitely show us your code. In fact, please, from now on, ALWAYS show us your code in the first post on a topic.  ... View more

Agreeing with @Tom that numbers should not characters.   Once you perform the conversion to have numeric values, PROC SUMMARY or PROC MEANS produces the dataset or output you want. ... View more