mf_increment

byAllan|Jul 15, 2022|sasjs-core, macros

Incrementing a Macro Variable

Incrementing a macro variable is fairly straightforward and can be done in several ways, for instance - a do-loop:


SASjs Core
byAllan|Jul 14, 2022|sasjs-core, macros
SASjs Core - Macros for SAS Application Developers
How often have you needed a macro and thought “surely someone has done this before”?
There’s no need to re-invent the wheel!  The SASjs Core library is a collection of 228 (and cou...


Data Controller v5
byAllan|Jul 12, 2022|Data Controller
Version 5 of Data Controller for SAS® is now available!
With some serious updates since v4.0:
🚀 Viya 4 support
🚀 Base SAS support - on SASjs Server
🚀 COLUMN LEVEL SECURITY
This means that Data Controller will now run on A...

`Failed to Transcode Data`

byAllan|Jul 07, 2022|EG, encoding

`Failed to transcode data from U_UTF8_CE to U_LATIN9_CE`


During a recent Data Controller deployment for a Swedish customer we faced the error code below when deploying the backend SAS services to meta...


Retained Keys
byAllan|Dec 29, 2021|ddl, sasjs-core, macros, data-modelling
A Retained Key is an integer used to represent a particular business key in a database table. It is useful in the following scenarios:

Optimising for speed of joins
Enabling business keys with null values
Handling co...

`Login failed due to an error with the security certificate`

byAllan|Aug 25, 2020|Viya


When running the sas-admin CLI tool against a Viya server on https you may get the following response:


Password> Login failed due to an err...

`Dictionary of Dictionaries`

byAllan|Feb 27, 2020|SQL


The SQL procedure contains a lot of metadata information in the special DICTIONARY libref, and I often find myself needing to call select * from dictionary.dictionaries in order to query it.  So to save time I've...

`Cannot POST /SASStoredProcess/do/`

byAllan|Feb 23, 2020|SQL


You might see Cannot POST /SASStoredProcess/do/ when building a SAS Web App on SAS 9.    The reason you see this, is that you have an incorrectly defined URL - either the host / server name is incorrect, or you a...

`Modernising Legacy SAS SCL / AF Applications`

byAllan|Oct 18, 2019|AF/SCL


Before SAS Studio, and even EG (but after display manager), there was a desktop application used exclusively for accessing SAS.  It was known as Base SAS, and within it there was an application development facility known as S...

`ERROR: Expected a comment or processing instruction.`

byAllan|May 04, 2019|SQL


Whilst creating a new macro for the macrocore library (mm_adduser2group) I received in my log:  ERROR: Expected a comment or processing instructi...

« Older EntriesNext Entries »

mf_increment

Incrementing a Macro Variable

SASjs Core

SASjs Core - Macros for SAS Application Developers

Data Controller v5

Version 5 of Data Controller for SAS® is now available!