SAS Global Forum 2016 just ended, but we are already looking ahead to 2017. We are in the planning stages for papers and presentations and would like your input. What topics would you like to see covered next year? Please be as specific as possible. This conference is for YOU, so we want to ensure the presentations hit the mark.
Ooh - Data management - one of my favourite topics 🙂
I would love to see (all topics using Base SAS - i don't have access to any of the SAS Data Management products :-))
how to use Powershell with a locally installed version of SAS 9.4 (either through EG or Base SAS) to extract, manage and manipulate data;
creating a data dictionary for a SQL Server database - including number of rows, number of missing values per variable, datatype, min / max values, etc. for a database that has an unknown number of tables / views;
handling missing values for different types of datasets (longitudingal, survey, demographic, etc....).
Thanks for your time and let me know if you need any further information!!
Chris
Hello DarthPathos,
Thanks for sharing your ideas for data management topics. I'll be sure to forward your suggestions to the folks organizing SAS Global Forum 2017.
Regards,
Laura
Hi Laura,
Hot topics for me are
Thanks,
SASKiwi
Hi DarthPathos, SASKiwi and LinusH,
Now that content is available on the SAS Global Forum 2017 web site, I’ve pulled out some sessions that relate to topics that interest you. Thanks again for outlining these areas!
Below are your topic ideas followed by related sessions at the event. Note that the Super Demo schedule is not yet available. If you’re not able to attend the conference this year, these links will update with the actual papers as they become available.
DarthPathos:
I would love to see (all topics using Base SAS - i don't have access to any of the SAS Data Management products :-))
how to use Powershell with a locally installed version of SAS 9.4 (either through EG or Base SAS) to extract, manage and manipulate data;
creating a data dictionary for a SQL Server database - including number of rows, number of missing values per variable, datatype, min / max values, etc. for a database that has an unknown number of tables / views; handling missing values for different types of datasets (longitudingal, survey, demographic, etc....).
SASKiwi:
Any plans SAS may have to improve accessing of external database names, table names, column names longer than 32 characters - this is a significant source of frustration.
Any plans or ways to encrypt in-flight data between external RDBMSs and SAS - this seems to be a gap in SAS's security model.
Connecting to external databases using connection strings to minimise the need to configure outside of SAS such as in the ODBC Administrator and Oracle TNSNAMES.ORA files - I know this is possible for some databases but it is not explained in a holistic way in any support documents I'm aware of.
Techniques for improving the reading and writing performance of data between SAS and external databases, both basic and advanced.
LinusH:
I think much of future questions spells Viya. So what data management products is/will be implemented in Viya and how?
Also, what is the future on ETL? Will DI Studio be migrated to Viya? SAS/CONNECT couldn't possibly be the final solution...hope not...
Tightly coupled is the topic about meta data, will Viya provide a more integrated meta data then todays quite fragmented model?
And What is SAS take on the growing market on mapping tools? I think integration with some/any of these is crucial if SAS still wish to be a player on the ETL/DW market.
And to add to @SASKiwi list about databases if there any plans to integrate more attributes through SAS/ACCESS, like labels and other extended attributes?
Yet another topic, Hadoop integration.
There are several option today on data storage. Each of them more or less detailed described in the documentation. Bit it would be nice with a prez where these options are compared. Like performance, ease of setup and maintenance, functionality, possibly relationship with other SAS products/functionality. The ones I can think from the top of of my head:
-Hive (and other Hadoop relational storage engines)
-SPDE
-SPD Server
-SASHDAT
-....
Hive (and may be others?) offers different physical file formats. Perhaps a comparison of these could be interesting from a SAS/DW point of view.
O:o thanks lauralawtown
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.