topic Re: Add leading 0 to census tract value (character var) in SAS Programming

Add leading 0 to census tract value (character var)

wernie — Mon, 24 Feb 2020 19:47:17 GMT

I have a dataset that has census tract fips codes, but the leading 0 is getting cut off. I was able to put a leading 0 in front of the county fips code using substr and length, but the same thing is not working for census tract. I keep getting errors.

Basically, I have ct fips that look like this:

1001020100

1001020200

24006840030

24007850040

And I want it to look like this (notice that the last two remain the same as they already have 11 digits);

01001020100

01001020200

24006840030

24007850040

I want to leave these as character variables. In the code, I put

data want;

set have;

ct = substr(ctfips, length(ctfips)-10, 11);

drop ctfips;

rename ct = ctfips;

run;

Not sure if that's what I need to be doing, but it's not giving the leading zero for a total length of 11. Thanks!

Re: Add leading 0 to census tract value (character var)

Krueger — Mon, 24 Feb 2020 19:50:45 GMT

Modified previous solution to fit what you are doing. https://communities.sas.com/t5/SAS-Procedures/how-to-pad-character-variable-with-leading-zeroes/td-p/40486

data test;
    length charvar $ 11 padded $ 11;
    infile datalines;
    input charvar;
    /* read charvar as number, then format with leading zeroes */
    /* then put result into padded */
    padded = put(input(charvar,best11.),z11.);
datalines;
1001020100
1001020200
24006840030
24007850040
;
run;

Re: Add leading 0 to census tract value (character var)

Reeza — Mon, 24 Feb 2020 19:51:19 GMT

Where exactly in that code do you think you're adding a leading zero?

Re: Add leading 0 to census tract value (character var)

novinosrin — Mon, 24 Feb 2020 20:11:44 GMT

Hi @wernie The great Xia Keshan @Ksharp answered this a while ago


data have;
input str $11.;
cards;
1001020100
1001020200
24006840030
24007850040
;

data want;
 set have;
 length want $11;
 want=translate(right(str),'0',' ');
run;

Re: Add leading 0 to census tract value (character var)

Reeza — Mon, 24 Feb 2020 20:27:47 GMT

Just a quick note that if you want to save the results to the same variable the length statement needs to be before the SET statement. If you're creating a new variable this is not an issue.

Re: Add leading 0 to census tract value (character var)

novinosrin — Mon, 24 Feb 2020 20:36:46 GMT

Oh yes indeed. Honestly, I didn't pay attention to whether the OP wants the same input variable value to be modified rather than a new assignment. Very good and important point

Re: Add leading 0 to census tract value (character var)

Tom — Mon, 24 Feb 2020 20:47:02 GMT

If the values can actually be converted to integers then you can use the Z format to convert it back with leading zeros. So use INPUT() to convert to a number and PUT() to convert back to string.

ctfips = put(input(ctfips,11.),Z11.);

Now if the values either contain non-digit characters, or there are more than 15 characters then you will want to use character operations instead. Such as moving the spaces to the front and replacing them with zeros.

ctfips = translate(right(substr(ctfips,1,11)),'0',' ');

Or prefixing zeros.

if length(ctfips) < 11 then ctfips = repeat('0',11-length(ctfips)-1)||ctfips;

ctfips = reverse(substr(reverse(cats(repeat('0',11-1),ctfips)),1,11));