my code: DATA ESTIMATIONS_ALL;
SET ESTIMATIONS_ALL;
month=month(Date);
year=year(Date);
RUN; my log: ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='MATH30602.A2021_Devoir1_VotreMatricule.sas';
4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='C:\Users\axel_\OneDrive\Bureau\Logiciels statistiques\MATH30602.A2021_Devoir1_VotreMatricule.sas';
9 %LET _SASPROGRAMFILEHOST='LAPTOP-NMODV674';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
21 ENCODING='utf-8'
22 STYLE=HtmlBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28 DATA ESTIMATIONS_ALL;
29 SET ESTIMATIONS_ALL;
30 month=month(Date);
31 year=year(Date);
32 RUN;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
30:13 31:11
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=1 Both sexes=10147.7 Male=4975.8 Female=5171.9 month=.
year=. _ERROR_=1 _N_=1
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=2 Both sexes=8609 Male=4296.6 Female=4312.4 month=. year=.
_ERROR_=1 _N_=2
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=3 Both sexes=857.7 Male=439.5 Female=418.1 month=. year=.
_ERROR_=1 _N_=3
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=4 Both sexes=1715.8 Male=875.7 Female=840.1 month=. year=.
_ERROR_=1 _N_=4
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=5 Both sexes=858.1 Male=436.2 Female=421.9 month=. year=.
_ERROR_=1 _N_=5
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
2 Le Système SAS 09:05 Friday, November 5, 2021
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=6 Both sexes=3682.3 Male=1835.8 Female=1846.5 month=. year=.
_ERROR_=1 _N_=6
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=7 Both sexes=5551.5 Male=2763.4 Female=2788.1 month=. year=.
_ERROR_=1 _N_=7
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=8 Both sexes=8431.9 Male=4100.1 Female=4331.8 month=. year=.
_ERROR_=1 _N_=8
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=9 Both sexes=1869.2 Male=927.6 Female=941.6 month=. year=.
_ERROR_=1 _N_=9
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=10 Both sexes=1341.7 Male=657.5 Female=684.2 month=. year=.
_ERROR_=1 _N_=10
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=11 Both sexes=2880.4 Male=1336.7 Female=1543.7 month=.
year=. _ERROR_=1 _N_=11
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=1 groupe_age_id=12 Both sexes=1538.7 Male=679.2 Female=859.5 month=. year=.
_ERROR_=1 _N_=12
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=2 groupe_age_id=1 Both sexes=731 Male=323.4 Female=407.6 month=. year=.
_ERROR_=1 _N_=13
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=2 groupe_age_id=2 Both sexes=320.4 Male=150.6 Female=169.9 month=. year=.
_ERROR_=1 _N_=14
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=2 groupe_age_id=3 Both sexes=40.7 Male=19.9 Female=20.8 month=. year=.
_ERROR_=1 _N_=15
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=2 groupe_age_id=4 Both sexes=53.3 Male=25.5 Female=27.8 month=. year=.
_ERROR_=1 _N_=16
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=2 groupe_age_id=5 Both sexes=12.6 Male=5.6 Female=7 month=. year=. _ERROR_=1
_N_=17
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=2 groupe_age_id=6 Both sexes=64.9 Male=35.3 Female=29.6 month=. year=.
_ERROR_=1 _N_=18
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=2 groupe_age_id=7 Both sexes=141.6 Male=69.1 Female=72.5 month=. year=.
_ERROR_=1 _N_=19
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 30 colonne 13.
NOTE: Invalid numeric data, Date='Mar2006' , at ligne 31 colonne 11.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
Date=Mar2006 Geo_id=1 caracteristique_id=1 education_id=2 groupe_age_id=8 Both sexes=677.7 Male=297.9 Female=379.8 month=. year=.
3 Le Système SAS 09:05 Friday, November 5, 2021
_ERROR_=1 _N_=20
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
247800 à 30:7 247800 à 31:6
NOTE: There were 247800 observations read from the data set WORK.ESTIMATIONS_ALL.
NOTE: The data set WORK.ESTIMATIONS_ALL has 247800 observations and 10 variables.
NOTE: DATA statement a utilisé (Durée totale du traitement) :
real time 0.16 seconds
cpu time 0.15 seconds
33
34 %LET _CLIENTTASKLABEL=;
35 %LET _CLIENTPROCESSFLOWNAME=;
36 %LET _CLIENTPROJECTPATH=;
37 %LET _CLIENTPROJECTPATHHOST=;
38 %LET _CLIENTPROJECTNAME=;
39 %LET _SASPROGRAMFILE=;
40 %LET _SASPROGRAMFILEHOST=;
41
42 ;*';*";*/;quit;run;
43 ODS _ALL_ CLOSE;
44
45
46 QUIT; RUN;
47 before after
... View more
