Hi,   I have the below requirement, I need to create dynamic averages example for rolling 3 months and compare with the selected month. Example: this month is Nov'19and sales total for Nov'19 is 20 and the rolling 3 month avg (last 3 month avg) is 25.   I have created an aggregated measure for rolling 3 months avg successfully. But, I need to set the threshold in graph not in table. For this I have taken Dual access line chart. One measure I have given Sales total and other I have given rolling 3 month Avg.   Data I have:   Prod_A_Sales  Prod_B_Sales   Month 5                            6                     Jan'19 10                         15                    Feb'19 20                         24                    Mar'19     What I need to showcase is a line chart or bar chart where bars will be product for any month. and a base ine or threshold line with Avg value.   I have used a bar line chart for this and tagged avg variable to the line. I am unable to stabilize the line straight with single value. please help how I can select _FORALL_ in the aggregated measure so that the threshold line will only show one average. like If I select Nov'19 from date filter. The product (bars) show nov totals and line will show (Aug, sep and oct avg) with st line. ... View more

I have a situation where I am showing performance trend. Inorder to show whether the trend is improving or declining I have two methods :   1. example, if I have a measure named Price and I need to show the color coding of trend. I want to show it based on monthly status. if this month- Agu'19 price is 2000 and the avg of price since last 6 months is 2500 then This month price will be in red. If next month is 2500 and the last 6 month avg is 2300 then that value will be in green.   2 If the price of this month is 2000 and last month it was 1800,then it will be in green.. compared to last month I will show in red or green   How is it possible to apply colors in SAS vA. I have tried all possible methods I know but no luck. Please help me with this..   Many thanks in advance. If this is not possible, any suggestions would be welcomed..   🙂 ... View more

Dear all,   My data has many KPIs (56 to be exact). I have a requirement that I need to create a search box where if I type the name of KPI the corresponding cross tab must display that column data. kindly let me know how can I achieve this..   Many thanks..         ... View more

Dear team,   I have a shared drive mapped in my networks. I am trying to get the list of file in various folders along with their formatslike whether the file is Pdf or doc or excel or an email message.   Request you to kinldy let me know if it is possible. IF yes, please advise how.   Thank you! ... View more

Dear all,   I have been facing an issue with one logic, I have a list of dates and amounts, I need to pick the max amount from a same date based on a name.. attached is the example. kindly help in finding the mistake here.. Thank you..       ... View more

Hi,  I got my system upgraded to windows 10 and sas upgraded to 9.4 and EG 7.1   I have got all the necessary plugins installed but when I try to run the below query it thorws the below error. xls or xlsx are not getting imported via query, but when I inport them from EG settings (file--> import file) it is getting imported:   Proc import datafile="c:\Users\ID\test\Sample.xlsx" out=sample DBMS=xlsx replace; run;   ERROR: DBMS type XLSX is not valid for import   same error occured when used excel or excelcs. Please advise ... View more

Hi,   I am trying to schedule my programs using SAS MANAGEMENT CONSOL, for that I need to set up the connection (LOCAL atleat as there is no server). When tried I get the below message: Please advise:   Connection failed Could not establish a connection to the SAS server on the requested machine. Verify that the SAS server has been started with the -objectserver option or that the SAS spawner has been started. Verify that the port Combridge is attempting to connect to is the same as the port SAS (or the spawner) is listening on. -------------------------- Technical Information Follows -------------------------- Exception Details: ---------------------------------------- Exception type: SAS.EC.Directory.Metadata.MetadataException Message: Connection failed Source: EC.Directory Target Site: MakeConnection Data: m_HostName : localhost m_Port : 8561 m_Userid : Sindu Stack Trace: at SAS.EC.Directory.Metadata.OMSProvider.MakeConnection() at SAS.EC.Directory.Metadata.OMSProvider.Connect() at SAS.EG.SDS.Dialogs.ProviderConnectDlg.Connect(Object sender, DoWorkEventArgs e) Inner Exception Details: ---------------------------------------- Exception type: System.Runtime.InteropServices.COMException Message: Could not establish a connection to the SAS server on the requested machine. Verify that the SAS server has been started with the -objectserver option or that the SAS spawner has been started. Verify that the port Combridge is attempting to connect to is the same as the port SAS (or the spawner) is listening on. Source: SASObjectManager Target Site: CreateObjectByServer Stack Trace: at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByServer(String Name, Boolean synchronous, ServerDef pIServerDef, String LoginName, String Password) at SAS.EC.Directory.Metadata.OMSProvider.MakeConnection() ... View more

Dear all,   I have been working on a project for the past few months which involved in gathering reports from 20 different countries (10 reports each approx) vis share point and importing, converting, calculating them in sas directly and the uploading the output file for each country in sharepoint location directly.    I have created 20 programs for each country in my EG (5.1) project and trigget the code manually as soon as the inputs are available.   Now, I need to deploy thos project to the support team so that they can run the codes going forward. We run the codes on local as we do not have any server set up. We have base sas and eg installed inour machines, we code and we run thats waht happened till now, But I want to change this. i want to build a server that grants access levels to support and dev according to their need. and this also helps in tracking if some one modifies anything in teh code. I want to create jobs for each program and deploy them, schedule them so that they can trigger automatically.   please help in designing all this by choosing the right softwares that i need to use (UNIX or Platform manager or DI Studio, SMC). i am new to this please advise.   Thankyou! ... View more