When attempting to use an information map that includes general prefilters, you might receive one or both of the following errors:
ERROR: Column <name_col> could not be found in the table/view identified with the correlation name table0.
ERROR: Expression using equals (=) has components that are of different data types.
This error typically appears when you use SAS Data Integration Studio to rename a column in a dataset on which the information map is based. If you use SAS Data Integration Studio to rename a column in a dataset, only the dataset metadata attributes "Name and "SASColumnName" are changed to the new column name. The attribute "ColumnName" retains the old column name.
This difference between the values of SASColumnName and ColumnName might generate a problem for information maps which use this dataset. However, this behavior is correct from a metadata perspective and it is consistent with the definition of the attributes:
- ColumnName:
- This attribute is the name of the column as it is defined in a DBMS.
- SASColumnName:
- This is the name that SAS software uses to access the column.
- Name:
- A logical identifier for the object.
As a workaround, complete the following steps to make the sasColumnName value match the ColumnName value for the data items whose values do not match.
1. Run the following base code to create the member_group dataset which will contain information about the columns available in your metadata and the datasets to which these columns belong.
/* create member dataset */
data member_group (keep=id_member id_group Name_member Name_group desc ColumnName SASColumnName);
length uri $256 id_member $17 id_group $17
Name_member $60 Name_group $60
desc $200 ColumnName $256 SASColumnName $256;
nobj=1;
n=1;
do while(nobj >= 0);
nobj=metadata_getnobj("omsobj:Column?@Id contains '.'",n,uri);
if (nobj < 0) then leave;
arc=metadata_getattr(uri,"Id",id_member);
arc=metadata_getattr(uri,"Name",name_member);
arc=metadata_getattr(uri,"Desc",desc);
arc=metadata_getattr(uri,"ColumnName",ColumnName);
arc=metadata_getattr(uri,"SASColumnName",SASColumnName);
/* search group id */
rc=metadata_resolve("omsobj:DataTable?DataTable[@Id contains '.'][Columns/Column[@Id='" || id_member || "']]",type,id_group);
arc=metadata_getattr("PhysicalTable\" || id_group,"Name",name_group);
n=n+1;
output member_group;
end;
run;
2. Open the member_group dataset and look for the record whose
name_group is equal to the name of your dataset and whose
name_member is equal to the name of the column you want to rename. Copy the values of
id_member and
SASColumnName for that record and paste it to the following code.
data _null_;
rc=metadata_setattr("omsobj:Column?@Id='<id_member>'","ColumnName", "<SASColumnName>");
put rc=;
run;
Execute the code above. The metadata will be updated. The value of the attribute ColumnName for the record with id_member will become equal to SASColumnName.
Operating System and Release Information
| SAS System | SAS Information Map Studio | Microsoft® Windows® for x64 | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 3.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 3.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 3.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 3.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows NT Workstation | 3.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Windows Vista | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
