Select records proc sql

[jhh197]

Hi ,

Just wanted to check what extra step I need to add  to select 10 records from table1

PROC SQL;

   CONNECT TO odbc  as test

    (PATH=ksts  userid=ksdetail password=&hh);

            CREATE TABLE MyTable AS

            SELECT *

            FROM CONNECTION TO test (

                 SELECT

                       t1.ID

                      FROM Table1 t1

                   );

             DISCONNECT FROM test;

QUIT;

Can anyone help

Thanks

[SASKiwi]

Using your program this is the easiest way, not necessarily the most efficient:

PROC SQL;

   CONNECT TO odbc  as test

    (PATH=ksts  userid=ksdetail password=&hh);

            CREATE TABLE MyTable (obs= 10) AS

            SELECT *

            FROM CONNECTION TO test (

                 SELECT

                       t1.ID

                      FROM Table1 t1

                   );

             DISCONNECT FROM test;

QUIT;

[Tom]

The only TABLE1 in that query is in a remote database.

So you need to know what syntax that database allows for limiting the number of observations returned by a query.