BookmarkSubscribeRSS Feed
Dozo92i
Fluorite | Level 6

Hi everyone, I wondered  if the index is kept while overwriting an indexed data set ?

 

for example:

 

data MyIndexedTable;

   set MyIndexedTable;

   newColumn=2*oldColumn;

run;

 

If it is not possible to keep indexes that way, how can I manage to update my table by keeping its indexes ?

Thanks in advance !

3 REPLIES 3
Kurt_Bremser
Super User

@Dozo92i wrote:

Hi everyone, I wondered  if the index is kept while overwriting an indexed data set ?

 

for example:

 

data MyIndexedTable;

   set MyIndexedTable;

   newColumn=2*oldColumn;

run;

 

If it is not possible to keep indexes that way, how can I manage to update my table by keeping its indexes ?

Thanks in advance !


Try it.

Run a proc contents before and after, and you'll have the answer.

Kurt_Bremser
Super User

Example code for the test:

data work.class;
set sashelp.class;
run;

proc datasets library=work nolist;
modify class;
index create sex;
run;
quit;

proc contents data=work.class;
run;

data work.class;
set sashelp.class;
run;

proc contents data=work.class;
run;
LinusH
Tourmaline | Level 20
Data step with MODIFY would work.
Perhaps SQL UPDATE as well.
Not sure though if this will perform as fast as data step SET and rebuild index.
Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 795 views
  • 2 likes
  • 3 in conversation