The pics I attached are from the XML Mapper, I start with the automap to view the tables, and then I create my own map with the fields that interest me. Then I erase the automap and build my own "schema" or map, so that SAS takes care of the joins, and brings in only the fields that I want to select. I'm not sure how to recover the various alpha values here though. Btw, for this case, if it's even possible, do I have to use the full view or the condensed view to drag and drop the fields I need? I don't think the condensed view is useful here since it's only giving me numeric values and the alphas are all gone. But oddly, when I drag fields from the full view to create a customized map, it seems all of the fields are resulting in the location of the file. Not sure if this XML is convertible.
... View more