https://communities.sas.com/t5/SAS-Programming/how-to-create-an-unique-composite-index-in-the-data-step/m-p/22084#M3577 Suggest you start with the SAS documentation and the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website (free) resources.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument, this topic / post:<BR /> <BR /> data step programming composite index site:sas.com Mon, 25 Oct 2010 14:31:07 GMT sbb 2010-10-25T14:31:07Z https://communities.sas.com/t5/SAS-Programming/how-to-create-an-unique-composite-index-in-the-data-step/m-p/22083#M3576 Hi, All!<BR /> <BR /> I want create an unique composite index in the data step for limit dumplicate rows inserted.<BR /> <BR /> The Logic SAS Code may like following:<BR /> <BR /> data work.wolf(index=(id name /unique ));<BR /> infile datalines dlm="|"; <BR /> length id 8. name $10. age 8.;<BR /> input id name age;<BR /> datalines;<BR /> 1|forest|10<BR /> 2|forest|11<BR /> 2|forest|12<BR /> 3|forest|13<BR /> 2|forest|14<BR /> ;<BR /> run;<BR /> <BR /> In the rows in the work.wolf as following:<BR /> 1|forest|10<BR /> 2|forest|11<BR /> 3|forest|13<BR /> <BR /> My SAS version is:9.2 Mon, 25 Oct 2010 13:20:57 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-an-unique-composite-index-in-the-data-step/m-p/22083#M3576 deleted_user 2010-10-25T13:20:57Z https://communities.sas.com/t5/SAS-Programming/how-to-create-an-unique-composite-index-in-the-data-step/m-p/22084#M3577 Suggest you start with the SAS documentation and the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website (free) resources.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument, this topic / post:<BR /> <BR /> data step programming composite index site:sas.com Mon, 25 Oct 2010 14:31:07 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-an-unique-composite-index-in-the-data-step/m-p/22084#M3577 sbb 2010-10-25T14:31:07Z https://communities.sas.com/t5/SAS-Programming/how-to-create-an-unique-composite-index-in-the-data-step/m-p/22085#M3578 Hello Wolf,<BR /> <BR /> If I understood you correctly this could be a possible solution:<BR /> <BR /> data work.wolf(/*index=(id name /unique )*/);<BR /> infile datalines dlm="|"; <BR /> length id 8. name $10. age 8.;<BR /> input id name age;<BR /> datalines;<BR /> 1|forest|10<BR /> 2|forest|11<BR /> 2|forest|12<BR /> 3|forest|13<BR /> 2|forest|14<BR /> ;<BR /> run;<BR /> proc sort data=wolf nodupkey;<BR /> by id name;<BR /> run;<BR /> proc datasets library=work;<BR /> modify wolf;<BR /> index create idn=(id name);<BR /> run;<BR /> <BR /> Sincerely,<BR /> SPR Mon, 25 Oct 2010 14:43:28 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-an-unique-composite-index-in-the-data-step/m-p/22085#M3578 SPR 2010-10-25T14:43:28Z