Hi Cynthia proc sql; create table ccar.Tracking as select *, monotonic() as rowid from ccar.level_5_skillgroupid_null; quit; Above proc sql creates the table i am after with rowid. My append query below returns error variable rowid was not found in data file. proc append Base =ccar.tracking Data = Dupes_virtual_queue force; run; Please if you have a better solution let me know , been working with this all day. fred ... View more

Please look at my code and the resulting error proc sql; create table ccar.Tracking as select *, monotonic() as rowid from ccar.level_5_skillgroupid_null; quit; When i attempt to append data i get this error variable id was not found in data file Help please. Fred ... View more

Hi I've been looking all morning on google and archive, can't seem to find what i'm looking for; Fred ... View more

Hi proc append Base =tracking Data = Dupes_virtual_queue force; run; Thanks Fred ... View more

Hi everyone I used this code and it worked, finally. proc sort data= ccar.hierarchy out=ccar.out; where SiteID = 80; by Level_7_id; run; data single dup; set ccar.out; by Level_7_ID; if first.Level_7_ID and last.Level_7_ID then output single; else output dup; run; Fred ... View more

Thanks, please see resulting error ERROR 455-185: Data set was not specified on the DATA statement. Fred ... View more

Ok below is what i am using, it only keeps the first record and deletes the other. proc sort data= ccar.hierarchy out=ccar.out nodupkey dupout=ccar.dupes_Level_7_ID; where SiteID = 80; by Level_7_id; run; Fred ... View more

Thanks everyone ... View more

Hello again I'm looking for some doc. to help explain how the format percent12.2 works How do i figure out to apply 12.2 or 8.1 or what? If you can lead me to some information that would be great, i've looked online but can't find anything. Thanks again. Fred ... View more

Thanks user4sas this was helpful, thanks for the example. Fred ... View more