topic Re: What is this strange “numeric” to “numeric” explicit conversion? in SAS Procedures

What is this strange “numeric” to “numeric” explicit conversion?

Mirisage — Thu, 09 Jan 2014 20:41:41 GMT

Hi Forum,

I was reviewing a code written by another coder where I found a statement highlighted by blue colour which looks strange (at least for me) but SAS does not complains.

data tt;

set t;

……..

…….

Id_No=input(ID,12.);

…………………

……………..

run;

“ID” is a numeric variable.

After I have run the code, the new variable “Id_No” is created which is also a numeric variable.

No complains in the log.

What I have learned from the SAS class about explicit conversion is this.

Numeric to character conversion =put(Nvar, numeric format)

Character to numeric conversion = input(Cvar, numeric informat)

So, how could numeric to numeric happens like above?

Your help is appreciated.

Miris

Re: What is this strange “numeric” to “numeric” explicit conversion?

Quentin — Thu, 09 Jan 2014 20:55:29 GMT

Hi,

Are you sure there are no complaints in the log?

Below step is like yours. As you say, the INPUT() function expects a character argument. SAS converts the numeric ID value to a character value (implicit coversion causing the NOTE: ), and then reads that character value.

29   data a;
30     id=1;
31     id_no=input(id,12.);
32   run;

NOTE: Numeric values have been converted to character values at the places given by:
      (Line):(Column).
      31:15
NOTE: The data set WORK.A has 1 observations and 2 variables

Re: What is this strange “numeric” to “numeric” explicit conversion?

CTorres — Thu, 09 Jan 2014 20:58:09 GMT

Are you sure ID is a numeric variable?

Acording to the documentation the Input Function expects a character argument. See SAS(R) 9.3 Functions and CALL Routines: Reference

Re: What is this strange “numeric” to “numeric” explicit conversion?

data_null__ — Thu, 09 Jan 2014 21:00:02 GMT

When I do it it does complain. So you are not telling the whole story.

18         data _null_;
19            id = 1; 
20            Id_No=input(ID,12.);
21            run;

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      20:16   

Re: What is this strange “numeric” to “numeric” explicit conversion?

PGStats — Thu, 09 Jan 2014 21:17:08 GMT

... Unless you have used OPTIONS NONOTES;

Re: What is this strange “numeric” to “numeric” explicit conversion?

cwcaulkins — Thu, 09 Jan 2014 21:37:16 GMT

I never would have found that "little" option on my own - thanks, PG!

Re: What is this strange “numeric” to “numeric” explicit conversion?

data_null__ — Thu, 09 Jan 2014 21:41:01 GMT

It's handy when you want to render the LOG useless. Or if you're programming for job security.