Date:         Thu, 4 Mar 2010 13:11:38 -0500
Reply-To:     Randy Herbison <RandyHerbison@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Randy Herbison <RandyHerbison@WESTAT.COM>
Subject:      Re: SAS AF Table Viewer and Data Model, select a row question.
Comments: To: Red Eagle <rdb1956@HOTMAIL.COM>
In-Reply-To:  <scmdneH--oHzsRLWnZ2dnUVZ_jWdnZ2d@giganews.com>
Content-Type: text/plain; charset="us-ascii"

Hi,

Here's one way:

1.  Use the SAS data set model's _findRow method to find the row (_findRow uses WHERE clauses).
2.  Use the table viewer control's _selectRow method to select the row.

dcl list findList={} rowlist={},
    num  rc
;

find_n_selectRow:
   row=1;
   rc=insertc(findList,'name="Jane"',-1);
   sasdataset1._findRow(findList,row);
   rc=clearlist(findList);
   if row > 0 then do;
     rc=insertn(rowlist,row, -1);
     tableviewer1._selectRow(rowlist);
     rc=clearlist(rowList);
   end;
return;


-Randy


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Red Eagle
Sent: Wednesday, March 03, 2010 10:44 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SAS AF Table Viewer and Data Model, select a row question.

I have a SAS AF Table Viewer with a Data Model displaying a SAS dataset very
nicely. In the SAS Help it says that a row on the table can be selected by SCL
at run time. My simple question is How? I want to be able to take the user back
to a row which they previously selected, and to do that I would like to have
that row displayed as if they had selected it. There is a field on the table
which contains unique values, so it should be easy enough; but How? _setSelect
would seem useful but How to use it, if it can be used? Using SAS 9.? on a PC.
Thanks for any help!