mirror of
https://github.com/SASPAC/sqlinds.git
synced 2026-06-08 10:50:21 +00:00
Bart Jablonski
eedef6b845
The SQLinDS package [ver. 2.4.0] You can use Proc SQL to populate hash table. Call to `%SQL()` has to be in double-quotes. - File SHA256: `F*A3DC9400DEF1403DC9E191611790244A8B0FB23303D3A98D29777E46A1D4E8B4` for this version - Content SHA256: `C*4A49F365C4EF8C5523393FDC1E11C344B023F449B3F1759BA27CFC6C1293A499` for this version
SQLinDS - SQL queries in Data Step
The SQLinDS package is based on Mike Rhoads' article Use the Full Power of SAS in Your Function-Style Macros.
The package allows to write SQL queries in the data step, e.g.
data class;
set %SQL(select name, age from sashelp.class order by age);
run;
SHA256 digest for the latest version of SQLinDS: F*A3DC9400DEF1403DC9E191611790244A8B0FB23303D3A98D29777E46A1D4E8B4
Recording form SAS Innovate 2026 Users Day: "SQLinDS and evExpress SAS packages - a tribute to SAS rock-stars!" (April 27th 2026, ~30 minutes)
To work with a package use the SAS Packages Framework.