Hi @Kurt_Bremser    Please see this example. I have inserted 2 additional blank rows under  ID=2. This fails when it has 2 or more consequtive blank rows.    I tried modifying firstobs value but it didnt work for second consequtinve blank value.    data have; infile datalines dsd dlm=" " truncover; input ID $ Sequence section $ value; datalines; 1 1 a 0 1 2 b 1 3 c 1 1 4 d 0 1 5 e 0 2 1 a 1 2 2 b 1 2 3 c 2 4 d 2 2 5 e 2 2 6 f 2 7 g 2 8 h 0 3 1 a . 3 2 b 1 4 1 a 0 4 2 b ; run; data want; set have; by id; set /* create a "look-ahead" */ have ( firstobs=2 keep=id value rename=(id=_id value=_value) ) have ( /* this is needed to prevent a premature end of the data step */ obs=1 keep=id value rename=(id=_id value=_value) ) ; _lvalue = lag(value); if not (first.id or last.id) and value = . and _lvalue ne . and _value ne . then desired = 999; else desired = value; drop _:; run; ... View more

Then we can ignore them. It is those missing values inbetween the rows with any value (0 or 1 or 2) must be assigned as 999.    If first or last is blank then we should ignore them.  ... View more

I want to assign 999 if the rows before and after the missing rows has any value (0 or 1 or 2).    For each ID.  ... View more

There is no chance for another value as it is predefined to have either 0 or 1 or 2 in this case.  ... View more

Thank you very much. ... View more

I have uploaded the data as a sas dataset. Please let me know if this helps.  ... View more

Hmm ok, I tried a lot of her @Cynthia_sas answers from the communities. Most of them are from report. May be @Cynthia_sas if you can help me achieve this. Would be of great help. Do you want me to raise a diferent question and tag you.  ... View more

Yeah, This is from proc document to assign labels to each object (TLF's). I am able to assign labels but cant suppress the next level bookmarks. I sthere a way to achieve this.  make temp; dir \temp#1; %do by=1 %to &bycnt; %let thispath=%scan(&bylist,&by,|); copy \itemlib.&thisitem.&thispath to ^; %end; setlabel \work.&thisitem\temp#1 "&bookmark"; run; ... View more

Hi, If my code looks right, I dont get the output like you have. I still get those extra "Table 1 and Table 2" bookmarks. in my output using the same code.    I am not sure how to control those second level nodes. I tried solutions from https://support.sas.com/kb/31/278.html here as well. but still i get them.    Please advise.      Thank you Bharath  ... View more

So I guess I am missing something in proc document procedure which generates bookmarks for next pages or items.    So is it the proc document procedure that generates bookmarks for every new item in a PDF ? ... View more