DATA Step, Macro, Functions and more

SAS Index

Reply
Regular Learner
Posts: 1

SAS Index

1. I have a simple index defined on var1 in sas data set : one

2. when appending the data to the sas dataset in step1 with the new data set for ex: two the index that is already defined for the dataset one is lost.

 

please see the below code.

 

data class(index=(name/unique));    /* index created on name in the work.class*/
set sashelp.class;
run;

proc contents data=class;
quit;

data class1;  /* index is not there  in the work.class1*/
set class (where= (name = 'Alfred'));
run;

proc contents data=class1;
run;

data class;
set class class1 ;
run;

proc contents data=class; /* index is lost in work.class*/
quit;

 

kindly let me if I am doing some thing wrong.

Super User
Posts: 24,012

Re: SAS Index

Yes, since you’re creating a new data set. It happens to have the same name but that’s coincidental - and bad practice IMO. 

 

Try PROC APPEND or DATASETS

Ask a Question
Discussion stats
  • 1 reply
  • 100 views
  • 0 likes
  • 2 in conversation