By admin | August 24, 2009

SAS Certified Adv Programmer 50 Questions (49)

Which one of the following SAS programs is the most efficient in producing and removing an index from a SAS data set?

a.

proc datasets lib=sasuser;
    modify houses;
    index create style;
    index delete location;
quit;

b.

proc datasets lib=sasuser;
    modify houses;
    index delete location;
    index create style;
quit;

c.

proc datasets lib=sasuser;
    modify houses;
    delete index location;
quit;
proc datasets lib=sasuser;
    modify houses;
    create index style;
quit;

d.

proc datasets lib=sasuser;
    modify houses;
    delete index location;
    create index style;
quit;

2 comments | Add One

  1. admin - 08/24/2009 at 10:52 am

    B

  2. Consty - 02/13/2013 at 11:38 am

    B: we should delete the old index before creating a new one

Leave a Comment

Leave a Reply

Your email address will not be published. Required fields are marked *