data T1; input mod $ var $ moy1 ; datalines; . AA 23 as AA 45 sc AA 68 . CC 0 ic CC 1 vi CC 35 cm CC 235 . DD 4 fi DD 36 dh DD 35 sg DD 10 ; run; data T2; input mod $ var $ moy2; datalines; . AA 0 as AA 10 sc AA 23 . CC 10 ic CC 12 vi CC 23 cm CC 9 . DD 3.3 fi DD 21 dh DD 16 sg DD 13 ; run; data T3; input mod $ var $ moy3 ; datalines; . AA 12 as AA 4 sc AA 0 . CC 11 ic CC 35 vi CC 6 cm CC 8 . DD 12 fi DD 4 dh DD 14 sg DD 15 ; run; /* get the Matab table */ data MaTab; input mod $ var $ moy1 moy2 moy3 ; datalines; . AA 23 0 12 as AA 45 10 4 sc AA 68 23 0 . CC 0 10 11 ic CC 1 12 35 vi CC 35 23 6 cm CC 235 9 8 . DD 4 3.3 12 fi DD 36 21 4 dh DD 35 16 14 sg DD 10 13 15 ; run; Hi, I have several sas tables (T1,T2,T3,...,Tn). I am providing you with an extract (T1, T2 and T3). I want to create a code which allows me to have the Matab table whose structure is as follows: (see the table). I tried to get it by concatenating or merging (merge with data step or sql with proc sql) without success. The result in screenshot is not good and this is what I get even though I want to have the Matab table.   Can anyone suggest me a code or an approach that can get the Matab table please.   Best regards, Gick ... View more

data MaTable; input Nom $ "A.D.C_EF"n $ Score_biomarqueur Score_pesticides "Q13t"n $ "Q13bist"n $ "Q1.A"n $ "Qt.2"n $; datalines; Doe John 30 1 oui o T i Smith Jane 25 20 oui n T o Brown Alice 35 2 non n T o A C 2 2 non n K j A C 5 23 non n K j B John 10 21 non n K l K C 31 13 oui o K l B Jane 21 4 non o S l ; run; %macro stat_central(); proc sql ; select name into :char_vars separated by ' ' from dictionary.columns where libname='WORK' and memname="MATABLE" and type='char'; quit; %put &char_vars.; %do k=1 %to %sysfunc(countw(&char_vars.)); %let char = %scan(&char_vars., &k.); proc sort data=MATABLE; by "&char."n; run; proc means data=MATABLE; var Score_biomarqueur Score_pesticides; class "&char."n; run; %end; %mend; %stat_central(); Hi, Here is an extract from my table. I want to run this macro program but I get an error message because of the variables having dots. In fact, these variables separate into 2 or more variables. As a result, SAS no longer finds them in the base. Can anyone help me solve this problem or suggest another approach? Note that this is just an extract from the table. I have several variable names written with periods. Best regards, Gick ... View more