Hi Mr. Schreier, I just finished reading your paper. It is a very good paper.  Thanks - Linlin ... View more

As far as I know, you have to use "call symput" or "call symputx". I have never used "symput" without "call". ... View more

example: data names; input name $ 8.; cards; Art Cynthia Ksharp Tom Hai-Kuo ; run; /* to create macro variables teacher1-teacher5 */ data _null_;   set names;   call symputx(cats('teacher',strip(_n_)),name); run; %put &teacher1 &teacher2 &teacher3 &teacher4 &teacher5; /* to get the value of &teacher1 &teacher2 &teacher3 &teacher4 &teacher5 */ data want;    do i=1 to 5;    expert=symget(cats('teacher',i));    output;    end;   run; proc print data=want;run; Obs    i    expert 1     1    Art 2     2    Cynthia 3     3    Ksharp 4     4    Tom 5     5    Hai-Kuo ... View more

symput: creating macro variables in a datastep. symget: getting macro variable value in a datastep. ... View more

Hi Art, are there any difference between data want(drop=temp i); set x; array v{4} $ ; do i=1 to 4;   temp=scan(var0,i,'_',"M");   if not missing(temp) then v{i}=temp; end; run; proc print;run; and data want(drop=i); set x; array v{4} $ ; do i=1 to 4;   v{i}=scan(var0,i,'_',"M");   *if not missing(temp) then v{i}=temp; end; run; proc print;run; Thanks - Linlin ... View more

Hi Rich, from my log file: 2806  Proc options option=VALIDVARNAME; 2807  run;     SAS (r) Proprietary Software Release 9.3  TS1M0 VALIDVARNAME=V7   Control the type of SAS variable names that can be created                    during a SAS session NOTE: PROCEDURE OPTIONS used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds ... View more

Good morning Art! I am using a Lenovo laptop with Windows 7. ... View more

Hi Rich, Yes, it is interesting. And your code works fine without select statement. proc transpose data = have out=thave;  var col1-col3; run; data test (drop=col:);    set thave;       PrgA = sum(col1,col2);            PrgB = sum(col3,col4);            PrgC = sum(col5,col6);  run; proc print data=test;run;                     Obs    _NAME_    PrgA    PrgB    PrgC                         1      col1       4       8      12                         2      col2       7      16       5                         3      col3       8       6       4 Thanks - Linlin ... View more

Hi Rich, I use pc sas (9.3). the _name_ values I generated are lowcase in the thave dataset. Below is what I got when I ran your code: data have; input program: col1 col2 col3; cards; 10  3 5 1 15  1 2 7 24  6 8 5 21  2 8 1 35  9 4 3 33  3 1 1 ; proc transpose data = have out=thave;  var col1-col3; run; data test (drop=col:);    set thave;   select(_name_);         when ('COL1') do;               PrgA = sum(col1,col2);            PrgB = sum(col3,col4);           PrgC = sum(col5,col6);     end;     when ('COL2') do;          PrgA = sum(col1,col2);          PrgB = sum(col3,col4);          PrgC = sum(col5,col6);    end;    when ('COL3') do;         PrgA = sum(col1,col2);         PrgB = sum(col3,col4);        PrgC = sum(col5,col6);  end; otherwise; end; run; proc print data=test;run;                     Obs    _NAME_    PrgA    PrgB    PrgC                         1      col1       .       .       .                         2      col2       .       .       .                         3      col3       .       .       . Thanks - Linlin ... View more