About LinusH

LinusH

Flow Manager - does this mean you are using IBM Spectrum LSF as scheduler? I don't have access to it right now, but at least in the non-oem version you can specify limits on a job, like no of hours/minutes for run time: https://www.ibm.com/docs/en/slpm/10.1.0?topic=flow-details-job#d15313e626 Another way is to write a command script that kills the job: https://www.ibm.com/docs/en/slpm/10.1.0?topic=flow-kill-running-job#d37741e63 Or jkill to kill a whole flow.

LinusH

Make sure you have set LOGPARM=“WRITE=IMMEDIATE” system option. And again, check Windows event logs as well.

LinusH

Even if there is no SAS logs, there should be something logged somewhere...have you checked Windows event log?

LinusH

I generally avoid having pre-assigned in external configuration (e.g. Autoexec). If you pre-assign using metadata, I think only libraries that you have authorization for (in metadata) are getting assigned?

LinusH

I think that the OUTTABLE= will give you most of the stats OOTB that you are asking for. SAS Help Center: OUTTABLE= Output Data Set

LinusH

If this is a recurring requirement, you might want to look into T-argus (developed by (for?) Eurostat) and SAS macro package to communicate with T-argus (SAS2argus). https://github.com/sdcTools/SAS2Argus τ-ARGUS (cbs.nl)

LinusH

What is the SAS versions including maintenance release for source and target environments? If both are 9.4, you could export them using standard export tools in SAS, interactivity from Management console by creating spk files.

LinusH

To be sure, is EG connecting to a local or a remote SAS session? And is your ODBC Manager test done on the host where SAS executes (and using the same user/pw)?

LinusH

On these communities, you can't really "require" help 🙂 Bu my suggestion is to contact SAS Tech support, they can guide in more detail, based on the logs created by the Deployment Manager.

LinusH

Have you checked the documentation (it's locked down for non-licensed users)? But to start with, what are the tasks at hand that you think similar macros could be helpful?

LinusH

AWS is a fully fledged IT eco system. SAS Viya is fully fledged analytical platform. You have to be more specific in what kind of experince you have with AWS, and in what role you see yourslef while interacting with SAS Viyya.

LinusH

With the process id you can check in OS who/what process it is.

LinusH

I don't have any insight in PRAMS, and maybe not so many other here at he communities, so a bit more details would be helpful to understand your challenge. "SAS is creating one giant table that includes each survey question for each variable." Please provide a PROC CONTENTS to describe your imported data set. For the State filter, isn't there a variable that holds that information? Again, more detail required to help you.

LinusH

Pulling big chunks of data works best if the table is partitioned: https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16 But if this is a recurring query, why not keep a local copy of the history data, and just pull the recent dates/year?

LinusH

proc sort data=have; by usubjid descending ady; run; DATA FLAG; SET HAVE; BY usubjid; length flag $6.; if first.usubjid then flag = ' '; else IF AVALC = 'Y' and lag(AVALC) = 'N' then FLAG='check'; RUN;