SQL (Structured Query Language) is the most widely used programming language for relational databases worldwide. No other programming language produces more hits for a web search than SQL and interest is growing rapidly. In June 2010, Google showed 135 million hits versus 586 million hits in June 2020. SQL is […]
Why learn SQL? was published on SAS Users.
Date and time values are handled differently when programming in DS2. It can process databases and has access to ANSI data types, which have greater precision.
Tips for working with date, time, and datetime values in DS2 was published on SAS Users.
When speed is required at scale, it’s hard to beat parallel processing data in memory with DS2 and SAS® Viya® with the amazing Cloud Analytic Services (CAS)!
The post Jedi SAS Tricks: Transwarp Processing with DS2 in SAS® Viya® appeared first on SAS …
Finding a pattern like a phone number or national ID number embedded in text can be difficult and time consuming. The traditional DATA step has a family of functions (collectively referred to as PRX functions) that allow using Perl regular expressions …
This SAS Jedi is very excited about the SAS 9.4 M4 release, which brought many wonderful gifts just in time for Christmas. So in the interest of extending the Christmas spirit, I’m going to blog about some of my favorites! I’ve long loved the SAS DO statement variant which allows […]
The post SAS Jedi Christmas – SAS 9.4 M4 DS2 Do Loop Upgrade appeared first on SAS Learning Post.
Maybe programming isn’t quite as dangerous as a lightsaber battle, but if you think using SAS to turn data into action feels a little bit like magic, you should know that nobody is better at harnessing “the Force” of DS2 than SAS Jedi Mark Jordan. Mark has a resume that […]
The post SAS Jedi and DS2 Guru: Mark Jordan appeared first on SAS Learning Post.
A reader posed a question in the comments to an earlier Jedi SAS Trick, asking how to write the results of a DS2 DATA _NULL_ program to a text file. It’s an interesting question, as DS2 currently has no text file handling statements or capabilities. Take, for example, this traditional […]
The post Jedi SAS Tricks: Writing to Text Files from DS2 appeared first on SAS Learning Post.
The journey continues as we hear from the instructors for each of the courses being offered on Thursday and Friday, April 21 and 22 after SAS Global Forum. Next up is Mark Jordan who developed and will teach the Introduction to DS2 and Hadoop course. Why should people get excited […]
The post The road to SAS Global Forum: A training Q&A with the Jedi SAS appeared first on SAS Learning Post.