Here the SASLOG including the OPTIONS MPRINT and the %put s for the variables. 1 The SAS System 11:20 Tuesday, June 5, 2018
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROJECTPATH=[hiden];
5 %LET _CLIENTPROJECTNAME='Project 2.egp';
6 %LET _SASPROGRAMFILE=;
7
8 ODS _ALL_ CLOSE;
9 OPTIONS DEV=ACTIVEX;
NOTE: Procedures may not support all options or statements for all devices. For details, see
the documentation for each procedure.
10 GOPTIONS XPIXELS=0 YPIXELS=0;
11 FILENAME EGSR TEMP;
12 ODS tagsets.sasreport12(ID=EGSR) FILE=EGSR STYLE=Analysis
12 ! STYLESHEET=(URL="[hiden]") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");
NOTE: Writing TAGSETS.SASREPORT12(EGSR) Body file: EGSR
13
14 GOPTIONS ACCESSIBLE;
15 OPTIONS MPRINT;
16
17 %let data_ini='01jan2008'd;
18 %let data_fin='31dec2016'd;
19
20 %let data_1=putn(&data_ini.,'mmddyyyy');
21 %let ano_i=year(data_1);
22 %let mes_i=month(data_1);
23 %let data_2=putn(&data_fin.,'mmddyyyy');
24 %let ano_f=year(data_2);
25 %let mes_f=month(data_2);
26
27 %put ano_i is: &ano_i;
ano_i is: year(data_1)
28 %put mes_i is: &mes_i;
mes_i is: month(data_1)
29 %put ano_f is: &ano_f;
ano_f is: year(data_2)
30 %put mes_f is: &mes_f;
mes_f is: month(data_2)
31
32 %macro tabla (ano_ini,mes_ini,ano_fin,mes_fin);
33 proc sql;
34 create table serie(data num, taxa num);
35 %do i=&ano_ini. %to &ano_fin.;
36 %do j=&mes_ini. %to &mes_fin.;
37 INSERT INTO SERIE
38 set data=mdy(&j.,25,&i.),taxa=0.01;
39 %end;
40 %end;
41 create table serie as
42 select data as data format date9., taxa as taxa
43
44 from serie;
2 The SAS System 11:20 Tuesday, June 5, 2018
45 quit;
46 %mend;
47
48 %tabla (ano_i,mes_i,ano_f,mes_f);
MPRINT(TABLA): proc sql;
MPRINT(TABLA): create table serie(data num, taxa num);
NOTE: Table WORK.SERIE created, with 0 rows and 2 columns.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
operand is required. The condition was: &ano_ini.
ERROR: The %FROM value of the %DO I loop is invalid.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
operand is required. The condition was: &ano_fin.
ERROR: The %TO value of the %DO I loop is invalid.
ERROR: The macro TABLA will stop executing.
49
50
51
52
53 GOPTIONS NOACCESSIBLE;
54 %LET _CLIENTTASKLABEL=;
55 %LET _CLIENTPROJECTPATH=;
56 %LET _CLIENTPROJECTNAME=;
57 %LET _SASPROGRAMFILE=;
58
59 ;*';*";*/;quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
59 ! run;
60 ODS _ALL_ CLOSE;
61
62
63 QUIT; RUN;
64
... View more