Embedding any code anywhere into SAS programs
Lenetek » SAS Blog
by
11M ago
This article introduces SAS macro function %embed( ) allowing to inject into SAS programs native DBMS SQL queries from external files. It also demonstrates how to embed other languages' code (Python, R, Lua) from external files into SAS code ..read more
Visit website
Introducing TRIMS function to remove any leading and/or trailing characters from SAS strings
Lenetek » SAS Blog
by
1y ago
This article introduces and implements multipurpose TRIMS function that removes any leading, trailing or both leading and trailing characters from SAS strings ..read more
Visit website
SAS open-source treasures from around the world: SASjs
Lenetek » SAS Blog
by
1y ago
This is an introduction to SASjs - a collection of tools aimed at enabling and accelerating development and operations (DevOps) for a broad range of SAS applications, including SAS web development ..read more
Visit website
Calculating the overlap of date/time intervals
Lenetek » SAS Blog
by
1y ago
This article describes and discusses pros and cons of 3 different algorithms and SAS code implementations to calculate length of overlap of date/time intervals and integer intervals in general ..read more
Visit website
Automating Excel workbooks creation using SAS
Lenetek » SAS Blog
by
1y ago
This article demonstrates how to automate and improve a sometimes onerous hands-on process of creating Excel workbooks. Also shows how to enhance your Excel views with font and background colors as well as frozen headers ..read more
Visit website
Introducing TRIMS function to remove any leading and/or trailing characters from SAS strings
Lenetek » SAS Blog
by
1y ago
This article introduces and implements multipurpose TRIMS function that removes any leading, trailing or both leading and trailing characters from SAS strings ..read more
Visit website
Calculating circle areas and sphere volumes without π
Lenetek » SAS Blog
by
1y ago
For Pi Day, Leonid Batkhan offers a contrarian view on areas and volumes calculations proposing their pi-less formulae. The key here is what units to use for measuring areas and volumes - square and cubic units or else ..read more
Visit website
SAS open-source treasures from around the world: SASjs
Lenetek » SAS Blog
by
1y ago
This is an introduction to SASjs - a collection of tools aimed at enabling and accelerating development and operations (DevOps) for a broad range of SAS applications, including SAS web development ..read more
Visit website
Splitting a data table into multiple sheets of an Excel workbook
Lenetek » SAS Blog
by
1y ago
This article demonstrates how to programmatically split a data table into multiple Excel spreadsheets (tabs) in a single workbook. Tabs are color-coded and properly labeled ..read more
Visit website
Calculating the overlap of date/time intervals
Lenetek » SAS Blog
by
1y ago
This article describes and discusses pros and cons of 3 different algorithms and SAS code implementations to calculate length of overlap of date/time intervals and integer intervals in general ..read more
Visit website

Follow Lenetek » SAS Blog on FeedSpot

Continue with Google
Continue with Apple
OR