topic Re: Number Format leading Numbers in SAS Programming

Number Format leading Numbers

anonymous_user — Wed, 02 Aug 2017 13:26:53 GMT

Hi, I am importing an excel spreadhseet with around 5000 mortgage numbers. Some numbers are only 7 numbers in length so for those accounts I need to add a leading zero. The code used below, any idea why I get the error message here please?

17 mortgage=put(_mortgage,z10.);
____
484
NOTE 484-185: Format $Z was not found or could not be loaded.

CODE WRITTEN BELOW

data MIRA_RED_ACCOUNTS_2016;
infile "/opt/sas/data/uk/Personal Folders/Scants/MIRA Red Accounts2016.csv";
input mortgage : $10.;
run;

data mira;
set WORK.MIRA_RED_ACCOUNTS_2016 (rename=(mortgage=_mortgage));
mortgage=put(_mortgage,z10.);
run;

Re: Number Format leading Numbers

art297 — Wed, 02 Aug 2017 13:32:48 GMT

The Z. format only works with numeric fields so you first have to convert it. e.g.:

data MIRA_RED_ACCOUNTS_2016;
  input mortgage : $10.;
  cards;
123
4567
;

data mira;
  set WORK.MIRA_RED_ACCOUNTS_2016 (rename=(mortgage=_mortgage));
  mortgage=put(input(_mortgage,10.),z10.);
run;

Art, CEO, AnalystFinder.com

Re: Number Format leading Numbers

Astounding — Wed, 02 Aug 2017 13:43:46 GMT

You have one dollar sign too many:

input mortgage : $10.;

Get rid of the dollar sign to create MORTGAGE originally as a numeric variable. Your final DATA step will convert it to character.

Re: Number Format leading Numbers

anonymous_user — Wed, 02 Aug 2017 13:46:39 GMT

if I remove the $ from input mortgage : $10.; then all I see is a dot for my mortgage?

Re: Number Format leading Numbers

AlanC — Wed, 02 Aug 2017 13:50:17 GMT

Consider using an ATTRIB statement:

data MIRA_RED_ACCOUNTS_2016;
attrib mortgage format=z10. ;
input mortgage : 10.;
cards;
123
4567
;
run;

I rarely have a data step w/o an attrib. Define the variables for the data step before creating them so your final dataset is exactly as you want.

Re: Number Format leading Numbers

Astounding — Wed, 02 Aug 2017 14:16:18 GMT

If you are getting . for the mortgage values, it indicates that there are other characters (non-numeric) present. To overcome that, leave the $ in place and try:

len = length(mortgage);

if len < 10 then mortgage = repeat('0', 9-len) || mortgage;

Re: Number Format leading Numbers

art297 — Wed, 02 Aug 2017 14:24:44 GMT

Given the problem you are confronting It would help if you attach a representative sample dataset.

Art, CEO, AnalystFinder.com