About Anand6666

Anand6666 · ‎08-28-2018

I have a requirement to create a VA report with monthly data snapshot. The report should have a List report which gets populated with a months data based on month value (drop down control). How to create such a report where the report maintains monthly history snapshot

Anand6666 · ‎09-12-2017

Thanks a ton Kurt for the quick response . I tried both approaches and both worked fine .

Anand6666 · ‎09-12-2017

Thanks Kurt for the update, got a lead to explore. After importing the excel data into sas dataset, i tried the renaming option but column name contains space between it instead of '_' hence causing the code to fail. Error: Expecting an =. is there any way i can rename the column - Name type -> Name_type. Have attached a screenshot of the column name for reference.

Anand6666 · ‎09-12-2017

Hi, i have an xls file from which records needs to be extracted for loading to DB table. SAS by default has provided an extraction script which uses XLS engine for importing the data. I require the column names in the excel to be renamed before the extraction script is run. Is there any sas code to rename the column on the file. Any pointers to this would be helpful

Anand6666 · ‎03-10-2017

Hi, we have CTR and SAR reports(E -filing) provided by SAS AML solution for US clients and we are trying to modify the UI and workflow in order to suit it for an Australian client, but the SAS documention on UI customization is not proper. Our initial plan was to change/modify the UI fields getting displayed by modifying the rr-fincen-sar-01.xml and adding field to custom table in DB but still the UI customization is not proper, no input text box is comming up and nor is the new UIdefinition file getting updated. Kindly advise and share if any documentation on UI customization is Available for Anti money laundering solution.

Anand6666 · ‎08-12-2015

Hi Michelle, I tried and checked the manual steps available , for HTTPS conversion. checked the hostnames and Secure checkbox in SAS Foundation Services , validated the SAS content settings from SMC, checked the SSL certificates but still unable to upload documents. our environment without SSL can upload documents, its only after implementing SSL that we are facing this issue. Is there any other alternatives . Have contacted the SAS support but they are taking time and we need to resolve this at the earliest as this is showstopper for our GOLIVE. All the help is appreciated

Anand6666 · ‎08-10-2015

Hi, SAS 9.3/AML5.1 When we try to upload a document in the AML UI, we get the below error .This was working fine prior to SSL implementation , we could upload and view the documents. However once SSL was implemented, we are unable to upload documents or view the old documents that was uploaded before SSL. We receive the below error during upload : Failed to create folders in DAV: Previously failed to connect to https://ant1amlwebs01.banktst.ae:8443/SASContentServer/repository/default/sasdav for sastrust@saspw In SMC , all the names have been updated to full host name. In jboss server start .sh files too we have updated the host. If opened in a separated IE, the above link opens correctly. I am also able to access the http://server:port/SASContentServer/dircontents.jsp page seperately. In SMC, webdav properties has the “secure” checkbox checked in the below services: Remote Services SASBIPortlet4.3 Local Services SASJSR168RemotePortlet4.3 Local Services SASPackageViewer4.3 Local Services SASPortal4.3 Local Services SASStoredProcess9.3 Local Services SASWebReportStudio4.3 Local Services Let us know what could be the issue here.

Anand6666 · ‎08-10-2015

Hi, SAS 9.3/AML5.1 When we try to upload a document in the AML UI, we get the below error .This was working fine prior to SSL implementation , we could upload and view the documents. However once SSL was implemented, we are unable to upload documents or view the old documents that was uploaded before SSL. We receive the below error during upload : Failed to create folders in DAV: Previously failed to connect to https://ant1amlwebs01.banktst.ae:8443/SASContentServer/repository/default/sasdav for sastrust@saspw In SMC , all the names have been updated to full host name. In jboss server start .sh files too we have updated the host. If opened in a separated IE, the above link opens correctly. I am also able to access the http://server:port/SASContentServer/dircontents.jsp page seperately. In SMC, webdav properties has the “secure” checkbox checked in the below services: Remote Services SASBIPortlet4.3 Local Services SASJSR168RemotePortlet4.3 Local Services SASPackageViewer4.3 Local Services SASPortal4.3 Local Services SASStoredProcess9.3 Local Services SASWebReportStudio4.3 Local Services Let us know what could be the issue here.

Anand6666 · ‎06-25-2015

Thank you Paul, the macro variables &_METAPERSON &_METAUSER served my purpose. I was able to get the logged in user details with these macros . thanks

Anand6666 · ‎06-25-2015

