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 !
@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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.