About LinusH

LinusH

That's correct, SAS doesn't support windowing functions (which has a SAS ballot entry for btw, feel free to vore 🙂 Add window functions in SAS SQL - SAS Support Communities) If your data resides in adatabase that support these functions, you could use explict SQL pass.through. If you need to use SAS syntax still, please provide a have example data set (using datalines) and a want output so we don't have dry interpret your SQL 🙂

LinusH

Are you asking about installing Viya on some kind of Oracle Linux containers? If so, provide a link with a relevant SW page. AFAIK it is not supported to install Viya on other Kubernetes editions than the ones listed here: SAS Help Center: Platform-Specific Requirements

LinusH

Are there any planned releases for July and/or August? If yes, what are the target dates?

LinusH

I may be wrong, but I think Java is bundled with SAS. There is an extended support for Java 11 undil 2032. You may direct your question to SAS how they will support their Java version bundled with their software. This should be a clear strategy from SAS since this scenario is relevant to all their SAS 9.4 customers.

LinusH

In my mind Saprk is not a language, it's a platform or engine for data management, query and analysis, similar to the engines Viya provides (CAS and SAS Compute). So it makes little sense to have a Spark cluster within SAS Viya platform. Again, you can deploy open source Spark and have the same data availble to it as you have in SAS. Spark supports SQL, Python, Java and Scala, (and perhaps more since it's open source), of wichSAS supports more or less SQL, Python and Java. What is your requirement?

LinusH

If this is a one time import I would say edit the Excel file. In a SAS data step, use the RETAIN statment, to keep values from previous observations, and assign them to the current observation. Untested code (since you didn't attach readable data): data want; set have; retain prev_areacode $8 prev_subject $8 prev_date 8; if areacode ne '' then prev_areacode = areacode; else areacode = prev_areacode; if subject ne '' then prev_subject = subject; else subject = prev_subject; if date ne . then prev_date = date; else date = prev_date; run;

LinusH

Please provide a WANT dataset based on your TEST dataset input.

LinusH

Also, I highly recommend taking some course if you are to be a Viya admin: https://learn.sas.com/course/view.php?id=526

LinusH

This is for Viya on Azure. SAS Help Center: Add and Configure Users What is your operating environemnt?

LinusH

Are you asking if you can deploy a Spark engine inside a SAS Viya deployment? ASFAIK SAS doesn't provide that. So the question is what is your real constraint? What data do you have in CAS and how is it stored? If you chose to store the data in 3rd party DBMS/engine, you can make that available to your Spark cluster of choice. What options do you have, and where have you deployed Viya?

LinusH

Do you mean like importing the data from what you visually see in a report? Referring to a Swedish saying, why are you crossing the river to get water? Consume the data that the VA report is based on instead.

LinusH

Your sub-query doesn't know about columns created in the outer query, so you need to replicate the logic from the outer query in your sub-query. I don't know your requirement, but I would guess you wnat to have a GROUP BY in your outer query, or what is your desired en result?

LinusH

As stated by others, you need to provide more informaitno of your actual data. Please provide a PROC CONTENTS of both datasets. If in an external RDBMS, the DDL together with stats. Add the following to your code: options fullstimer msglevel=i; proc sql _method; /* In case of external data source */ options sastrace=',,,d' sastraceloc=saslog nostsuffix;

LinusH · ‎05-28-2024

When a SAS process ends in error, it usually leave your a return code, unless someone specifically coded around it. What does the log say? Not sure how an egp (Enterprise Guide project) comes into the picture in this scenario.

LinusH · ‎05-20-2024

Please share the actual log.