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: 
js8765
‎11-05-2015
  • 12 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Proc Tabulate Percentages

by Calcite | Level 5 in SAS Procedures
‎11-05-2015 12:26 PM
‎11-05-2015 12:26 PM
Hi,   I keep coming to a dead end when trying to find out how to do the following in Proc Tabulate.  I would like to create the percentages as shown in the attached table. You will see that the treatment counts should be calculated as a percentage of the number of patients in each region.    If anyone could help I would be really happy. I've been trying to solve this for a long time!   Thanks very much in advance!    Here's the code I have with the variable names. data all1;   set all;   by patno;   if first.patno then pat_cnt = 1; run; proc tabulate data = all1;   class grp trt region;   var pat_cnt;   tables pat_cnt (grp * trt), region; run;   ... View more

Re: SAS/SHARE, SAS/Connect, reading a dataset using C#

by Calcite | Level 5 in Administration and Deployment
‎09-11-2014 06:33 AM
‎09-11-2014 06:33 AM
Hi SASKiwi, do you know of a way to test a connection string from within SAS? This would be great as it might give better indications as to what part of the string is wrong or missing. I have connected to the server using the code in the original post, so the values I'm using there are definitely correct. However it's proving a nightmare to convert that information into a ConnectionString that works in C# 😞 ... View more

Re: SAS/SHARE, SAS/Connect, reading a dataset using C#

by Calcite | Level 5 in Administration and Deployment
‎09-11-2014 06:31 AM
‎09-11-2014 06:31 AM
Hi Unkie, Thanks for the pointer. I had already tried this code but get an error. "TCP method failed" "Unable to locate server". The code snippet in the link you sent doesn't accommodate a value for PORT, which I think is needed. With regards to having a SAS/Share Server , I'm assuming that's what the code in the original post is connecting to, but I could be wrong. ... View more

SAS/SHARE, SAS/Connect, reading a dataset using C#

by Calcite | Level 5 in Administration and Deployment
‎09-10-2014 10:29 AM
‎09-10-2014 10:29 AM
Hi, For days I am trying to connect to my data from a C# program. I have tried many different ways (Integration Technologies, ADODB, OLEDB) and many different connection strings but none have worked so far. Here is how I would connect to the data (using SAS/SHARE and SAS/Connect) from within a SAS Session, %let conn1 = abc123.xyz.com         9999; signon conn1;  *< here I enter my username and password in the pop-up window>; libname mylib remote '/dir1/dir2/dir3' server = conn1; Has anyone any experience in how to read a dataset on a different server using C#? I'm sure it's my connection string that's incorrect. It would be really amazing if someone could suggest some code using the details as above (server:abc123.xyz.com port:9999 UserId: username Password: password library to get dataset from:mylib) . Like I said, I have been trying for a long time and have look at all the cookbooks and articles I could find, that's why a concrete connection string or C# code would be really appreciated as opposed to a pointer to reference material. Thanks in advance for any help! ... View more

Re: DDE to close a particular excel workbook

by Calcite | Level 5 in SAS Programming
‎09-14-2013 10:42 AM
‎09-14-2013 10:42 AM
Hi, Thanks again for your help. I finally found the solution, and of course, it's one of those ones that is easy when you know how... All that was needed was:           put '[close(1,"Workbook.xls")]'; Where 1 is to save changes, and 0 would be to not save changes. By the way Reeza, you caught my eye with the line "use DOCUMENTS or WINDOWS to get the list of all open documents". Where can I use the DOCUMENTS or WINDOWS commands? I've never heard of those before... ... View more

Re: DDE to close a particular excel workbook

by Calcite | Level 5 in SAS Programming
‎09-13-2013 01:42 PM
‎09-13-2013 01:42 PM
Hi Reeza, The situation is like this... The workbook is opened by MACRO1. The workbook name is saved to a macro variable by MACRO1. Then, some time later, MACRO2 is run, and part of this macro's tasks are to shut the workbook that was opened by MACRO1. And yes, unfortunately there are multiple workbooks open. It would have been better if this wasn't the case because then I could have used a simple CLOSE command without having to specify the file name. Tricky one, isn't it! 😉 ... View more

Re: DDE to close a particular excel workbook

by Calcite | Level 5 in SAS Programming
‎09-13-2013 01:04 PM
‎09-13-2013 01:04 PM
Thanks a lot guys. They are helpful comments. However, my issue is a little more intricate. The excel workbook that I would like to close has already been opened by another process, and therefore if I use the OPEN command, I get a message saying the file is already open. That's why I'm looking for some other way to point to that Excel workbook and then send the CLOSE command. Any ideas? ... View more

DDE to close a particular excel workbook

by Calcite | Level 5 in SAS Programming
‎09-13-2013 06:30 AM
‎09-13-2013 06:30 AM
Hi, I'm trying to create DDE to close a particular excel workbook which is currently open. The workbook name needs to be passed as a macro variable. Does anyone know how to do this? Below is what I've tried but I'm getting the error: "DDE syntax error in physical name" Thanks in advance for any advice! %let filenm = c:\temp\file.xls; filename DDEcmds dde "Excel|&filenm."; data _null_;     file DDEcmds;     put '[close(true)]'; run; ... View more

Extract text from a graph stored in a sas catalog / output graph to a ...

by Calcite | Level 5 in Graphics Programming
‎08-21-2012 06:09 AM
‎08-21-2012 06:09 AM
Hi, I have not much experience with graphs and I need to extract some text (footnotes) from graphs that are stored in a sas catalog. I think the best way to do this might be to output the graph to a text file. Even if there are a lot of strange characters produced, I'm hoping that the text part will remain intact. Does anyone know how to output a graph stored in a catalog to a text type file? Any other advice or pointers would be greatly appreciated. Thanks very much in advance, John ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-05-2015 02:47 PM
Quick links