Thanks, Uttam for the prompt reply...

Although upon following the procedure suggested by you and by looking at the SAS site about proc sqoop, we are not able to submit the oozie job, which ideally if submitted successfully should be visible on oozie web console. The URL for oozie web console is verified and is correct.
Could you please provide an insight if you have encountered such problem.
Should we do any modification on oozie-site.xml or any hadoop config xml files. Your quick response is appreciated and helpful for us.