topic Re: Look up cell value using line and column #s in SAS Programming

Look up cell value using line and column #s

sonic_poem — Thu, 20 Jun 2019 18:35:44 GMT

I just received an error message below:

NOTE: Character values have been converted to numeric values at the places given by:(Line):(Column).

72:8

I'm puzzled by this message since the column 8 in my dataset is a gender variable that has no numeric value. I would like to look up the cell value using line and column value provided in the error message. Please help.

Re: Look up cell value using line and column #s

Tom — Thu, 20 Jun 2019 18:42:22 GMT

That is the line number in the SAS LOG and the column number of the statement on that line in the log.

525   data test;
526     set sashelp.class;
527     new=name+1;
528   run;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      527:7

Column 7 is the first letter of the variable NAME on line 527.

Re: Look up cell value using line and column #s

sonic_poem — Thu, 20 Jun 2019 18:56:16 GMT

Got it. Thanks.