About RonAgresta

RonAgresta · ‎07-19-2024

This is not a product enhancement request, but intsead a SAS Community enhancement request. Forwarded to that team to consider changes.

RonAgresta · ‎07-19-2024

Customer has solved the problem.

RonAgresta · ‎07-03-2024

We don't intend to add this enhancement to SAS Viya 3.5. Thank you for the suggestion.

RonAgresta · ‎07-03-2024

We don't intend to add this enhancement to SAS Viya 3.5. Thank you for the suggestion.

RonAgresta · ‎01-10-2023

As part of a larger SAS initiative to focus market attention on the most comprehensive sets of advanced data and analytics capabilities that SAS delivers, customers will see new offering names on the SAS Viya platform. These name changes will not alter the composition of the offerings and customers can expect uninterrupted access to licensed assets. Starting in January 2023, the names of the following SAS offerings will change: SAS ® Visual Machine Learning will become SAS ® Viya ® SAS ® Visual Data Science will become SAS ® Viya ® Advanced SAS ® Data Science Programming will become SAS ® Viya ® Programming SAS ® Visual Data Science Decisioning will become SAS ® Viya ® Enterprise These new product names will be rolled out in the coming weeks across the SAS website, technical documentation, training materials, SAS Cloud, and various software order fulfillment and download sites. See also Understanding SAS Viya cadences and release numbers

RonAgresta · ‎05-14-2021

Presenter Ron Agresta, SAS Abstract Explore the variety of options available to connect to data sources such as Azure Synapse Analytics, Spark, Cloudera Data Platform on Azure, Google BigQuery, Yellowbrick and many more. Also learn about support for diverse run-time environments, including SAS, Hadoop, Spark, SAS analytics, cloud and data virtualization. Watch the presentation Watch SAS® Connectivity in the Cloud on the SAS Users YouTube channel.

RonAgresta · ‎11-23-2020

Hi - I did a quick review of our support tracks from recent years and I see very few mentions of PostgreSQL PostGIS. One track described how the PostgeSQL driver that we use does not really handle spatial PostGIS data types. Our documentation also does not call out that PostGIS objects are supported. You may be able to access some non-graphical data from the PostGIS extender. I see in one support track that using the MAX_TEXT_LEN connection parameter helped. Ron

RonAgresta · ‎10-02-2020

Can you be more specific about what application or component of SAS Viya you are using when you say you created an ETL? Or have you created a SAS Enterprise Guide job to load data into a CAS table on SAS Viya? Ron

VincentRejany · ‎05-25-2020

Hi Shikha Within SAS DataFlux Data Management Studio, you can create a custom metric to be used within a profile job. Typically for your SSN You can also use regular expressions for checking dates.

RonAgresta · ‎04-14-2020

Hi - this looks like a known issue on some versions of the software. There is a documented workaround that involves clearing user preferences in one of the services in use by the web application. If you contact technical support, they can supply the details you need to correct this issue. Ron

RebeccaG_ · ‎12-02-2019

You might find some helpful information in the Clustering Node topic of the DataFlux Data Management Studio 2.7: User Guide: http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.7/dmpdmsug/dfUnity.html Use the Search function under the Table of Contents to locate the Clustering Node topic.

george7899 · ‎08-23-2019

Thanks Ron. Very excellent answers. All clear now.

RonAgresta · ‎08-01-2019

You would either have to run this job periodically using some change data capture technique to only process data you have not seen or you could create that real-time service I mentioned and see if you can make a web service call from your database (which is not trivial). Where you present your results is up to you. SAS Data Management Studio has a built in dashboard but it is desktop based. If you want to share this information with a broader audience, you could use SAS Visual Analytics or another reporting environment. But in either case for web-based reporting you will need to write database queries to pull data out of the DataFlux repository for consumption in your reporting environment.

Kal_ETL · ‎08-01-2019

Hello, I am on the task to migrate a couple of exiting jobs in Data Management Studio from SAS 9.3 to SAS 9.4 on a Linux environment. These jobs basically clean data for data regarding to address and names and phone numbers on a medium-large data volume, and integrates with another sas codes. Also there is an existing QKB. My experience with Data management studio is poor since I just did long time ago profiling, matching, standarization and very basic tasks in general. Is there a guide where I can find the task that should be done for this, for example for backup it means a spk in data management console or it should be done from data management studio? Do I need backup or create new metadata? I was checking this but not cover an scenario like this, since it seems it cover just from dataflux to data management studio, and not from a data management studio to a higer version of it. Also I am confused with some documentation I saw, maybe you know where I can clarify my doubts. I understand that sas bought dataflux and then rename dataflux server as data management server and dataflux (client) as data management server. But also I see there is a data quality server, so don't understand too much about it. If there is any diagram or reference you can share... Any advice in general will be great.

RonAgresta · ‎06-04-2019

Please contact SAS technical support to ensure you are getting the help you need. Ron

Online Status	Offline
Date Last Visited	7 hours ago