topic Re: how to find a range of alphabetic letter and digital number? in SAS Programming

how to find a range of alphabetic letter and digital number?

huizhao26 — Tue, 24 Nov 2020 07:43:46 GMT

How to write a sas statement to find the range of letters and numbers, such as

if var1 = 'A' to 'G' then var2= 1;

if var3 = 1- 20 then var4 =' group1';

thanks.

Re: how to find a range of alphabetic letter and digital number?

andreas_lds — Tue, 24 Nov 2020 07:51:08 GMT

@huizhao26 wrote:

How to write a sas statement to find the range of letters and numbers, such as

if var1 = 'A' to 'G' then var2= 1;

if var3 = 1- 20 then var4 =' group1';

thanks.

For numeric variable you could use

if 1 <= var3 <= 20 then var4 = 'group1'

But using formats is the better way to solve such tasks.

Re: how to find a range of alphabetic letter and digital number?

irena_g — Tue, 24 Nov 2020 11:24:45 GMT

data a;
var1="K";
if rank('A') <= rank(var1)>= rank('G') then var2=1;
run;

Re: how to find a range of alphabetic letter and digital number?

Astounding — Tue, 24 Nov 2020 14:36:38 GMT

When working with character data, there are pitfalls. In the simplest case, you could use:

if ('A' <= var1 <= 'G') then var2 = 1;

However, you have to pay attention to a few issues. Will VAR1 always be in uppercase? Uppercase letters are different than lowercase letters. Will VAR1 always contain a single character? If it contains "George" should that be included or excluded? Here is a more careful version that should be considered:

if ('A' <= upcase(var1) < 'H') then var2 = 1;

But it would be helpful to know something about your data before deciding on a solution.

Re: how to find a range of alphabetic letter and digital number?

huizhao26 — Tue, 24 Nov 2020 23:58:11 GMT

Thanks!

Re: how to find a range of alphabetic letter and digital number?

huizhao26 — Tue, 24 Nov 2020 23:58:43 GMT

Thanks!