About rkgrc000

rkgrc000 · ‎12-29-2015

Hello, I am trying to recreate an analysis of a complex survey dataset in SAS that was previously analyzed in R and Stata. While the point estimates are correct, the standard errors and confidence limits are close, but not exact. In looking for possible explanations for this, I realized I was not able to apply a setting for certainty primary sampling units (PSUs) that was included in the R and Stata code. Is there a way to set up the survey design in SAS that would be the equivalent of R's options(survey.lonely.psu = "certainty") or the "singleunit(certainty)" setting at the end of the line below in Stata? svyset caseid [pweight=wt_a], strata(strata) vce(linearized) singleunit(certainty) I came across the CERTSIZE parameter in PROC SURVEYSELECT, but I believe I would be looking for a setting that would apply to PROC SURVEYMEANS and PROC SURVEYFREQ. For reference, I am not an experienced survey data analyst, but have been a SAS user for years. Any help would be appreciated, thanks!

rkgrc000 · ‎09-22-2015

Thank you for answering, Tim! SAS Technical Support said the same thing (below) when I asked them, but they also had a helpful suggestion in terms of running the program online without timing out: "Here are some comments and suggestions. 1. It is not possible to create a custom form for a stored process if you run the stored process using Enterprise Guide. So, if you need to have a custom form, you would need to run the stored process using the SAS Stored Process Web Application. 2. You said: > The issue is that the datasets we want to work with are very large, so doing this in the browser, > as we have done with our other custom input forms, would time out. You can increase the timeout setting for the SAS Stored Process Web Application. Then, it should not time out. See Usage Note 34167. Usage Note 34167: Changing the timeout setting for the SAS Stored Process Web application http://support.sas.com/kb/34/167.html"

rkgrc000 · ‎09-16-2015

Hello, we have a custom input HTML form (a JSP file stored as a _FORM parameter in the prompt tab) that we would like to use in Enterprise Guide. We already use custom input HTML forms in the SAS Stored Process Web Application, but this is our first attempt to do something similar on the desktop. The issue is that the datasets we want to work with are very large, so doing this in the browser, as we have done with our other custom input forms, would time out. Opening the stored process that works in the browser (other than the time-out issue) brings up the address for the custom input form, but not the form itself. Does anyone have any suggestions? Thank you.

rkgrc000 · ‎01-20-2015

Thank you! I have seen the "+(-1)" before in SAS User Group papers, etc., but I never knew exactly what purpose it served, so this is great. Thanks again!

rkgrc000 · ‎01-20-2015

Hello, we are retrieving character data from a database into an HTML form in a Stored Process in the Stored Process Web Application. That approach is going well in general, but we have found that trailing blanks are being added to the original data values so that, when the HTML form is generated, the blanks become part of the value shown in the form and the blanks would be incorrectly included in the value when the form is resubmitted. Is there a way to resolve the PUT statements without adding trailing blanks to the values? We can probably fix this with JavaScript in the browser once the form loads, but would prefer to avoid the issue in the first place. Any help would be greatly appreciated, thank you! data test; length ID1 $1 ID2 $1 ID3 $1 ID4 $1 ID5 $1 date1 $10 date2 $10 date3 $10 date4 $10 date5 $10; input ID1 $ ID2 $ ID3 $ ID4 $ ID5 $ DATE1 $ DATE2 $ DATE3 $ DATE4 $ DATE5 $; datalines; 1 2 3 4 5 01/10/2015 01/11/2015 01/12/2015 01/13/2015 01/14/2015 ; /*The blanks are not part of the original values and, even if they were, we should be able to remove them...*/ data test; set test; ID1 = strip(ID1); DATE1=strip(DATE1); run; data _null_; set test; put '<input id="ID1" name="ID1" value="' ID1'"></input>'; put '<input id="DATE1" name="DATE1" value="' DATE1'"></input>'; run; /*Log shows: <input id="ID1" name="ID1" value="1 "></input> <input id="DATE1" name="DATE1" value="01/20/2015 "></input> */ /*Want to resolve without the extra trailing space in the HTML value attribute, as in: <input id="ID1" name="ID1" value="1"></input> <input id="DATE1" name="DATE1" value="01/20/2015"></input> */

