topic Re: Select records proc sql in SAS Programming

Select records proc sql

jhh197 — Sat, 26 Oct 2019 00:22:47 GMT

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

Re: Select records proc sql

SASKiwi — Sat, 26 Oct 2019 01:31:46 GMT

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;

Re: Select records proc sql

Tom — Sat, 26 Oct 2019 13:21:47 GMT

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.