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:Inserting rows in a specified order (SQL)

From sasCommunity
Jump to: navigation, search

The SQL INSERT statement does not permit use of an ORDERED BY clause to control the order in which the new rows are stored. To work around this limitation, define a named view and include the ORDERED BY clause in its definition, then invoke the view in the INSERT statement.

Submitted by Howles. Contact me at my Discussion Page.

....read more