topic Re: Outputting variable value in SAS Programming

Outputting variable value

RandyStan — Wed, 04 Nov 2020 04:21:14 GMT

I want to output a variable with a value greater than BOT

Var_A

120

130

BOT

123

BOT 67 2

BOT 5 7

BOT

MAN

I want to extract those values of the variable greater than BOT

So the output I need is

BOT 67 2

BOT 5 7

Thanks in advance

Re: Outputting variable value

mkeintz — Wed, 04 Nov 2020 13:50:12 GMT

You say that you "want to extract those values of the variable greater than BOT". But as far as I can tell you merely want the lines of data in which the value of the variable VARA is the word "BOT" followed by some non-blank value. In lexicographic ordering I guess that does qualify as "greater than". If so, then:

data have;
input var_a $10.;
datalines;
120
130
BOT
123
BOT 67 2
BOT 5 7
BOT
MAN
run;
data want;
  set have;
  where var_a =: 'BOT';
  if var_a>'BOT';
run;

The '=:' relation in the where statement tells sas to read in only those records with VAR_A starting with 'BOT'. The subsetting IF then keep only the subset that has something other than a blank following the 'BOT'.

Edit note: Forgot to change if vara>'BOT' to if var_a>'BOT'. Thanks @Amir for the note.

Re: Outputting variable value

Amir — Wed, 04 Nov 2020 12:14:21 GMT

Hi @mkeintz,

To avoid confusion, you'll need to insert an underscore in the variable name in:

  if vara>'BOT';

Kind regards,

Amir.