Real Quest!!!   Here is Nasdaq 100 index.    How to build up a reasonable single measurement on distribution of component weight and component price change?!   Say time=t1, Nasdaq 100 index change is 0.1%.  Also at time=t2, Nasdaq 100 index change is 0.1% also. Now each component price change could be very different. The components' weight on index is static.   How to build up a distribution which shows the weight distribution along with price change on each component?!   ... View more

Hi Community,   In SAS 9.4 TS1M7, a single long DISPLAY cell in PROC REPORT spans two physical pages in ODS PRINTER PDF. On the continuation page, the remaining text is positioned near the bottom of the report body, leaving substantial blank space below the repeated column headers. VJUST=TOP has no effect. Specifying CELLHEIGHT prevents the blank space but either clips the content or forces a fixed bottom border. Is there a hot fix or supported method to flow the continuation text from the top of the next page while retaining one logical table row? ... View more

Right after supervised learning nodes in Model Studio VDMML on SAS Viya 4, I place a sas code node to score a table with the learned scoring code. Meanwhile I can use the macro variable for referencing the astore after SVM and Gradient Boosting for example, I cannot figure out how to so for models that do not produce astore like logistic regression. I can only achieve the scoring operation if I hard-cop the scoring code from the prior node and paste it into the data step.    One of my many attempts is this:    data grid_scored; set grid; %include "&dm_file_scorecode."; run; pic6.png pic5.png pic4.png pic3.png pic2.png pic1.png  ... View more

While teaching a SAS programming course recently, a customer asked how she could ignore casing while comparing two data sets using PROC COMPARE. After further investigation, I found that while PROC COMPARE includes various options to customize the comparison, there are no specific options within the procedure to make the comparison case insensitive. This blog post will guide you on how to use PROC COMPARE with case insensitivity. ... View more