GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → yabwon → SAS_PACKAGES

yabwon / SAS_PACKAGES

Licence: MIT license
[PRODUCTION READY] - SAS Packages Framework and Repository

Programming Languages

SAS
37 projects

Labels

frameworksas-packagessaspackagesframework

SAS_PACKAGES - a SAS Packages Framework

Intro:

A SAS package is an automatically generated, single, stand alone zip file containing organised and ordered code structures, created by the developer and extended with additional automatically generated "driving" files (i.e. description, metadata, load, unload, and help files).

The purpose of a package is to be a simple, and easy to access, code sharing medium, which will allow: on the one hand, to separate the code complex dependencies created by the developer from the user experience with the final product and, on the other hand, reduce developer's and user's unnecessary frustration related to a remote deployment process.

In this repository we are presenting the SAS Packages Framework which allows to develop and use SAS packages.

Current version:

The latest version of SPF is 20230207.

To get started with SAS Packages try this Getting Started with SAS Packages presentation (see the ./SPF/Documentation directory).

The documentation and more advance reading would be the SAS(r) packages - the way to share (a how to)- Paper 4725-2020 - extended.pdf article (see the ./SPF/Documentation directory).

Short description of the SAS Packages Framework macros can be found here

Recordings and Presentations:

Videos presenting the SPF and packages, from various conferences and meetups (the newer the better):

Initiative to add SAS Packages Framework to SAS Base/Viya:

A SASware Ballot Idea for adding SAS Packages Framework macros into Base SAS and Viya was submitted Friday, May 27th 2022. If you would like to support the idea visit this communities.sas.com post and up vote the idea!

The User:

The first step to use a package with the SAS Packages Framework:

  • Create a folder for your packages, under Windows OS family e.g., C:/SAS_PACKAGES or under Linux/UNIX OS family e.g., /home/<username>/SAS_PACKAGES.

and then either:

  • Manually download the SPFinit.sas file (the SAS Packages Framework) into the local packages folder.
  • [Optional] Manually download the <packageName>.zip file into the local packages folder.
  • and Execute:
filename packages "<directory/containing/packages/>";         /* setup directory for packages */
%include packages(SPFinit.sas);                               /* enable the framework */

/* %installPackage(packageName) */                            /* install the package, unless you downloaded it manually */

%helpPackage(packageName)                                     /* get help about the package */
%loadPackage(packageName)                                     /* load the package content into the SAS session */

or if you need it just for "one time" only:

  • Execute:
filename packages "%sysfunc(pathname(work))"; /* setup WORK as temporary directory for packages */
filename SPFinit url "https://raw.githubusercontent.com/yabwon/SAS_PACKAGES/main/SPF/SPFinit.sas";
%include SPFinit; /* enable the framework */

%installPackage(packageName) /* install a package */
%helpPackage(packageName)    /* get help about the package */
%loadPackage(packageName)    /* load the package content into the SAS session */

or do it pragmatically:

  • Enable the framework [first time only]:
filename SPFinit url "https://raw.githubusercontent.com/yabwon/SAS_PACKAGES/main/SPF/SPFinit.sas";
%include SPFinit; /* enable the framework */
  • Install the framework on your machine in the folder you created:
filename packages "<directory/containing/packages/>"; 
%installPackage(SPFinit) /* install the framework */
  • And from now on run it like this:
filename packages "<directory/containing/packages/>";
%include packages(SPFinit.sas);

%installPackage(packageName) /* install a package */
%helpPackage(packageName)    /* get help about the package */
%loadPackage(packageName)    /* load the package content into the SAS session */

The "Workshop video for the User" got outdated (in general). Newer version is comming soon, in the mean time see some of the vedeos from the "Recordings and Presentations" section above. (You can watch the workshop if you wish, link is working and some parts are still valid source of information e.g., "ICE loading" or "disk loading")

Workshop video for the User [May 6th, 2020] [~86 minutes, outdated (installPackage macro was not there yet) but gives the idea how it works especially load, help, unload, ICEload, and other details]

The Developer:

To create your own package:

The SAS Packages Framework (short) documetation to quickly see macros options and parametera.

If you have any questions, suggestions, or ideas do not hesitate to contact me!

Updates worth mentioning:

Update[February 7th, 2023]: ADDCNT ** type for additional content feature and ** %loadPackageAddCnt() macro added to the framework. (see here).

Update[December 12th, 2022]: CASLUDF ** type for CASL user defined functions added to the framework. Utility macros for for loading content in proc IML and proc CAS added. (see here)**.

Update[November 21st, 2022]: %loadPackage() macro allows Cherry Picking of content (see here).

