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;
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.
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.