Hi:
Generally, when people refer to "in-line" macros, they are referring to "session compiled" macro programs that are compiled and used within the same program. Usually, they reside in the WORK library, as described here, in the documentation (as opposed to autocall macro programs or Stored compiled macro programs):
http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#/documentation/cd...
And these 2 papers are very good resources for the beginner (in addition to the most excellent books written by Art Carpenter):
http://www2.sas.com/proceedings/sugi29/243-29.pdf
http://www2.sas.com/proceedings/sugi28/056-28.pdf
I'm not sure what you mean by #2 and #3 -- this is an instance where a concrete example or more explanation would be useful. Especially, what you mean by the phrase "enlist tables" in the sentence "Suggest a way to enlist tables that have a column containing string - ‘asset’" If you want to
find tables that have a column which contains "asset" as part of a column name, then you will want to search for previous forum postings on the use of the SAS Dictionary tables or the SASHELP "V" tables.
And, if this is a homework assignment, then your best resource is your professor or teaching assistant for the class.
cynthia