topic Re: Add a label column as a vector or matrix based on condition in SAS/IML Software and Matrix Computations

Add a label column as a vector or matrix based on condition

Sasulee — Thu, 18 Jun 2020 07:28:02 GMT

Hi all,

I have 3 data vectors read in iml which are

I want to mark these data by following discipline:

label = put where k<k0;
label = call where k>k0;
label = mix where k=k0.

How can I do? Thank you!

Re: Add a label column as a vector or matrix based on condition

IanWakeling — Thu, 18 Jun 2020 08:57:03 GMT

I think this will work

  lab = choose(k<k0,'put','mix');
  lab = choose(k>k0,'call',lab);
  print k0 k lab;

however you may need to screen missing values out first if you have them.

Re: Add a label column as a vector or matrix based on condition

Sasulee — Thu, 18 Jun 2020 09:12:49 GMT

Awesome, it works, thanks!
however, how can I use this info to define another row? like
create a new vector Q
Q=p (a numeric variable ) if lab='put';
Q=c (a numeric variable ) if lab='call';
Q=(p+c)/2 if lab='mix';
The vector should be continuous, like
p c lab Q
1 2 put 1
2 3 call 3
4 5 call 5
6 7 mix 6.5

Can you help?

Re: Add a label column as a vector or matrix based on condition

IanWakeling — Thu, 18 Jun 2020 09:22:35 GMT

You can use essentially the same syntax to construct Q like this:

  lab = choose(k<k0,'put','mix');
  lab = choose(k>k0,'call',lab);
  Q = choose(k<k0, p, (p+c)/2);
  Q = choose(k>k0, c, Q);
  print k0 k lab p c Q;