Hi,   I have a SAS work table where I'm generating a stacked bar graph out of that. For the graph, X axis will be date value. Also the stack will be a character value and sum will be the numeric value.   Actually in the sas table, I have around 10 date values but in the graph I'm getting only 7 bars and also the date ( X axis) is not exactly the same as in SAS table.   Not able to differentiate which bar belongs to which date? I'm using SAS EG 7.13 directly for generating the  bar, not writing any sas code.   Kindly advice to overcome this issue.   ... View more

Hi,   We have a macro defined in autoexec under Stored Process server and I have changed that macro for my new requirement and restarted the object spawner.   But still the macro is not reflected correctly and its point to the old variable. What serrvice restart I have do now?   I have done the full restart. Please let me know.   Thanks ... View more

Hi,    I have a requirement to  truncate all the tables in DB2 environment from SAS. I have written a below query in a loop and I'm facing few issues.   proc sql; connect to DB2(datasrc=XXXXX authdomain="XXXXX"); select * into :tablename from connection to db2 ( select tabname from SYSCAT.TABLES where TABSCHEMA = %str(%')%upcase(TEST)%str(%') and TYPE = %str(%')%upcase(T)%str(%') ); disconnect from DB2; quit; %let tablename1 = &tablename.; %macro truncate_table; %do i = 1 %to &tablename1.; proc sql; connect to DB2(datasrc=XXXXX authdomain="XXXXX"); exec ( truncate table TEST.&tablename1. immediate ); disconnect from DB2; quit; %end; %mend; %truncate_table;   Below is my error message   ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &tablename1. ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro TRUNCATE_TABLE will stop executing.   Please let me know where I went wrong. Thanks ... View more

Hi,   Currently in one of the sas job, I'm getting a Sas warning and that throws an error in my SAS DI job. But I got the desired output even after my job gets aborted/warnings. So I don't want to do any code changes because of this warnings. Planned to suppress the wanings at job level using the return code.   Is there any possible way to have a small part of sas code at the end of the sas job to check the return code ( i.e. warning rc) and then change the return code to mark the job as successful?   Thanks in advance.     ... View more

Hi,   I'm trying to establish a connection from SAS Platform (runs in latin9) to one of the DB2 source system. But I'm getting a following error   ERROR: CLI error trying to establish connection: [IBM][CLI Driver] SQL0332N Character conversion from the source code page "0" to the target code page "923" is not supported. SQLSTATE=õ÷ðñ÷   So I tried an option of defining a DB2CODEPAGE as 819 in level_env_usermods.sh file and then ran the same libname statement and it ran successfully.   But i dont want to set this codepage in the config file because we are connecting multiple DB2 system from SAS and only one DB2 system has this problem. I'm thinking to define the DB2CODEPAGE in the SAS EG session (code) before invoking the libname statement. I have tried with below option   options set=DB2CODEPAGE=819; libname test DB2 datasrc=xxx .............................   but ended up in the same error. How to rectify this problem. Please let me know.     Thanks ... View more

Hi,   I'm exporting data from the sas dataset into .txt file with preserving leading spaces. In the sas dataset there are around 50 columns and only one column (REF) has leading spaces.   filename XAB "&SOURCE_FILE"; data _null_; set TEMP_XAB; file XAB dsd dlm='|'; put (_all_) (+0)  REF $char15.;; run;   But if I have the code as like above, it creates an extra column with leading spaces for REF column in txt. file. Even I will not able to put all the 50 column names and only for that REF column will have that char format in the put statement.   Is there any possible way to have that only column as format char string and the remaining column as it is from the dataset before creating the .txt file.   Thanks   Thanks      ... View more

Hi ,   I'm getting an error in SMC library while trying to display the libname statement. Its prompting for a username & password. Its a DB2 library.   Below steps I have followed 1) Logged in using unrestricted user (Sasadm@saspw) 2) created a new DB2 server under server manager and provided all the  details with the new authdomain(Eg: DB2Auth) 3) created a new DB2 library with the same server detail and provided default login as none. 4) I have added the username and password for that authdomain in the sas group where I belongs to.   When I logged on with my credentials and try to display libname for that library , its prompt for the username/password.   I assume it should automatically consider the credentials from the group where I belongs for that authdomain.    Library is stored in the folder where i have full privileges, but in SMC the library shows as read only mode(for me) . I dont know where I'm lagging permission.   Please guide me. Thanks       ... View more