As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.
Here are some tips for How to share your SAS knowledge with your professional network.
Tips:Inheriting Column Attributes (SQL)
When a new table is derived from an existing table in PROC SQL, a column will inherit attributes only if it is not transformed. To bring about attribute inheritance for transformed columns, include a zero-row template in the definition of the new table.
Submitted by Howles. Contact me at my Discussion Page.