I did not make myself very clear. I need to use PROC GCHART. I want to go to/from: ... View more

we are using 9.4M3. Will look at your blog. Thanks. ... View more

I will give it a try. I will also look at the SGPLOT options. ... View more

see the sample JPG I posted in the response to the previous response ... View more

Right now, I have this:   The request is to replace all the mm/yyyy with one mmyyyy value for each quarter. ... View more

Actually found the issue was not related to how I tried to access the table. The instances actually has two database owners. i put in the correct owner in the "schema'" of the libname and all worked. Thanks for all the suggestions. ... View more

I am using OLEDB instead of ODBC. However, i tried these option in the init_string, in provider_string, etc. They gave no errors, but I still get the error "ActivityEntry.Entry is an invalid table name......." ... View more

I did try 'ActivityLog.Entry'n. It let me assign the value to a variable with no problem. However, I still got the error "table name not recognized" when I used the variable in either a SET or a "Select..." statement. ... View more

still did not work. Posting the code snippet and errors. ... View more

Did not work.   Here is a code snippet   libname LumenDB OLEDB init_string="................" schema=dbo; %global LUMENTABLE; data _null_; lumentable='ActivityLog.Entry'n; call SYMPUT("LUMENTABLE",lumentable; run; . . . proc sql;   create table Lumen1 as     select EntryID, UserID, ServerID          from &LumenDB..&LUMENTABLE; run; quit;   also tried: data temp;   set &LumenDB..'ActivityLog.Entry'n; run; quit;   Neither of these worked. Got the ActivityLog.Entry is not a valid SAS name. ... View more