Agreed. ... View more

you can use retain statement to order the variables: data have; input Id     Period     Time     Conc; cards; 1          1               0          0 1          1               5          0 1          1              10         2 1          2               0          0 1          2               5          2 1          2               10          3 2          1               0          0 2          1               5          2 2          1               10          4 2          2               0          0 2          2               5          5 2          2               10          8 ; run; data want(keep=id period t1-t3 c1-c3);   array t{3} ;   array c{3} ;   count=0;   do until(last.period);     set have;     by id period;     count+1;     t{count}=time;c{count}=conc;   end; run; data want;    retain id period t1-t3 c1-c3;   set want; run; proc print;run;             Obs    id    period    t1    t2    t3    c1    c2    c3                1      1       1       0     5    10     0     0     2                2      1       2       0     5    10     0     2     3                3      2       1       0     5    10     0     2     4                4      2       2       0     5    10     0     5     8 Linlin ... View more

how about: data have; input Id     Period     Time     Conc; cards; 1          1               0          0 1          1               5          0 1          1              10         2 1          2               0          0 1          2               5          2 1          2               10          3 2          1               0          0 2          1               5          2 2          1               10          4 2          2               0          0 2          2               5          5 2          2               10          8 ; run; data want(keep=id period t1-t3 c1-c3);   array t{3} ;   array c{3} ;   count=0;   do until(last.period);     set have;     by id period;     count+1;     t{count}=time;c{count}=conc;   end; run; proc print;run;            Obs    t1    t2    t3    c1    c2    c3    Id    Period                1      0     5    10     0     0     2     1       1                2      0     5    10     0     2     3     1       2                3      0     5    10     0     2     4     2       1                4      0     5    10     0     5     8     2       2 Linlin ... View more

try this one: data have; input Date       Port_no     Return     Liquidity; cards; 1985        1               2.5            3 1985        2               2.8            3.2 1985        3               2.3            3.4 1986        1               3.2             2.3 1986        2               3.5             2.1  1986        3               2.4              1.8 ; data want(keep= date port_r: port_l:);   array port_return{3} ;   array port_liquity{3} ;   count=0;   do until(last.date);    set have;    by date;    count+1;    port_return{count}=return;port_liquity{count}=liquidity;     end; run; proc print;run; ... View more

Hi Alisa, It was Tom's code. Please check one of Tom's posts as correct answer.  Thanks - Linlin ... View more

"left" moves the number to left. without using "left" function, "c_1" will be "c_     1". "compress" also takes out extra spaces. Below is the log file without using left function: 1260  Data _null_; 1261     set Temp_Cats; 1262          call symput ("C_" || (_N_), compress(IV_Bin)); 1263          call symput ("n_" || (_N_), left(count)); 1264          call symput ("M", _N_); 1265     Run; NOTE: Numeric values have been converted to character       values at the places given by: (Line):(Column).       1262:31   1262:46   1263:31   1263:42   1264:27 ERROR: Symbolic variable name C_           1 must contain only letters, digits,        and underscores. NOTE: Invalid argument to function SYMPUT at line 1262 column 14. ERROR: Symbolic variable name N_           1 must contain only letters, digits,        and underscores. NOTE: Invalid argument to function SYMPUT at line 1263 column 14. IV_Bin=1 count=410 _ERROR_=1 _N_=1 ERROR: Symbolic variable name C_           2 must contain only letters, digits,        and underscores. NOTE: Invalid argument to function SYMPUT at line 1262 column 14. ERROR: Symbolic variable name N_           2 must contain only letters, digits,        and underscores. NOTE: Invalid argument to function SYMPUT at line 1263 column 14. IV_Bin=2 count=35 _ERROR_=1 _N_=2 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 2 observations read from the data set WORK.TEMP_CATS. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds ... View more

Hi Tom, I ran your code. below is the log file. I replaced the OP's dataset with sashelp.class.   Thanks - Linlin 1073  %let decimal= 0 1 2 3 4; 1074  %let orders=INTERNAL FREQ; 1075  %let numerror=0; 1076  %macro salarystats(decimals1=5,order1=PANDA) /minoperator; 1077  %if not &decimals1 in &decimal %then %let numerror=%eval(&numerror+1); 1078  %if not &order1 in &orders %then %let numerror=%eval(&numerror+1); 1079  %if &numerror lt 1 %then %do; 1080     options nolabel; 1081     title 'Salary Stats'; 1082     proc means data=sashelp.class maxdec=&decimals order=ℴ 1083        var age; 1084        class sex; 1085     run; 1086  title; 1087  %end; 1088  %else %put What are you trying to use?; 1089  %mend salarystats; 1090  %salarystats; MLOGIC(SALARYSTATS):  Beginning execution. MLOGIC(SALARYSTATS):  Parameter DECIMALS1 has value 5 MLOGIC(SALARYSTATS):  Parameter ORDER1 has value PANDA MLOGIC(SALARYSTATS):  %IF condition not &decimals1 in &decimal is TRUE MLOGIC(SALARYSTATS):  %LET (variable name is NUMERROR) ERROR: A character operand was found in the %EVAL function or %IF condition where        a numeric operand is required. The condition was: not &order1 in &orders ERROR: The macro SALARYSTATS will stop executing. MLOGIC(SALARYSTATS):  Ending execution. ... View more

title needs double quote: change   'Top &numcustid Customers'; to      "Top &numcustid Customers"; ... View more