Does SGID allow users to execute a binary compiled program?

Not, the execute bit does that.

00100 - execute for user
00010 - execute for group
00001 - execute for others

04000 - set-uid
02000 - set-gid