Creating Indexes on New Variables

[InfoAlisaA]

Hello Everyone,

I am trying to create an index on a new data set where I have a new variable.

Here is the code that I have so far:

data work.all_staff (index=Age_Hired);

  set orion.sales orion.nonsales;

  Age_Hired =(year(Hire_Date)-year(Birth_Date));

run;

So I am trying to create an index on the new variable Age_Hired, and I get the following message in my log:

ERROR 23-7: Invalid value for the INDEX option.

I am not sure where I am going wrong with this or if I cannot create a new index against a new variable (which would seem silly since that is a problem on my homework assignment )

Could someone please let me know where I am going wrong with my code?

Thanks,

Alisa

[Peter_C · Accepted solution]

even when we want only a single simple index, the data set option value should appear in  (parentheses), like

    index=(  age_hired )

[InfoAlisaA]

Hi Peter!

Thanks for letting me know what was wrong with my code.

Thanks!

Alisa