Update[September 30th, 2022]: New dedicated repository: SASPAC - the SAS Packages Archive is available as new location for packages storage. Location of SASPAC is: https://github.com/SASPAC

Update[November 11th, 2021]: %extendPackagesFileref() macro is available.

Update[October 15th, 2020]: %previewPackage() macro is available.

Update[September 11th, 2020]: %loadPackageS() and %verifyPackage() macros are available.

Update[July 30th, 2020]: All components of SAS Packages Framework are now in one file SPFinit.sas (located in the ./SPF directory). Documentation moved to ./SPF/Documentation directory. Packages zip files moved to ./packages directory.

Update[June 10th, 2020]: To see help info about framework macros and their parameters just run: %generatePackage(), %installPackage(), %helpPackage(), %loadPackage(), and %unloadPackage() with empty parameter list.

Update[June 3rd, 2020]: %installPackage() macro is available. The %installPackage() macro is embedded in the loadpackage.sas part of the framework.

Where the SAS Packages Framework is used:

This is a list of locations where the SAS Packages Framework is used:

  • Warsaw (Poland)

If you want to share that you are using the SPF let me know and I'll update the list.

If you find the SPF useful share info about it or give it a star so more people will know.

Available packages:

(!) For "backward compatibility"/historical point of view the following packages are available under the ./packages directory.

(!) Since September 2022 the default location for packages is SASPAC - the SAS Packages Archive located under: https://github.com/SASPAC where each package is stored as a separate repository with historical versions too.

Packages:

  • SQLinDS[2.2.5], 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 * from sashelp.class order by age);
  run;

SHA256 digest for SQLinDS: F*229ACF1A62E5194A25C75D8E554BEF1B7D29227A498ED5862F23892BB0D57644

Documentation for SQLinDS

SQLinDS in SASPAC

  • DFA (Dynamic Function Arrays)[0.5.4], contains set of macros and FCMP functions which implement: a dynamically allocated array, a stack, a fifo queue, an ordered stack, and a priority queue, run %helpPackage(DFA,createDFArray) to find examples.

SHA256 digest for DFA: 6DEB02BE1C30453FBC688AF1F561709C7D6BF10B3B67988B238853A2A9D53034

Documentation for DFA

DFA in SASPAC

  • macroArray[1.0.4], implementation of an array concept in a macrolanguage, e.g.
  %array(ABC[17] (111:127), macarray=Y); 
  
  %macro test();
    %do i = 1 %to 17; 
      %put &i.) %ABC(&i.); 
    %end;
  %mend;
  %test() 
  
  %let %ABC(13,i) = 99999; /* i = insert */

  %do_over(ABC, phrase=%nrstr( 
      %put &_i_.%) %ABC(&_i_.); 
      ),
      which = 1:H:2
  );

SHA256 digest for macroArray: 8584C249C308B5E8B620ED5F695BC58CD426172FB2EACD5FF9C6899F9DE2B470

Documentation for macroArray

MacroArray in SASPAC

  • BasePlus[1.18.4] adds a bunch of functionalities I am missing in BASE SAS, such as:
call arrMissToRight(myArray); 
call arrFillMiss(17, myArray); 
call arrFill(42, myArray); 

rc = delDataset("DataSetToDrop"); 

string = catXFn("date9.", "#", myArray);

format x bool.;

%put %getVars(sashelp.class, pattern = ght$, sep = +, varRange = _numeric_);

%rainCloudPlot(sashelp.cars,DriveTrain,Invoice)

%zipLibrary(sashelp,libOut=work)

%bpPIPE(ls -la ~/)

SHA256 digest for BasePlus: A6F1977DC4EC22A39DDC7BCE68CF562AF54351A3D385D488EC3067B5A7C0F3CB

Documentation for BasePlus

BasePlus in SASPAC

  • GSM (Generate Secure Macros)[0.20.4], package allows to create secured macros stored in SAS Proc FCMP functions. The dataset with functions can be shared between different operating systems and allows to generate macros on site without showing their code.

SHA256 digest for GSM: 83EC349DF97EFA71187536E8CC6CD62215CE675D20DA355E14D4ACE3FBC6D524

Documentation for GSM

GSM in SASPAC

  • dynMacroArray[0.2.4], set of macros (wrappers for a hash table) emulating dynamic array in the data step (macro predecessor of DFA). Development of this package is currently on hold.

SHA256 digest for dynMacroArray: 7800F36877DC0B9A94B1AC8FFDF8B43ADB216F11B5B26343E41165E7F5E32FC0

======

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].