This points to a damaged dataset file. The information stored in the first page of the dataset file points to more pages than the file actually contains. This can happen when you run out of disk space while writing to a dataset, or if some kind of data transfer/copy terminated prematurely. If the dataset in question was created by an earlier step of the same program, read your log from top down. The most important message (ERROR/WARNING or unexpected NOTE) is always the first one, the last one is least important. Fix the first issue, and all others might already go away also. If your dataset comes from other code, read that log(s). ... View more

If you are getting more observations per group than you expected then your grouping variables are not unique. It might be there are a lot of observations with missing values or one or both of your key variables. It might be your variables are too short. Or you tried to stuff a 20 digit string into a number instead of character variable. ... View more

data have; input group flag; cards; 1 . 1 . 1 1 1 . 2 . 2 . 2 . 3 . 3 1 3 . 3 1 3 . 3 . ; proc sql; create table want as select *,max(flag)=1 as new_flag from have group by group; quit; ... View more

yes that works. I was using an array. thank you. ... View more