topic Re: How to find length in SAS Programming

How to find length

venunaidu — Mon, 17 Oct 2022 05:30:24 GMT

data ds;

infile datelines;

input num;

cards;

1234567891

12345678901

run;

in above data I have observation length 10 but when I am use if condition not work .

like ex:

data ds2 ds3;

set ds;

if length(num) eq 10 then output ds2;

else output ds3;

run;

above data if condition not work anyone can explain me , above data by default length take best12.

how to find exact length .

Re: How to find length

japelin — Mon, 17 Oct 2022 05:51:09 GMT

Since the num variable in the ds data set is a numeric variable, the length of a string cannot be obtained.
If it is treated as a character variable, the length can be obtained as follows.

data ds;
length num $20;
input num $;
cards;
1234567891
12345678901
run;

data _null_;
  set ds;
  len=length(num);
  put len=;
run;

Or, if you want to treat them as numbers, you can convert them to charactors.

data ds;
input num;
cards;
1234567891
12345678901
run;

data _null_;
  set ds;
  len=length(strip(put(num,best12.)));
  put len=;
run;

Re: How to find length

Patrick — Mon, 17 Oct 2022 05:50:04 GMT

Your variable NUM is of type NUMERIC.

Length() is a string function that requires variables of type CHARACTER.

If you want to know for a numerical variable how many digits an integer has then below one way to get there.

data test;
  set ds;
  l=length(put(int(num),f16. -l));
run;

Re: How to find length

venunaidu — Mon, 17 Oct 2022 09:16:34 GMT

Thank u so much for helping

Re: How to find length

Ksharp — Mon, 17 Oct 2022 12:29:42 GMT

data ds2 ds3;
set ds; 
if int(log10(num))+1 eq 10 then output ds2;
else output ds3;
run;