topic Re: ERROR: Numeric format Z in PUT function requires a numeric argument in SAS Programming

ERROR: Numeric format Z in PUT function requires a numeric argument

dhruvakumar — Thu, 27 Aug 2020 17:32:36 GMT

Hi Dears,

im getting below error in SAS DI, please can you help to resolve this issue.

case

when INPUT(SUBSTR(PUT(DBLNSIA ,Z6.),3,4) || SUBSTR(PUT(DBLNSIA ,Z6.),1,2) || '01',11.) = 0 then -1

else INPUT(SUBSTR(PUT(DBLNSIA ,Z6.),3,4) || SUBSTR(PUT(DBLNSIA ,Z6.),1,2) || '01',11.)

end

Line 593: ERROR: Numeric format Z in PUT function requires a numeric argument.

ERROR: Numeric format Z in PUT function requires a numeric argument.

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

PaigeMiller — Thu, 27 Aug 2020 17:38:31 GMT

Variable DBLNSIA is not numeric, so you can't convert it to character using the PUT statement with the Z6. format. Z6. can only work on numeric variables.

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

dhruvakumar — Thu, 27 Aug 2020 17:42:11 GMT

HI Thanks for reply. May I know what can I use there please

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

ballardw — Thu, 27 Aug 2020 19:26:21 GMT

@dhruvakumar wrote:

HI Thanks for reply. May I know what can I use there please

Kind of need to know what the values of DBLNSIA look like and what you expect for a result.

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

PaigeMiller — Thu, 27 Aug 2020 19:59:51 GMT

@dhruvakumar wrote:

HI Thanks for reply. May I know what can I use there please

Important debugging tool ... look at variable DBLNSIA and see if it is numeric or character, and look at the values of DBLNSIA. Do they look like numbers, or do some of them have non-numeric characters? What do you see?

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

Kurt_Bremser — Thu, 27 Aug 2020 20:03:28 GMT

when INPUT(
  SUBSTR(PUT(DBLNSIA ,Z6.),3,4) ||
  SUBSTR(PUT(DBLNSIA ,Z6.),1,2) ||
  '01',
11.) = 0 then -1

No matter what, you build a string that ends in a 1, and input that; this number can never be zero, so this part of the code makes absolutely no sense.

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

dhruvakumar — Fri, 28 Aug 2020 09:48:51 GMT

##- Please type your reply above this line. No attachments.
character

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

ballardw — Fri, 28 Aug 2020 15:32:02 GMT

@dhruvakumar wrote:
##- Please type your reply above this line. No attachments.
character

42 ?!?

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

PaigeMiller — Fri, 28 Aug 2020 16:01:49 GMT

@dhruvakumar wrote:
##- Please type your reply above this line. No attachments.
character

So you are trying to use the Z. format on a character variable. This cannot be done. You cannot convert a character variable using the Z. format.

So please explain in words (not SAS code), and give an example or two or three, of what these character variables look like and what you want to convert them into.

Re: ERROR: Numeric format Z in PUT function requires a numeric argument

ballardw — Fri, 11 Sep 2020 16:13:27 GMT

@dhruvakumar

You may be having a difficulty understanding what a variable type is. SAS supports two basic types of variables, numeric, that hold values used for arithmetic, and character, that hold text.

Sometimes character values look like numbers. These cannot use a numeric type of format.

The error message says that is what you have attempted to do.

Two examples of using the Z format. One correct:

data example1;
  /* this a numeric value*/
   x= 3;
   y=put(x,z4.);
run;

one incorrect:

data example2;
  /* this a character value*/
   x= "3";
   y=put(x,z4.);
run;

Running the Example2 code will have a log like:

69   data example2;
70     /* this a character value*/
71      x= "3";
72      y=put(x,z4.);
                ---
                484
NOTE 484-185: Format $Z was not found or could not be loaded.

73   run;

The note about format $Z is because only character formats, whose names will start with $, are allowed with character variables.

In other places, like your case statement that may become an error because of different syntax rules.

There may well be a way to make things work as you need but you have not provided 1) any actual examples of the values of your variable or 2) what the expected output for those given values would be.