how to create an unique composite index in the data step?

[deleted_user]

Hi, All!

I want create an unique composite index in the data step for limit dumplicate rows inserted.

The Logic SAS Code may like following:

data work.wolf(index=(id name /unique ));
infile datalines dlm="|";
length id 8. name $10. age 8.;
input id name age;
datalines;
1|forest|10
2|forest|11
2|forest|12
3|forest|13
2|forest|14
;
run;

In the rows in the work.wolf as following:
1|forest|10
2|forest|11
3|forest|13

My SAS version is:9.2

[sbb]

Suggest you start with the SAS documentation and the SAS support http://support.sas.com/ website (free) resources.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

data step programming composite index site:sas.com

[SPR]

Hello Wolf,

If I understood you correctly this could be a possible solution:

data work.wolf(/*index=(id name /unique )*/);
infile datalines dlm="|";
length id 8. name $10. age 8.;
input id name age;
datalines;
1|forest|10
2|forest|11
2|forest|12
3|forest|13
2|forest|14
;
run;
proc sort data=wolf nodupkey;
by id name;
run;
proc datasets library=work;
modify wolf;
index create idn=(id name);
run;

Sincerely,
SPR