Post-Jam Notes for DM Community – Feb. 2018

[AnnaBrown]

We had another active SAS Data Management Community Jam yesterday with tons of discussion on several popular and unsolved community topics. SAS experts were so into it, we went over by nearly half an hour. That’s a sign of some good activity! Here are the threads that got our attention:

Load SAS Dataset to MS SQL Server via SQL server job
Quentin, LinusH, SASKiwi, Ksharp, Tom, ACBradley

SAS integration with Spark
Harishankar_90, sandykota, LinusH

Import large csv problem
evgenys, KurtBremser, Reeza, TomKari, Tom,  PGStats, ballardw 

Macro variable in file path
Ujjawal, ballardw, SteveED

Deleting rows in SAS DIS
May15, JBailey, LinusH, mkeintz

HELP - Proc sql error: The following columns were not found in the contributing tables
Vikachu, RW9, stat_sas, Reeza, Patrick

Where is SAS ACCESS to R/3 installed?
CameronLawson, LouGalway_sas

How to extract data for last 1/2 hour?
Halaku, PGStats, Patrick, LinusH, Bill

Simple steps to schedule a SAS job in UNIX (PUTTY) (Created an article on this topic.)
ragivenk189, nissant

How to count how many times value in a table repeated?
jarr25, Astounding, Jaheuk, data_null__, RW9, Reeza

Set numeric missing value as 'NA'
zhouxysherry, Haris, ballardw, David_Luttrell

Export sas7bdat file to csv
ShwetaMishra, JBailey, art297

SAS Pass through connection to hadoop
krishnaram101, JBailey, LinusH

Look out for announcements about future Jams. The next one will be in the late April/early May time frame.