cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dav_amol
‎10-06-2023
  • 19 Posts
  • 1 Likes Given
  • 0 Solutions
  • 4 Likes Received

Finding most stable cluster from time series data

by Calcite | Level 5 in Statistical Procedures
‎02-26-2018 01:44 PM
‎02-26-2018 01:44 PM
I have 2 years stock market time series data comprising stocks return data. I am averaging returns on monthly basis and then using K means clustering method to get clusters for each month. So for first 1 year I am performing cluster analysis 12 times  . However due to volatile stock performances  I am getting stocks getting assigned to different clusters. How can I identify all the stocks which remains together in one cluster through whole 12 months period ?      Could you please recommend best method to find most stable cluster over period of 12 months ?  Regards,  Amol Deshmukh ... View more

Re: Displaying results in frame

by Calcite | Level 5 in Developers
‎11-15-2016 06:50 PM
‎11-15-2016 06:50 PM
Hi,       Thanks for the response. This was really helpful. However when I tried to use this solution , It is taking me to index page of SAS Stored process Web Application instead of displaying the form in leftside iframe. Could you please help me to resolve this issue and display the form in left frame ?  Here the Stored process DMM_Map_Visualization3 generates the form with custom inputs and code is given earlier. We are trying to execute that stored process in leftside frame so that it will display the form in left window. However it's always displaying index properties window listing sample stored processes.     My code is as given below :   %let stpname=/Prod/Market Monitoring/Stored Processes/Test/DMM_Map_Visualization3; data _null_; format infile $char256.; input; infile = resolve(_infile_); file _webout; put infile; cards4; <HTML> <head><title>Frame test</title></head> <table style="width:100%"> <tr> <td width="50%"> <iframe scrolling="no" width="100%" height="1000" src="http://sasprod:40356/SASStoredProcess/do?_program=&stpname.&_action=form,properties,newwindow,nobanner&_target=rightside" name="leftside"> </iframe> </td> <td width="50%"> <iframe src="" name="rightside" width="100%" height="1000"> </iframe> </td></tr> </table> </HTML> ;;;; run; ... View more

Displaying results in frame

