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: 
Rambo
‎09-01-2015
  • 8 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Create Activex Graphs with all available variables

by Calcite | Level 5 in Graphics Programming
‎09-24-2013 10:26 AM
‎09-24-2013 10:26 AM
HI Dan, I tried your solution but I did not have var1 and var2 available in the drop down menu.  Any thoughts? ... View more

Create Activex Graphs with all available variables

by Calcite | Level 5 in Graphics Programming
‎09-24-2013 09:18 AM
‎09-24-2013 09:18 AM
HI, I am trying to create an activex plot that enables me to visualize the relationship between multiple variables.  However, I only want two variables to show at a time.  To help illustrate my question, please see the example code below.  Ideally, the code would create a scatter plot of var3 by x as the default graph.  Then, if I were to right click the graph and choose data options, I would be able select var1 or var2 in  the Response drop down menu. Note:  Currently, the Response drop down only shows the var3 and x.  I have also changed the plot line to (var1 var2 var3)*x/overlay, but then all three responses are plotted against the X and I cannot find a way to "remove" two from the graph. Thanks in advance! data testdata;         do x = 1 to 15;                  var1 = x;                  var2 = -x;                  var3 = 7.5 + ((-1)**((mod(x,2)=0)))*(7.5-x);                  output;          end; run; ods html path="%sysfunc(pathname(work))" file="test.html"; goptions device=activex; proc gplot data=testdata;        plot var3*x; run; ods html close; ... View more

Re: It's possible to generate random numbers with these conditions?

by Calcite | Level 5 in SAS Procedures
‎02-25-2011 03:52 PM
‎02-25-2011 03:52 PM
You could try the following code: data RandomValues; samplesize = 300; /* update to desired sample size*/ seed = date(); /*setting a seed for the random number generator*/ do i = 1 to samplesize; obs = ceil((ranuni(seed) * 9)); /*change upper bound here */ output; end; run; ... View more

Re: Create dummy variables but have to use where clause

by Calcite | Level 5 in SAS Procedures
‎02-25-2011 03:19 PM
‎02-25-2011 03:19 PM
I think you can use the find function here. You could change your conditional logic to be something like: if find(lowcase(title), "ceo") > 0 then _title = 1; else if find(lowcase(title),'cfo') > 0 or find(lowcase(title),'chief finance') > 0 then _title=2; SAS Documentation: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002267763.htm ... View more

Re: Convert to proc sql in SAS

by Calcite | Level 5 in SAS Programming
‎11-16-2010 06:24 PM
‎11-16-2010 06:24 PM
Hi Paige, I am not sure how to resolve the new issue. Looking at the code, it looks like you are adding 1 to the results of the subquery. I would try to wrap the subquery and the '+1' in parentheses; I am not sure of the order of execution here (i.e. if it concatenates the results and then tries to add 1 to the concatenated string). Another option to try is to use the left() function. Since you are converting a number, you will want to have the number left justified. If not, you may have "blanks" between the value from A.family and the results of the subquery. Note: A trim function nested within the left function may also be necessary ex. left(trim(###)). ... View more

Re: do loops and name appending

by Calcite | Level 5 in SAS Programming
‎10-15-2010 12:57 AM
‎10-15-2010 12:57 AM
You could initialize an array with the name of the variables that you want. For example, you could have said array y_(5); Then you reference the array like so in the data step: y_(i) = value;. When the array is stored in the dataset, it will actually be stored as y_1, y_2, etc. Note; In the array statement, the number in parentheses tells sas how many elements you need in your array; for you example, it should match the number of iterations in the do loop. ... View more

Re: Create multiple observations from a single one

by Calcite | Level 5 in SAS Programming
‎10-13-2010 12:34 AM
‎10-13-2010 12:34 AM
Hi Sweettravel, You can use the output statement [along with a do loop] to help print duplicate records. Try using the following code: data transformed; set original; gender = 0; /*sets the gender to male*/ do m = 1 to male; output transformed; end; gender = 1; /* sets the gender to female*/ do f = 1 to female; output transformed; end; keep gender v1-v4; /*ensures the key variables are kept*/ run; I will note that the code above assumes male and female are both greater than 0. If this is not the case, you will need to add a conditional logic check before dropping into the DO loops. Rambo ... View more

Re: Convert to proc sql in SAS

by Calcite | Level 5 in SAS Programming
‎10-11-2010 12:51 AM
‎10-11-2010 12:51 AM
Hi Paige, In general, you should be able to copy and paste an SQL query from a database into SAS. This of course assumes the SAS program can access the tables you are referencing (i.e. SAS dataset or via an ACCESS module). With that said, I think you hit one of the few exceptions where copying charater for character just does not work. In the example posted, I think the problem is with the "&" after A.family. In Access, the "&" is used to concatenate two fields together. However, in SAS the "&" generally signals a macro variable. To resolve your issue, I would suggest adding a "||" (double pipe) in place of the "&" or you can use one of the built in concatenate functions (cat, catx, etc). I hope this helps. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links