Hello All,   I am getting an error as below while exporting a data query from sas SMC,Though i have unrestricted access. INFO - Log file created: C:\Users\SOduru\AppData\Roaming\SAS\Logs\Export_170517161534.log INFO - Current Time: 17 May 2017 4:15:34 PM INFO - User Name: SOduru INFO - ******** Analyzing Objects ******** INFO - ******** Starting Export Process ******** INFO - Exporting objects to package: C:\Users\SOduru\Documents\Package8.spk INFO - Exporting the following objects: 1 Visual data query object: /Shared Data/ETL_JOBS/Vault/DataQuery/CUSTOMER_ADDRESS_DQ INFO - ******** Exporting Metadata ******** INFO - Metadata exported successfully. INFO - ******** Exporting Content ******** INFO - Exporting content for Visual data query objects. INFO - Reading content for visual data query "CUSTOMER_ADDRESS_DQ" ERROR - Could not retrieve the database information for visual data query "CUSTOMER_ADDRESS_DQ". Reason java.util.Hashtable.put(Hashtable.java:514) com.sas.databuilder.metadata.QueryDbUtil.updateContext(QueryDbUtil.java:200) com.sas.databuilder.metadata.QueryDbUtil.setConfiguration(QueryDbUtil.java:231) com.sas.databuilder.metadata.QueryDbUtil.getQuery(QueryDbUtil.java:420) com.sas.databuilder.metadata.QueryDbUtil.getQueryReader(QueryDbUtil.java:505) com.sas.databuilder.metadata.VisualDataQueryExportListener.exportContent(VisualDataQueryExportListener.java:111) com.sas.metadata.promotion.ExportHandler.exportContent(ExportHandler.java:596) com.sas.metadata.promotion.ExportHandler.runExport(ExportHandler.java:519) com.sas.metadata.promotion.visuals.ExportExecutePanel$ExportThread.launchOperation(ExportExecutePanel.java:76) com.sas.metadata.promotion.visuals.AbstractExecutePanel$ExecutionThread.run(AbstractExecutePanel.java:437)   Please kindly help me to resolve this issue.   Thanks & Regards, Sandeep.o ... View more

Hello, I have a string like POST 1234 ST NO 50. I need the string to be standardized as POST 1234 STREET NO 50.In the strings i need to change only ST as STREET.   Many Thanks In Adavnce For Your Response, Sandeep ... View more

Hello, I have a macro variable with value as %let Alert=2017-01,2017-02,2017-03; I need to resolve this macro value in proc sql code. Example: Proc sql; select * from Alerts where alert in("&Alert"); quit;   But for using this macro i need to put single quotes to the value of a macro and also the macro value is dynamic and it depends upon number of records in a column (Alert).   Many Thanks In Advance For Your Reply ... View more

Hi Team,   I am trying to execute below code,but i am getting an error as  ERROR: Failed to generate matchcode. ERROR: DF_ERROR_FILE_NOT_FOUND   data dsn; name='sandeep'; run; options DQLOCALE=(ENIND) DQSETUPLOC="E:\SAS\SASHome\SASFoundation\9.4\dquality\sasmisc\QltyKB\sample" ; proc dqmatch data=dsn out=out_db1 matchcode=match_cd locale='ENIND'; criteria matchdef='Name' var=name; run;   I have checked all the license for Data quality,everything is fine. But i am not able to generate a matchcode.Your reply is most helpful for me. Thanks In Advance, Sandeep  ... View more