by Calcite | Level 5 in Developers
‎11-03-2016 01:07 PM
‎11-03-2016 01:07 PM
I have created a web application using 2 stored process to fulfill dynamic and cascaded prompt requirements. First Stored process creates a HTML form which allows users to input all the parameters. After clicking Submit button , this form gets submitted and executes another stored process which generates the chart corresponding to given input parameters. This web application works as expected.        However now we want to have given form and chart to be displayed on same page . ( say form generated with first Stored process on left side and output chart in rightside. ( something similar to SAS Dashboard ) . Could you please help us to achieve this goal?    code generating Form is as given below :    /* This stored process creates a custom HTML FORM that is */ /* used to execute another stored process. */ /* */ /* Insert your HTML statements after the CARDS4 statement. */ /* Modify the "%let stpname" statement to specify the name */ /* of the next stored process that is to be executed. */ /* Any macro variables in the INPUT cards will be resolved */ /* if the values are known. */ /* stpname is the name of the next stored process to be executed */ %let stpname=/Stored Processes/Test/Custom_Map_v4; data _null_; format infile $char256.; input; infile = resolve(_infile_); file _webout; put infile; cards4;   <!DOCTYPE html><html class=''> <head> <meta http-equiv="X-UA-Compatible" content="IE=7,8,9,11"> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link href="/MapVisualization/css/custom_Maps.css" rel="stylesheet"> </head> <body> <div class="container"> <form class="well form-horizontal" ACTION="&_URL" id="contact_form" METHOD = "post"> <INPUT TYPE="HIDDEN" NAME="_program" VALUE="&stpname"> <fieldset> <div class="form-group trade_date required" data-cid="trade_date"> <label class="control-label col-md-2 requiredField" for="trade_date">Trade Date <span class="asteriskField"></span> </label> <div class="col-md-4"> <div class="input-group date"><span class="input-group-addon left"><i class="fa fa-calendar"></i> </span> <input type="text" class="form-control datepicker" id="trade_date" name="trade_date" value="" data-rule-required="true" data-datepicker-format="mm/dd/yyyy" /> </div> </div> </div> <!-- Select Market Type --> <div class="form-group"> <label class="col-md-2 control-label">Market Type </label> <div class="col-md-4 selectContainer"> <div class="input-group"> <span class="input-group-addon"><i class="glyphicon glyphicon-list"></i></span> <select name="market_type" class="form-control selectpicker" > <option selected value="DA">DA</option> <option value="RTPD">RTPD</option> <option value="RTD">RTD</option> <option value="HASP">HASP</option> </select> </div> </div> </div> <!-- Button --> <div class="form-group"> <div class="col-md-11" style="border-bottom-color: rgb(204, 204, 204); border-bottom=1px"> <button type="submit" class="btn btn-warning pull-right" >Run <span class="glyphicon glyphicon-send"></span></button> </div> </div> </fieldset> </form> </div> <script src="/MapVisualization/js/jquery.min.js" type="text/javascript" ></script> <script src="/MapVisualization/js/jquery-ui.min.js" type="text/javascript"></script> <script src='/MapVisualization/js/stopExecutionOnTimeout-53beeb1a007ec32040abaf4c9385ebfc.js' type="text/javascript" ></script> <script src='/MapVisualization/js/bootstrap.min.js' type="text/javascript" ></script> <script src='/MapVisualization/js/bootstrapvalidator.min.js' type="text/javascript"></script> <script src="/MapVisualization/js/bootstrap-datepicker.min.js" type="text/javascript"></script> <script src="/MapVisualization/js/jquery-ui-slider-pips.js" type="text/javascript" ></script> <script src="/MapVisualization/js/bootstrap-colorpicker.js" type="text/javascript" ></script> <script src="/MapVisualization/js/jquery.multiple.select.js" type="text/javascript"></script> <script src="/MapVisualization/js/date.js" type="text/javascript"></script> <script src="/MapVisualization/js/custom_Maps.js" type="text/javascript"></script> </body> </html> ;;;; run; ... View more

Re: JQuery + SAS + IE 11 = Object doesn't support property or method '...

by Calcite | Level 5 in Developers
‎11-03-2016 12:52 PM
‎11-03-2016 12:52 PM
This issue seems to be related with below given note :   http://support.sas.com/kb/55290 As Portal is supporting IE 7 features only , I cannot use jquery based application in my portlets. I have to use direct link and per Tech Support reply there is no work around for it.   ... View more

Re: JQuery + SAS + IE 11 = Object doesn't support property or method '...

by Calcite | Level 5 in Developers
‎10-19-2016 07:10 PM
‎10-19-2016 07:10 PM
David,        I am facing same issue with JQuery + SAS + IE 11 when tried to have multiple selectable dropdowns inside of a stored process displayed in a web url portlet with SAS 9.4. .   Even though I added below given code for my HTML generating Stored process I am still getting same error  Object doesn't support property or method 'addEventL istener'   <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1">   Did you fix the issue with your application? If yes , could you please share the solution for this problem?  ... View more

Re: Concatenating SAS datasets horizontally

by Calcite | Level 5 in SAS Procedures
‎03-09-2012 11:55 AM
4 Likes
‎03-09-2012 11:55 AM
4 Likes
Try This , PROC SQL; create table results as select a.parameter ,            a.Estimate as Spending_estimate ,           a.probt as Spending_probt ,           b.estimate as Health__Estimate ,           b.probt as Health_probt from Table1 as a inner join  table2 as b on a.parameter = b.parameter; quit; Here if you want to include non-common records also then use Full outer join with COALESCE(a.parameter,b.parameter). ... View more

Re: Split SAS Output into multiple Sheets

by Calcite | Level 5 in SAS Procedures
‎03-01-2012 12:09 PM
‎03-01-2012 12:09 PM
Some time back I have created this macro to address similar kind of need in our project . This macro takes below given parameters 1. Libname is source library 2. SAS_Data : Source SAS Table 3. Output_Name : Excelsheet Name 4. Sheet_Category : If you want to create sheets based on some criterian , use Classification variable as Sheet_Category options mprint mlogic symbolgen; %macro Send_to_Excel( libname =,                       SAS_data=,                       output_name = ,                                                     Sheet_category =                                                    ); proc sql noprint; select type into :cat_type from DICTIONARY.COLUMNS where upcase(name) = upcase("&Sheet_category.") and upcase(libname) = upcase("&libname.") and upcase(memname) = upcase("&SAS_data.") ; quit; proc sql noprint; /* determine total no of sheets required to be created */ select strip(put(count(distinct(&Sheet_category)),best2.)) into :tot_cat_cnt from &libname..&sas_data; select distinct &Sheet_category    into :idcat1 - :idcat&tot_cat_cnt       from &libname..&sas_data; %let catcnt = &sqlobs; quit; /* Create Excel file in DMM_TEMP Folder */ %do i = 1 %to &tot_cat_cnt; proc export data=&libname..&sas_data (where=(&Sheet_category =              %if &cat_type = char %then              "&&idcat&i";                                %else              &&idcat&i;              ))             OUTFILE="&output_name..xls"                 DBMS= xls             REPLACE;    sheet = "A_&&idcat&i";    RUN; %end; %mend Send_to_Excel; %Send_to_Excel(libname = sashelp,                SAS_data=class,                output_name = Amol,                                  Sheet_category = sex                                                    ); ... View more

Re: Need help on Proc sql query

by Calcite | Level 5 in SAS Procedures
‎02-22-2012 01:01 PM
‎02-22-2012 01:01 PM
CASE WHEN is faster than OR so try below given code : CREATE VIEW OUTTAB  AS SELECT FILEA.ALLF1 ,FILEB.ALLF2 FROM FILEB    ,      FILEA    WHERE ( case when FILEA.POL ne FILEB.POL then   ( FILEA.LNAME=FILEB.LNAME   AND     FILEA.FNAME=FILEB.FNAME   AND     FILEA.DOB=FILEB.DOB     )   else  FILEA.POL = FILEB.POL    end )  ; ... View more

code explanation

by Calcite | Level 5 in SAS Procedures
‎02-21-2012 08:55 PM
‎02-21-2012 08:55 PM
Hi,    You are right. The statement sex='F' is used as logical expression which compares the value of variable sex with 'F' .     1.  If it matches it returns 1 so the sum result would be 2      2.  If it doesn't matches then the logical expression returns 0 so final result would be 0. ... View more

How to copy a process flow from one project to another

by Calcite | Level 5 in SAS Enterprise Guide
‎03-23-2009 05:04 PM
‎03-23-2009 05:04 PM
Hi, We have some requirements where I need to copy the process flow from multiple projects to a single new project and make some corrections . I am not able to copy all process flow from one project to another and which results in copying single component each time to new project project.Does any one know any easy way to copy whole process flow from one EG project to another one? Regards, Amol Deshmukh ... View more

redirecting the output of LOCK LIST to output file insead of Log File.

by Calcite | Level 5 in SAS Programming
‎01-29-2009 10:01 AM
‎01-29-2009 10:01 AM
Hi, I am writing a macro which will try to lock the dataset using LOCK DS_name command. If due to contention the Lock fails then we need to trigger an email which will contain details about the user/process holding the lock on given table. By using LOCK DS_name LIST we can know this but these details from LOCK LIST get written into Log file. Is there any way to redirect output of this command to some dataset which we can use for sending an email. Regards, Amol Deshmukh ... View more

Re: Error setting stored process parameters.NULL

by Calcite | Level 5 in Developers
‎10-23-2008 01:05 PM
‎10-23-2008 01:05 PM
some how the code is getting truncated , if we want to see the detail sample code just let me know Message was edited by: dav_amol ... View more

Error setting stored process parameters.NULL

by Calcite | Level 5 in Developers
‎10-23-2008 01:04 PM
‎10-23-2008 01:04 PM
Hi, I created one stored process which will dynamically generate the HTML page to fullfill dynamic parameter requirement.When I executed the stored process thru SAS Information Delivery portal , it has given me desired results. Later on when I tried to create an application using same stored process , it is giving below mentioned error message when I tried to use the application thru SAS Information Delivery portal. Error Message : Stored Process Error Error setting stored process parameters. null I was wondering why it is giving such error for application and URL display portlets case and executing successfully when I just tried to execute the stored process thru SAS portal. Any help will be appreciated. Thanks, Amol Deshmukh The actual code for the stored process would be like this : /************************************************** Name: drill_parms_stp_onclick.sas Purpose: Provide an example of drilling down within an HTML file. The second selection values are dependant on the first selection value. **************************************************/ data class2; set sashelp.class; if _n_ < 7 then race=1; else if _n_ < 14 then race=2; else race=3; run; %macro main; %global reqtype request age race ; %macro first; /* This is the first request. List age groups */ proc summary data=work.class2; class age; output out=means1; run; data _null_; set means1 end=alldone; file _webout; if _n_ = 1 then do; thissrv = symget('_url'); thispgm = symget('_program'); put ' '; put ' Selection Example '; put ' Second Selection is dependant on First '; put ' '; put ' '; put ' '; put ' '; put 'Select Age: '; put ' '; %if "&age" ne "" %then %do; put ' ' "&age"; %end; put ' '; end; if age ne . then do; put ' ' age; end; if alldone then do; put ' '; put ' '; end; run; proc summary data=work.class2; %if "&age" ne "" and "&age" ne " " %then %do; where age=&age; %end; class race; output out=means2; run; ods html close; data _null_; set means2 end=alldone; file _webout; if _n_ = 1 then do; put ' '; put 'Select Race: '; put ' '; end; if race ne . then do; put ' ' race; end; if alldone then do; put ' '; put ' '; put ' Show SAS Log'; put ' '; put ' ' onclick="reqtype.value=' "'report'" '">'; put ' '; end; run; %mend first; %macro report; /* User requested a report */ %let where_clause=%str(1=1); %if "&race" ne "" %then %do; %let where_clause = &where_clause and %str(race = &race); %end; %if "&age" ne "" and "&age" ne " " %then %do; %let where_clause = &where_clause and %str(age = &age); %end; ods html close; ods html body=_webout; Title "Students who are race &race and age &age "; %stpbegin; proc print data = work.class2 noobs; where &where_clause; var name age sex race; run; %stpend; ods html close; data temp; set work.class2; where &where_clause; run; data _null_; if obscount=0 then do; file _webout; put " No entries were found for this selection "; put " race =&race and age = &age "; end; set temp nobs=obscount; run; %mend report; %if "&reqtype" = "report" %then %do; /* Produce a report */ %report; %end; %else %do; /* Produce summary */ %first; %end; %mend main; %main; ... View more

Re: dynamically changing one parameter based on value of another param...

by Calcite | Level 5 in Developers
‎10-10-2008 07:42 PM
‎10-10-2008 07:42 PM
One more point . We are deploying this thru SAS Information Delivery Portal but client don't want to deploy it using JSP. ... View more

dynamically changing one parameter based on value of another parameter

by Calcite | Level 5 in Developers
‎10-10-2008 07:38 PM
‎10-10-2008 07:38 PM
We are trying to generate 4 reports thru a single stored process. In this stored process , we are planning to give 2 dropdown menus to user and the values/parameters of 2nd box should vary based on value selected in first box. Based on the state and country the stored process will generate the Report. e.g. first input field will be Country . if End user selects US from the dropdown menu then based on that input the second menu should give States corresponding to US only so that user can select ( like drop down menu will contain CA,AZ,TX etc. )and then report for that perticular state should be generated thru stored process execution. If End user selects INDIA from first dropdown menu then based on that input the second menu should give states correponding to India only that user can select and generate the report for that state. Can we deploy this thru use of Stored process? if yes it would be appreciable if you can tell us how can we do that? Thanks, Amol ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-06-2023 06:17 PM
Group Hubs for dav_amol
View All
Likes given to
View All
Likes from
View All
Quick links