I suspect you need to move the indsname = DataSource option to outside of the dataset option parenthesis and only use it once. indsname is a set statement option. Try something like this: Set dataset1(rename = (..........)) dataset2(rename = (..........)) . . datasetn(rename = (...........)) indsname = DataSource ; You might consider using KSharp's sql coding. The only downside to that is the need for a column within the individual datasets which can identify the year. You might have that (I did not do a review of the structure of your data). If that is not available then for each of the select statements in the sql, you would need to add field to which a constant is applied. Using KSharp's code, then something like: proc sql; create table want as select LangClsCode02 as LangClsCode, ELIdentDate02 as ELIdentDate, StdELRedesigDate02 as StdELRedesigDate, StdDob02 as StdDob, Gender02 as Gender , Ethnicity02 as Ethnicity , HomeLang02 as HomeLang, FRLunch02 as FRLunch, ParentEduLevel02 as ParentEduLevel , US1stSchoolDate02 as US1stSchoolDate, CA1stSchoolDate02 as CA1stSchoolDate, GradeFirstEnroll02 as GradeFirstEnroll ,2002 as year from Demog01_02 union select *, 2003 as year from Demog02_03 union select *,2004 as year from Demog03_04 union .......... ; quit;
... View more
