Simple SQL select
This example creates the data set MyTable in ADaMSoft. Then the SQL step is called to create a data base in the ADaMSoft path MyDB (defined in "c:/temp"). The data base is named mydb and the content of MyTable will be copied in the data base.
In a next SQL step a SELECT will be executed; the results will be in ADaMSoft Output area.
In order to run this example just paste the following statements in the Command area and press the button: EXECUTE.
This example creates the data set MyTable in ADaMSoft. Then the SQL step is called to create a data base in the ADaMSoft path MyDB (defined in "c:/temp"). The data base is named mydb and the content of MyTable will be copied in the data base.
In a next SQL step a SELECT will be executed; the results will be in ADaMSoft Output area.
In order to run this example just paste the following statements in the Command area and press the button: EXECUTE.
|
path mydb=c:\temp; dataset out=mytable; newvar age=num; newvar name=text; age=19; name="John"; output; age=48; name="Marco"; output; run; sql dict=mytable outdb=mydb.db_test; run; sql outdb=mydb.db_test; select * from mytable; run; |