Past Meetup

Develop your programs with local SAS and port to production server SAS

This Meetup is past

25 people went

Location image of event venue

Details

Title. Develop your programs with local SAS and port to production server SAS using SAS connect'
Author. Roger DEANGELIS
====
Title. Dictionary.coumns is your friend while appending or moving data
Author. Kiran Venna
ABSTRACT
Dictionary.columns is a dictionary table, which gives metadata information of columns. Dictionary.columns is very helpful in understanding various data related issues. Data integrity issues,
while appending data from external files to SAS® Datasets can be understood with help of Dictionary.columns. Appropriate appending of external files to SAS Datasets can be done with help of SAS Macros. Data movement from Hive® to Teradata® by using SAS can cause an issue when variable name length is greater than 32. Longer variable name issues can be evaluated with the aid of Dictionary.columns. Proc FEDSQL can solve variable names length issue. While inserting data from SAS to RDBMS, difference in number of columns can cause an issue and this issue can be analyzed and fixed with help of dictionary.columns.
====
Title: Becoming a Data Scientist with a non-computer programming background.
Author: Richard Boire
Description:
In this session, I will discuss my journey in how I was able to become a data scientist without any prior technical skills in terms of computer programming and data. I will explore the key steps that I took to gain the req lAs an MBA, I will discuss how I was able to use.
====
Title. Building a Muscular Vocabulary in SAS® functions
Authors: Mamadou Dakouo
Description:
SAS® has over 456 functions, which help in analyzing and processing data. SAS® functions can be used in both DATA and PROC step programming statements, in macro language statements, and in Structured
Query Language (SQL). SAS® functions perform a computation or manipulation and return a value. Those functions are classified as character functions (over 95), date and time functions (over 35), descriptive statistics (over 31), probability functions (over 18), macro functions (over 39), special functions (over 24), etc. Functions such as CAT, CATQ, CATS, CATT, CATX or TRANSTRN, TRANSLATE, TRANWRD, or INTCK and INTNX, just to name a few, are close but still have small but important difference between them. Recognizing the nuances that set these functions apart is a distinct advantage and should greatly help increase proficiency as a SAS® user. This presentation will help with building a muscular vocabulary utilizing SAS® functions and assist in identifying which of those best suit your needs.