Скачать или смотреть proc summary et proc means

Ma chaîne est de partager les astuces en SAS, R studio, Python et Excel VBA


data exemple;
infile datalines;
format IDENTITE $CHAR9. Age 6. Ville $CHAR9.;
informat IDENTITE $CHAR9. AGE 6. Ville $CHAR9.;
infile datalines DLM=',' dsd truncover;
input IDENTITE $ AGE $ Ville;
datalines;
1,12,Paris
2,14,Paris
3,24,Paris
4,56,Lille
5,33,Lille
6,67,Lille
7,45,Lille
8,51,Lille
9,38,Lille
10,77,Paris
;
run;

proc univariate data=EXEMPLE;
histogram;
run;


proc univariate data=EXEMPLE;
var AGE;
histogram;
run;


/*Calculer l'âge moyen par ville */
/*méthode 1 */
PROC SQL;
CREATE TABLE WORK.age_moyen_par_ville AS
SELECT DISTINCT Ville,
(MEAN(Age)) FORMAT=6. AS MEAN_of_Age
FROM WORK.EXEMPLE
GROUP BY Ville;
QUIT;

/*méthode 2 */
proc sort data = exemple;
by Ville;
run;

Proc means data= EXEMPLE MEAN;
VAR AGE;
by Ville;
OUTPUT OUT = age_moyen_par_ville(drop = _:) mean =;
RUN;


Proc means data= EXEMPLE MEAN;
VAR AGE;
CLASS Ville;
OUTPUT OUT = age_moyen_par_ville(drop = _:) mean =;
RUN;

/*méthode 3 */
proc sort data = exemple;
by Ville;
run;

proc summary data = exemple;
var Age;
by Ville;
output out = age_moyen_par_ville(drop =_:) mean=;
run;


proc summary data=exemple nway ;
var Age ;
class Ville ;
OUTPUT OUT=age_moyen_par_ville (drop=_TYPE_ _FREQ_) mean= ;
run;


proc summary data=exemple nway ;
var Age ;
class Ville /missing ;
OUTPUT OUT=age_moyen_par_ville (drop=_TYPE_ _FREQ_) mean= ;
run;