here my requirement is need to check the tble if it isfound need to display error message other wise need to continue prevuiosly what is going on here ,, example program....i was adding middle of the program
else if a=X then
if d¬=' 'then **sql query**
when(0)
display error message;
when(100) return;
if dp=' ' then
some if condition
else do;
'''''''
end;
else do;
..............
end;
else
if a= q then
if d¬=' 'then **sql query**
when(0)
display error message;
when(100) return;
if dp=' ' then
some if condition
else do;
'''''''
end;
else do;
..............
end;
else
if a= q then
here ELSE clause outside of an open IF-THEN statement is ignored
here my enhancement is if we select as a='X'
need to check table then 100 need to continue....
so please help me is there any other way to code the statements......
