HI,
I am creating the join by using the query builder where as my source tables both are directly reading from DB as one of the table join column is not matching (data type) with other table join column , where as i know eg programming while joining in proc sql we can convert to numeric(input) and join the tables but here the problem is we are reading from db in query builder and joining.The error saying data type not matching on the join column.
any ideas with out locally creating and coNverting the column , i want to do directly in query builder join even if data type is different .
Are these two external tables from the same database? If so, my first feeling would be to talk to the data base administrator about why the types are different and see if the admin will provide a work around, such as view in the database that does the conversion and you can use that as your source.
If they are not from the same database it may be unreasonable to expect them to be of the same type(or properties) and a conversion somewhere will be needed. Again you may convince one of the database admins to make a conversion view of the needed data.
I doubt that the query builder allows a function to be applied before the join is defined. You either need two steps (define a view which does the conversion, then join), or you write the SQL yourself in a code node.
A business item (and one used for joining!) stored as a number in one table, and character in another? My word for this is "clusterfuck". Somebody needs to have their head examined for possible absence of a brain.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.