rkgrc000 · ‎01-16-2015

Our organization has the SAS Enterprise Business Intelligence Platform and we frequently use stored processes with custom input forms in the Stored Process Web Application for a variety of different purposes. For some custom input forms, for example a form containing repeated input fields in rows and columns organized in a similar layout to a spreadsheet, we have generated the repetitive HTML code (using a "data _null_; file _webout; put '<html>all the html...</html>'; run;" kind of approach) in an outside SAS program and then manually copied and pasted that generated code into an already-created Stored Process in Management Console in order to surface the form online. We are wondering if there would be a way to instead have one SAS program or Stored Process that, given some parameters (e.g., number and types of input fields, element id and name attribute values, input field labels, etc.), would act as a meta-level generator for other Stored Processes that would generate the Stored Process code and register the created Stored Processes in metadata so that, when one of these newly-created Stored Processes is executed, it would dynamically generate a custom input form displayed online that would fit the entered parameters. In a sense, if I understand the term correctly, we would almost be using SAS as a content management system like WordPress or Drupal. Does anyone have any suggestions? Thanks!

rkgrc000 · ‎01-03-2014

Hello, I came across this thread trying to do something similar and, while I don't have a solution for my needs yet, I wanted to share this paper (http://support.sas.com/resources/papers/proceedings13/293-2013.pdf), which seems promising.

rkgrc000 · ‎12-05-2013

Thank you for these resources, Michelle!

rkgrc000 · ‎12-02-2013

In case anyone is trying to do something similar, I thought I would provide an update to this post to say that we ended up creating local Windows users ( Create a user account - Microsoft Windows Help) and then running a generic bulk load macro (SAS(R) 9.3 Intelligence Platform: Security Administration Guide) to create new SAS accounts based on the local Windows accounts. Following this approach, the SAS accounts need to have the prefix "WIN\" for the local domain and the SAS user would log in with the password set in the local Windows account. We had issues with metadata that may have prevented us from taking the AD LDS / LDAP approach.

rkgrc000 · ‎11-18-2013

I figured this out, so I thought I would post what worked for me in case anyone else is hoping to do the same thing. If you are working with BI Dashboard, it turns out the URL you need to link to is "http://server:port/SASBIDashboard/Logoff". I assume that you could substitute other applications (e.g., SASStoredProcess) to do the same thing in other situations. So, I'm simply including a 'Log Off' hyperlink to the URL above in the website that contains the embedded dashboard portlet in an iframe. The HTML: <a id="logoff" href="http://server:port/SASBIDashboard/Logoff" target="iframe1"><b>Log Off</b></a> <iframe name="iframe1" src='http://server:port/SASBIDashboard/Director?_directive=PortletDisplayDashboard&dashboard=SBIP'>" I learned how to create the SBIP, which needs to be customized for the end of the iframe dashboard link above, from the example on page 6 of this document: http://support.sas.com/resources/papers/proceedings13/061-2013.pdf If others have better solutions, please share!

rkgrc000 · ‎11-18-2013

