Looks like you're doing a PROC APPEND. The base table is the dataset you are appending to while the data dataset contains the records you wish to append to the base dataset.   The warning messages you are receiving are advising that your data dataset does not contain the column CustomerID, but it is on the base dataset (so values for these new records in the column CustomerID will be blank). The column CustomerType is not on your base dataset but is on the data dataset so the missing column will not be added. You can override this by adding the FORCE option to the procedure. ... View more

Thanks Nick. Sounds like I'll need it! I've red flagged this as the client are in the process of upgrading ArcGIS to v10.1. If you believe the SAS ESRI Bridge isn't compatible with anything higher than 10.0, then we have a problem on our hands and may mean developing a lot more than just a temporary solution. Unfortunately, a search on the SAS website doesn't shine any light on this.... ... View more

Therefore, my apologies for not explicitly stating that I was referring to the SAS ESRI Bridge, and not the ESRI bridge. ... View more

Nick, The ESRI map component has been available within SAS (WRS, OLAP Viewer and EG) since 9.1.3. See http://support.sas.com/rnd/papers/sgf07/sgf2007-map.pdf for examples of functionality. ... View more

Thanks Nick. I'd come to the same conclusion, but it's great to have someone else confirm this. I've already produced a STP and added it within the Portal. Not as good as the full ESRI bridge functionality, but should appease the end user until I can get the bridge installed and configured. ... View more

You need to apply the preserve_comments statement in the libname statement. Go into SAS Management Console (looks like you're using SAS 9.2 or SAS 9.3) and select 'Data Library Manager' and then expand your list of libraries. Right-click the library you need to change and select 'Properties. Select 'Options' then 'Advanced Options' then 'Other options. Type 'PRESERVE_COMMENTS' in the field and apply the change. Regenerate your DI code. The libname statement will now have the 'PRESERVE_COMMENTS' value so that you can pass the hint. ... View more