Hi, I have a table(import from excel- - 800 row) like this: data t1; input index $ num $ num2 $; datalines; var1 a+b b var2 b b+c run; and the table tab1 is this:   Now I have another table: data t2; input a b c; datalines; 1 2 3 4 5 6 run; like this:   - In table t2, I would like calculate the sum of the variable that are described in the table t1: and the result shoul be like this:     I have mainly this two problem: 1) transpose the tab 1 2)how to execute the value of variable like instruction(code) of SAS   some of you has any idea?   Thanks.       ... View more

Hi, I have unexpected result from the call symput function of SAS. I wrote this code: data tab1; a=1; b=2; output; a=3; b=5; output; run; %macro loop; data tab2; set tab1; %do i=1 %to 2; call symput(cats('var',&i),a); call symput(cats('dem',&i),b); %end; run; %do i=1 %to 2; %put i &&var&i &&dem&i; %end; %mend; %loop; from this code I get the result:   1 3 5 2 3 5 Instead of : 1 1 2 2 3 5   (In linux...sas doesn't recognize the macro variable &&var&i ).   I can't understand why... I need to save some variable in the macro variable... some of you has some solution and explain why I get this result? really..I can't understand.. Thanks       ... View more

Hi, I have to import the file.csv, that contains a fields with this values: VALUE 3456 -4567 456,8 Which is it, the best format for import that values? Usually I use best12. , but in this case I have some trouble with the comma. I also use COMMAx.w..but it doesn't work. I'm not able to find correct format. Some of you has some good suggestion?   ... View more