Hello, I am wondering how to log out of a SAS BI portlet that will be embedded in an iframe in another website. My thought is to simply create a new 'log off' link, but I have not had success yet. I have tried adding a hyperlink via Static Content: Label to a generic log-on page (e.g., http://server:port/SASLogon/index.jsp?_sasapp=BI+Dashboard+4.3) or a similar address with a session ID from a previous session and a different user name, etc. That approach opens a new log-on screen page, but does not actually log the user out of the embedded portlet. Closing the browser does not work either. Any suggestions would be greatly appreciated!

rkgrc000 · ‎10-15-2013

Hello, I am wondering how to best set up authentication via Lightweight Directory Access Protocol (LDAP) for users from many different organizations outside my own who need to access individualized SAS 9.3 BI dashboards that my organization is creating. Tech support has been helpful so far, but, as someone with little configuration/deployment/administration experience who has nonetheless been asked to take care of this, I'm afraid I need more basic help. Here are the steps I've taken so far: 1) Added the Active Directory Lightweight Directory Services (AD LDS) role on our Windows 2008 R2 Enterprise Server. 2) Added 2 lines to sasv9_usermods.cfg (SAS(R) 9.3 Intelligence Platform: Security Administration Guide). I did not add the 3rd line (/* System options that make LDAP the primary authentication provider */ -authpd LDAP:company.com -primpd company.com) yet because I don't fully understand the implications of making the change. If I make LDAP the primary authentication provider, will that create problems for all the SAS users within our organization who connect to SAS servers through Integrated Windows authentication (IWA)? In other words, do I have to choose either IWA or LDAP? I restarted the Metadata server after updating the sasv9_usermods.cfg file. 3) I created a new authentication domain in Management Console, created a user, and set the user's authentication domain to the new one just created. However, nothing seems to have actually happened. For example, I cannot log in to SAS BI Dashboard with the login information I entered, either in AD LDS or Management Console. 4) Following tech support's advice, have run this code (40147 - Test connection to LDAP or Active Directory server from within SAS® 9) for a single user account I set up in AD LDS. I modified the code with one small edit (30425 - "ERROR: Invalid handle specified" occurs when running the sample program IMPORTAD.SAS) after encountering an "Invalid handle specified" error. The code executes with 1 warning and the following messages in the log: "LDAPS_OPEN call successful. WARNING: No results found. LDAPS_FREE call successful. LDAPS_CLOSE call successful." So, I clearly still have some issues to address, but it appears that some sort of connection is being made to AD LDS. Sorry in advance for my rookie mistakes. Any help to keep moving forward would be greatly appreciated!

Online Status	Offline
Date Last Visited	‎04-14-2016 12:00 PM

Complex survey data design setup in SAS: How to handle certainty prima...

Re: How to Display a Stored Process Custom Input HTML Form in Enterpri...

How to Display a Stored Process Custom Input HTML Form in Enterprise G...

Re: How to remove trailing blanks when PUT statement resolves for HTML...

How to remove trailing blanks when PUT statement resolves for HTML for...

Is there some way to programmatically create a Stored Process, includi...

Re: Accessing SAS.IdentityGroups Information from SAS Stored Process

Re: Help connecting SAS Management Console and Active Directory Lightw...

Re: Help connecting SAS Management Console and Active Directory Lightw...

Re: How to log out of a SAS BI portlet embedded in an iframe in anothe...

How to remove trailing blanks when PUT statement resolves for HTML for...

Complex survey data design setup in SAS: How to handle certainty prima...

Is there some way to programmatically create a Stored Process, includi...

Re: Help connecting SAS Management Console and Active Directory Lightw...

Re: Help connecting SAS Management Console and Active Directory Lightw...

Complex survey data design setup in SAS: How to handle certainty prima...

Re: How to Display a Stored Process Custom Input HTML Form in Enterpri...

How to Display a Stored Process Custom Input HTML Form in Enterprise G...

Re: How to remove trailing blanks when PUT statement resolves for HTML...

How to remove trailing blanks when PUT statement resolves for HTML for...

Is there some way to programmatically create a Stored Process, includi...

Re: Accessing SAS.IdentityGroups Information from SAS Stored Process

Re: Help connecting SAS Management Console and Active Directory Lightw...

Re: Help connecting SAS Management Console and Active Directory Lightw...

Re: How to log out of a SAS BI portlet embedded in an iframe in anothe...

How to log out of a SAS BI portlet embedded in an iframe in another we...

Help connecting SAS Management Console and Active Directory Lightweigh...