I solved my own problem just now. It's probably not the most efficient but it works. Sample data attached. Sample code below gives the desired result. /*Pull ID and create UserID and UserName from source data*/ proc sql; create table TestIDs as select ID as UserID, catx('', 'Test', ID) as UserName from DashboardVars; quit; /*appends the file by the number of IDs in the file; also create new ID variable*/ data TestIDs2(drop=i); set TestIDs; do i = 1 to 28; ID = i; output; end; run; /*if UserID and ID match, then it is assigned MyGroup*/ data TestIDs3; set TestIDs2; if UserID = ID then Group = "MyGroup"; else Group = "Others"; run; /*left join original source file by ID*/ proc sql; create table DashboardVarsNew as select t1.*, t2.* from TestIDs3 t1 left join DashboardVars t2 on t1.ID = t2.ID order by UserID, ID; quit;
... View more
