Hi,
suppose that I have a data of daily stock returns and I have many stocks, say 100. What I want to do is to input all of these stock returns into Proc IML in the following way:
Proc IML;
use returns;
read all var {abc def .... zzz} into RMAT;
So instead of individually typing inside the parentheses the names of the stocks, I would like to have a way that automatically inputs all the 100 names.
For the sake of SIMPLICITY consider this as my original data (having only 3 stocks) :
data returns;
input abc def zzz;
datalines;
10 2 5
3 -5 7
-1 -7 6
1 3 -2
;
run;
And what I would like to have is:
Proc IML;
use returns;
read all var {abc def zzz} into RMAT;
But the names should be input automatically and not typed one by one.
I tried doing {abc - zzz} but got an error message...
Thank you very much!!!