Hello Team, I am trying to find the actual length in proc sql for numeric data, but the length value is not coming as exptected, but in data step the length is coming correctly with function VVALUE/VVALUEX , is any way to use the same in proc sql. The formated numric value is : 72.00 , i need lenght as for this value as '5' , but the same value is not worknig in proc sql , working on data step. Apology for capturing the data in screenshots My output Results with proc sql: Not coming as expected with next data step below. Proc sql notprint;
create table length_ds as
select EGSTRESN, length(strip(put(EGSTRESN,best32.))) as var_length
from saslib.eg(where=(not missing(EGSTRESN));
quit; Data step results as below; data length_ds;
set saslib.eg(where=(not missing(EGSTRESN));;
var1 = vvalue(EGSTRESN);
var_length = length(strip(put(var,best.)));
keep var1 var_length EGSTRESN;
run; Thakn you, Raj.
... View more
