Video: How to add leading zeros to a SAS value

AnnaBrown — Tue, 06 Aug 2019 18:10:25 GMT

Hi Community,

A common question asked here is how to add leading zeros to a SAS value. SAS' Peter Styliadis, explains the process in this tutorial.

Re: Video: How to add leading zeros to a SAS value

LaurieF — Wed, 07 Aug 2019 02:12:27 GMT

Want to add on something really stupid? This is from the days before %sysfunc, putn and the z format...

%let j = %substr(000&j, %length(&j), 4);

For values of j up to 9999, right-justify and zero-fill j. Want longer numbers? Add zeros, and change the last parameter.

I used this construct for years, but the documentation was usually fairly thorough.