Some readers read the article “how-to-evaluate-sas-expression-in-data-step-dynamically” and wonder if there is a same mechanism or functionality in DS2. As indicated in that article, SAS provides similar features in DATA step, PROC CAS and PROC Python, but some projects like ESP (Event Stream Processing) projects would store those expression definition in
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
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.
La demanda de datos de datos en México va al alza. Las razones son numerosas, pero podemos destacar entre las principales, las siguientes, las empresas, los sectores productivos, el crecimiento exponencial de los datos, y la necesidad de profundizar en ellos para obtener información y conocimientos que soporten la toma
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)!
Finding a pattern like a phone number or national ID number embedded in text can be difficult and time consuming.
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
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
Kto słyszał o SAS LASR Server? Pewnie wielu, bo w ofercie SAS jest on dostępny od kilku lat i jest jednym z głównych składników np. Visual Analytics. A kto słyszał o PROC IMSTAT? Tutaj odpowiedzi twierdzących będzie zapewne znacznie mniej. A kto napisał własny kod wykorzystując PROC IMSTAT? Moim zdaniem,
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 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
Update 02Dec2016: Beginning with SAS 9.4 Maintenance 4, there is now a JSON libname engine. Read this new article to learn more -- you might prefer it to using DS2 for this task! Thanks to the proliferation of cloud services and REST-based APIs, SAS users have been making use of
I'm gearing up to teach the next "DS2 Programming Essentials with Hadoop" class, and thinking about Warp Speed DATA Steps with DS2 where I first demonstrated parallel processing using threads in base SAS. But how about DATA step processing at maximum warp? For that, we'll need a massively parallel processing
While perusing the SAS 9.4 DS2 documentation, I ran across the section on the HTTP package. This intrigued me because, as DS2 has no text file handling statements I assumed all hope of leveraging Internet-based APIs was lost. But even a Jedi is wrong now and then! And what better
I've been a busy Jedi the last few months and have spent the bulk of my non-teaching days learning new Jedi SAS tricks to share with you. The finishing touches are going on to our brand-new, one and a half day DS2 Programming: Essentials class. It's rolling out on December 16
