SAS Support Communities

I have base dataset with date field 4 byte. I want to append records to it which has the date field 8 byte. can anyone help me how to convert 8 byte number to 4 byte which will hold the same date. Thank You, Durga. ... View more

Hi Team, How to create password protected excel (.xls) file in unix using sas? ... View more

Hi Everyone, We have SAS job which is connecting to DB2 database, and the job runs every day in unix environment. Here we are facing problem that, DB2 database is getting down quite freqently (1 or 2 times in a weekly). For that, we are re-running the job manually. Question is, Can we put some logic so that when the connection fails(database is down), Query can re-connect after 15 min and till the time job need to be in ideal state. Thanks in advance! ... View more

We have SAS job which is connect to Oracle  to load data using Libname. But this connection is creating unnecessary process in Oracle environment and that process is creating and executing the below query: SELECT OBJECT_NAME, OBJECT_TYPE FROM ALL_OBJECTS OBJ WHERE (OBJ.OWNER = 'SCHEMA') AND (OBJECT_TYPE = 'TABLE' OR OBJECT_TYPE = 'VIEW' And this process is not completing even though actual SAS job is completed in SAS environment. It is causing some performance issues in Oracle side. Could some one help me, how we can restrict to not to create Oracle process which is creating above query. Thanks in Advance!! Durga. ... View more