SAS Support Communities

I don't have SAS Studio (Viya 4) at my fingertips, but I found a post that shows that in Viya 3.3 it was possible to set the execution mode to Parallel for a flow. I hope they didn't take that option away....? https://blogs.sas.com/content/sgf/2016/04/06/sas-studio-parallel-process-flows/   Otherwise your next best option is to not use the sub flow feature, but rather define your flows dependencies in SAS Job Flow Scheduler: https://documentation.sas.com/doc/en/sasadmincdc/v_063/caljobs/titlepage.htm     ... View more

INSERTBUFF is the option to consider here. BULKLOAD and DBCOMMIT won't affect read operations. Pass-through will probably have the same performance as library access. But, you could use pass-through to shorten wide columns before transfer to SAS (which would also probably work using implicit pass-through using PROC SQL and LIBNAME). ... View more

Assuming EG users connect to a SAS 9.4Mn server, so there should be a metadata server running, no? Check metadata rights for the library and potentially the metadata folder the library is stored in. Also, what is the setting for pre-assign? ... View more

Hard to give specific career advice to someone I don't know. But generally speaking, analyse the ads that interest you and and see what competences they are looking for. If you still want to pursue a career using SAS, some basic understanding of SAS Viya could be helpful. If you are (or want to become) a data scientist, Databricks seems to be a fairly popular platform to work with. But it also comes down to you, what kind of tasks do you want to work with? ... View more

If this is a product suggestion you should crate an entry under "SAS Product Suggestions" You have now used a post as an article, for which I don't think this is the intended use. ... View more

I have learned about this data entry possibility in VA, but haven't used it. But my gut feeling is the same as yours. You probably bet better off by connecting Excel either direct you your data base, or via SAS and Add-in for MS365. Another option is to us a data entry product/applications such as Data Controller for SAS: https://datacontroller.io/ ... View more

Regardless of use case, for analyzing performance you need to provide more information about your task. Like: - Where does your SAS session executes (vs your Synapse instance). - If SAS is on premises, what is your method of accessing Synapse (internet, direct route...) - Have you possibility to tr another client tool to perform a similar operation? - What is column definitions does your table have? I suspect you have some long varchar columns. - Rerun the query and add the following options: options msglevel=i sastrace=',,,d' nostsuffix sastraceloc=saslog fullstimer; Please review optimization options for your libname statement, like READBUFF.       ... View more

Both in SMC and DI Studio you have a search facility, where you among other things can filter on object type.   From MobaXterm, if you start a SAS session where you have program editor, log and output window, there is also a metadata browser. You need to set metadata options so you are connected to the metadata server.   SMC logs are typically stored under the each users home directory, on the host/client where SMC executes.     ... View more

Assuming DMS SAS. Restarting a SAS session takes less than a second, so I'm not sure what you want to achieve? Is there something in the current session that you don't want to reset? In SAS Studio there's a reset options, but that in turn fires an ENDSAS statement, practically the same as restarting SAS (but in Studio you don't have to close the window). ... View more

That the flow still executes is expected, the execution takes place outside SAS metadata. SMC (should) show what is scheduled. Does the DI job and the Scheduled job still exists in metadata? You can also check metadata dependencies (between flow and deployed jobs)  through the metadata browser from a DMS SAS session, or third party tools. Maybe a stretch, but you are using the same credentials now as when you defined/deployed the flow? And the authorization hasn't changed. Have you checked your local SMC log as well? ... View more

What does not work? Please attach full log. ... View more

https://communities.sas.com/t5/SAS-Communities-Library/How-to-send-email-using-SAS/ta-p/746523 ... View more

I don't have a SQL Server to play at this point, but if you can create an ODBC data source to your linked server, chances are that you can connect from SAS as well. I found this (old) hack on Stack Overflow: Connection string for Linked Servers Database - Stack Overflow. But wouldn't it be easier to connect directly to your linked server? ... View more

If you can keep a permanent version of your formats in a CNTLOUT table, you can use SAS File I/O functions to query it. Awkward, but it might fit your purpose? ... View more

I'm not versed in Viya 4 enough to help you with that specific request. But there might other solutions. If you have a separate input (file, dataset etc) that Flow 2 reads regularly it could do the trick. If that data is missing or empty the Flow 2 ignores it, if it has data the flow uses it, and then at the cleans it out afterwards so it won't be used further (truncate/delete/move). ... View more