topic expression using equals in SAS Procedures

expression using equals

Afor910327 — Mon, 08 Apr 2019 20:00:06 GMT

Does anyone see the error below? I do not see anything.

proc sql;
9251
9252 create table trans1 as
9253
9254 select itmCode_id as itemCode_id label="itemCode_id", itmCode as itemCode
9254! label="itemCode", itmDescr label="itemDesc",
9255 period as ioYear, sum(val) as proVal label="proVal"
9256 from sqltrn.dataView
9257 where period = 2012
9258 and datasetName = 'annual17'
9259 and schemaName = 'NAICS12'
9260 and valType in ('DOM','IMP','CTX')
9261 group by itmCode_id, itmCode, itmDescr, period
9262 order by itmCode_id
9263 ;
ERROR: Expression using equals (=) has components that are of different data types.
9264 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

Re: expression using equals

PaigeMiller — Mon, 08 Apr 2019 20:03:02 GMT

@Afor910327 wrote:

Does anyone see the error below? I do not see anything.

proc sql;
9251
9252 create table trans1 as
9253
9254 select itmCode_id as itemCode_id label="itemCode_id", itmCode as itemCode
9254! label="itemCode", itmDescr label="itemDesc",
9255 period as ioYear, sum(val) as proVal label="proVal"
9256 from sqltrn.dataView
9257 where period = 2012
9258 and datasetName = 'annual17'
9259 and schemaName = 'NAICS12'
9260 and valType in ('DOM','IMP','CTX')
9261 group by itmCode_id, itmCode, itmDescr, period
9262 order by itmCode_id
9263 ;
ERROR: Expression using equals (=) has components that are of different data types.
9264 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

ERROR: Expression using equals (=) has components that are of different data types.

This indicates one of your variables is not the right type given the testing in the WHERE clause.

period = 2012 means the variable period must be numeric (is it?)

datasetName = 'annual17' means that datasetName must be character (is it?)

same for SchemaName and ValType

Re: expression using equals

Kurt_Bremser — Tue, 09 Apr 2019 05:13:55 GMT

Maxim 3: Know Your Data.

Run a proc contents on dataset sqltrn.dataView to determine the types of the variables used in your where condition.

My most suspected culprits:

period might actually be character
valtype could be coded as numeric, and have a custom format overlayed

Please let us know what proc contents has to say.