Hi, I have created new reports needed for client and linked it to the reports tab in SAS AML frontend V5.1 . At present i am unable to find any conditions in Management console to disable the reports tab based on user capabilites. Hence i am trying to create a logic wherein the session username/userid is captured in the first page before the SAS stored process of second page is loaded and then the username/userid is checked if belonging to a group with sufficient privileges and then the net set of stored process executed. Now once the control is transferred to stored process, the username becomes admin username as we are implementing token authentication. i want to know if i can get the session username/userid in the first page itself in html/javascript so that i get the logged in user details before it is converted into token. Kindly help me Do provide your insights. Thanks in advance

Anand6666 · ‎04-20-2015

Hi, I have been writing a report in SAS using HTML frontend. 1) I am calling a Stored procedure from another stored procedure and basically want the value of a variable defined in the first STP to be available in the called STP. I tried declaring the variable as GLOBAL but I am unable to get the value to the second STP. 2) How to set the value of a macro variable inside javascript. when I try to do so, it throws javascript error. Code: %global case; %let case=1; data _null; file _webout; input; line=resolve(_infile_); put line; cards4; <html> <head><script> function getvalues() { var case=2 alert("&case"); } function performAction(actionType) { if(actionType.value=="GENERATE") { { var adsbmt=window.confirm("Please Wait while the System Searches for Confirmed Details!!"); } if (adsbmt) {document.getElementById("_PROGRAM").value="/test/Training/php_test"; document.ADD_SHARE.submit(); }'; }} </script></head> <body onload="getvalues()"><h1 align="center" >Report</h1> <form name="ADD_SHARE" method="POST" action="http://****/SASStoredProcess/do"> <INPUT TYPE="HIDDEN" NAME="_PROGRAM" ID="_PROGRAM" VALUE=""> <br><br><table> <tr><td> Enter NAME</td><td> <input type="text" name="name"><BR> </td> </tr> <tr></tr> <table> </table> </td> </tr> <tr> <td><font size="1" face="Verdana"><CENTER> <input type="button" value="GENERATE" name="btn_update" id="GENERATE" onclick="performAction(this)" style="font-family: Verdana; font-size: 10pt; font-weight: 700"></font>'; </td> </tr> </table> </form> </body></html> ;;;; run;

Anand6666 · ‎04-15-2015

Hi Kurt, I had to prepare a report in SAS incorporating HTML. I have made use of textboxes and dropdowns using macro variables as their input, setting the value of the form elements with macro variables in javascript. I concatenate values from dataset into a macro variable and call the macro variable in the HTML statement and it has been working so far. I have been trying to use the same idea for displaying the table. defining a proc print statement inside a macro and then calling the macro in the HTML. sample code: %macro test ; proc report data=dataset; title test; run; %mend test; data _null; input; put line; cards4; <html> <head> </head> <body> <form name="ADD_SHARE" method="POST"> <br> <table> <tr><td> %test </td></tr> </table> </form> </html> ;;;; run;

Anand6666 · ‎04-15-2015

Hi, I tried using a proc print and a proc report by defining the PROC statements in a macro and then calling the macro in the HTML part. but the HTML treats the statements inside as text and just displays the statements on the screen rather than to execute them. Can you suggest any commands or functionality to execute the macro statements.

Anand6666 · ‎04-14-2015

Hi Kurt, I am using Stored process for the HTML page, since I have to use macros. Could you elaborate on your idea. I didn't quite understand on how to proceed.

Anand6666 · ‎04-14-2015

Hi, I need to just display data from a table depending on a condition on to the HTML page. I am not sure how I can do that with within the HTML tags.. like I am displaying the database/dataset details as a column of a HTML table element. Any hints as to how I can achieve it.

Online Status	Offline
Date Last Visited	‎06-22-2021 07:03 PM

Create report to use history snapshots

Re: Rename excel column name

Re: Rename excel column name

Rename excel column name

UI customization for AML 6.3

Re: Document upload failing after SSL implementation

DOC upload failing after SSL implementation in SAS AML

Document upload failing after SSL implementation

Re: Need Session USERNAME for restricting permissions

Need Session USERNAME for restricting permissions

Re: Rename excel column name

Re: Assign Macro variable value to HTML text box

Create report to use history snapshots

Re: Rename excel column name

Re: Rename excel column name

Rename excel column name

UI customization for AML 6.3

Re: Document upload failing after SSL implementation

DOC upload failing after SSL implementation in SAS AML

Document upload failing after SSL implementation

Re: Need Session USERNAME for restricting permissions

Need Session USERNAME for restricting permissions

Setting value for a variable inside javascript

Re: insert a table into HTML page

Re: insert a table into HTML page

Re: insert a table into HTML page

Re: insert a table into HTML page