Good afternoon,
I am getting a series of errors on this code, I think it is because of parenthesis, could you please point out clearly how could I fix this?
Thank you!
MPRINT(SERIES): *********************************************************************************************;
MPRINT(SERIES): *******************************************************************;
MPRINT(SERIES): *********************************************************************************************;
MPRINT(SERIES): proc sql;
SYMBOLGEN: Macro variable DATASETPERIOD_ID resolves to 1576
NOTE: Line generated by the invoked macro "SERIES".
134 occ.datasetPeriod_id, occ.val from occ.indBR occ where datasetperiod_id = &datasetperiod_id) as occ join (select *
134 ! from cde.getCodes ('io','indfu','NAICS12')) as cde on occ.indCode_id = cde.code_id order by indCode ; create table
-
79
134 ! tempsas.indInter as
ERROR 79-322: Expecting a ).
NOTE 137-205: Line generated by the invoked macro "SERIES".
134 occ.datasetPeriod_id, occ.val from occ.indBR occ where datasetperiod_id = &datasetperiod_id) as occ join (select *
134 ! from cde.getCodes ('io','indfu','NAICS12')) as cde on occ.indCode_id = cde.code_id order by indCode ; create table
-
22
134 ! tempsas.indInter as
ERROR 22-322: Syntax error, expecting one of the following: a name, AS, ON.
NOTE: Line generated by the invoked macro "SERIES".
134 occ.datasetPeriod_id, occ.val from occ.indBR occ where datasetperiod_id = &datasetperiod_id) as occ join (select *
134 ! from cde.getCodes ('io','indfu','NAICS12')) as cde on occ.indCode_id = cde.code_id order by indCode ; create table
-
200
134 ! tempsas.indInter as
ERROR 200-322: The symbol is not recognized and will be ignored.
SYMBOLGEN: Macro variable IOYEAR resolves to 1998
SYMBOLGEN: Macro variable DSNAME resolves to 'Annual17'
MPRINT(SERIES): create table tempsas.totIndOut as select cde.code as indCode, occ.val as proval label = "Industry
Output" from (select occ.indCode_id, occ.datasetPeriod_id, occ.val from occ.indBR occ where datasetperiod_id = 1576) as
occ join (select * from cde.getCodes ('io','indfu','NAICS12' )) as cde on = order by indCode create table tempsas.indInter
as select indCode, sum(val) as Inter label="Intermediate Inputs" from trn.dataView where period = "1998" and
upcase(substr(itmCode,1,1)) not in ('T','V','W') and upcase(substr(indcode,1,1)) not in
('F','S','E','B','C','I','N','X','M') and upcase(valType) in ('DOM','IMP','CTX') and datasetName = 'Annual17' group by
indCode order by indcode ;
NOTE: Table TEMPSAS.INDINTER created, with 793 rows and 2 columns.
SYMBOLGEN: Macro variable DSNAME resolves to 'Annual17'
SYMBOLGEN: Macro variable IOYEAR resolves to 1998
MPRINT(SERIES): create table tempsas.indComp as select indCode, sum(val) as compensation label="Compensation of
Employees" from trn.dataView where datasetName = 'Annual17' and upcase(substr(itmCode,1,1)) in ('W') and upcase(valType)
in ('DOM','IMP','CTX') and period = "1998" group by indCode order by indcode ;
NOTE: Table TEMPSAS.INDCOMP created, with 793 rows and 2 columns.
SYMBOLGEN: Macro variable DSNAME resolves to 'Annual17'
SYMBOLGEN: Macro variable IOYEAR resolves to 1998
MPRINT(SERIES): create table tempsas.indIBT as select indCode, sum(val) as taxes label="Taxes on Production and Imports,
less Subsidies" from trn.dataView where datasetName = 'Annual17' and upcase(substr(itmCode,1,1)) in ('T') and
upcase(valType) in ('DOM','IMP','CTX') and period = "1998" group by indCode order by indcode ;
NOTE: Table TEMPSAS.INDIBT created, with 770 rows and 2 columns.
MPRINT(SERIES): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 5.03 seconds
cpu time 0.18 seconds
MPRINT(SERIES): data tempsas.ind_value_added;
MPRINT(SERIES): merge tempsas.totIndOut tempsas.indInter tempsas.IndComp tempsas.indIBT;
ERROR: File TEMPSAS.TOTINDOUT.DATA does not exist.
MPRINT(SERIES): by indCode;
MPRINT(SERIES): array format{*} _numeric_;
MPRINT(SERIES): do i=1 to dim(format);
MPRINT(SERIES): if format{i} = . then format{i} = 0;
MPRINT(SERIES): end;
MPRINT(SERIES): GOS = sum(proVal,-1*inter,-1*compensation,-1*taxes);
MPRINT(SERIES): label GOS = "Gross Operating Surplus";
MPRINT(SERIES): drop i;
MPRINT(SERIES): run;
Click image to register for webinar
