I am creating a pie chart to display the space utilized in each of the libraries in GB.  Firstly, I have created a query to get the list of all libraries and space utilized by each of them. By using proc gchart, I am creating a pie chart as well. But the pie chart only gives me the slices of space utilized , How do I get "Others" slice to display the space not utilised.   For example, if the total space available is 500GB, I want the pie chart to display space utilised by A, B, C, D and others.  How can we display the "Other" utilisation when my sql query will not have that detail. I know the total space available 500GB, do I need to calculate the other utilization manually. Please suggest.   My code is as follows:     proc gchart data=work.space_used_by_users; PIE libvar/ SUMVAR =space_used TYPE=SUM NOLEGEND PERCENT=OUTSIDE VALUE=NONE OTHER=4 OTHERLABEL="Other" COUTLINE=BLACK NOHEADING;   RUN; QUIT;   Chart created is attached. Here the total of all the slices sums upto 100%. But the others is missing.   ... View more

Hi, I have following query where we are pulling the data of current and next month for a particular year. proc sql; select id as from table1 A inner join table2 B on A.id=B.id where year(date)>=2017 and (month(date)=month(today())+1 or month(date)=month(today())); quit;   But this will not work for December (12+1 becomes 13). Please suggest how can the code work for December onward. Thanks   ... View more

Hi,   I have a query which gives the volume count of customers with A_ID=1 and B_ID=1. I also need the count of customers having both A_ID=1 and B_ID=1. I have updated the code as follows (in red). But this does not give me the desired results.   proc sql; select SUM(A_ID=1) as sum1, SUM(B_ID=1) as sum2, SUM(A_ID=1,B_ID=1) as sum3 from table A, left join table B on A.CUST_ID=B.CUST_ID ; quit;   My expected output is: sum1 sum2 sum3 20 10 10   Please advise.   Thanks ... View more

I have  a code to select data of current and next month (for a particular year). But this would not work in December, as the values of months picked up will be 12 and 13:   proc sql; create table test1 as select distinct id from table A where year(date)>= 2012 and (month(date)=(month(today()) + 1) OR (month(date)=month(today()))); quit;   So, now changed the code to following: proc sql; create table test2 as select distinct id from table A where year(date)>= 2012 and (month(intnx('month',date,0))=month(intnx('month',date,1,'s')) OR (month(date)=month(today())); quit;   The values month(intnx('month',date,0)) and month(intnx('month',date,1,'s')) are coming correctly when testing in sas dataset. But its not working in Proc SQL. The log says: SAS_SQL: Unable to convert the query to DBMS specific SQL statement due to an error. ACCESS_ENGINE: SQL statement was not passed to the DBMS, SAS will do the processing.   Due to this the counts are not matching for test1 and test2 results (expecting same result counts for rundate 23OCT2018).   Please help resolve this. ... View more

Hi,   I need to do some testing on a campaign which uses Map node. I need to verify if the counts are same as DB . I am testing the code in SAS EG.   I understand that map node does many to one /one to many conversion , but I am not able to replicate in SAS code. Please help.   Thanks ... View more

Hi all,   Recently we have created a new server which will be prod mirror and imported all the existing prod campaigns into it.   While testing the new server, the campaigns ran fine. But when linking the output to export node, facing error.   In the export node, an already existing export definition is added and new table name is added. After clicking 'ok' to save the node, the error message says: Please help me identify the issue here.   Thanks ... View more

Hi ,   While trying to import a csv file, encountered following error:   An error occurred executing the workspace job "The Import Data Wizard (Intermediate submit)". The server is disconnected.   Please help how to resolve this error.   Thanks   ... View more