SAS

SAS Question on applying formula contained in a variable
Dear SAS Users, Can you please anyone give some suggestion/tips to get a solution for below. I have a dataset for example a b frmla ---------------------------------------------------- 10 5 a+b 40 10 a/b 30 20 sum(a,b) I wan... 2 Nov 2009 23:28

SUSPECT: RE: Download a file from HTTP
Hi Phillip, It gives me the same answer: 91 filename _ORCL URL 92 'http://ichart.finance.yahoo.com/table.csv?s=ORCL&d=10&e=2&f=2009&g=d&a=2&b= 93 2&c=1988&ignore=.csv' DEBUG; 94 options validvarname=v7; 95 DATA ORCL; 96 INFILE _ORCL; 97 INPUT data open high low close adj_close; 98 run; ... 2 Nov 2009 12:21

Schemper's V macro sas 9.2
Anyone have a working macro for Schemper's V that is tested in sas v9.2? ... 30 Nov 2009 16:57

Comparing strings - assigning a similarity rating
Maybe my subject isn't great, but here's the situation: I have lots of strings, some of them may be similar to another. Is there something out there that (magically!) calculates the similarity, or maybe a match percentage between two strings? I have some theories on how to do this programatically, but would rat... 3 Nov 2009 17:06

sas time value
I have two datetime values such as "13SEP99:19:45:04" and "13SEP99:23:05:36" I want (13SEP99:23:05:36)minus(13SEP99:19:45:04) so that I can get the actural numebrs Do everyone know how to do it here is my code format date date9. time time8. datetime datetime16.; datetime=(date*24*60*60)+ time; just learn... 1 Nov 2009 12:11

why simple kappa are different in proc freq order=data, and order=internal
I found the simple kappa value different in proc freq: proc freq; (by default order=internal) proc freq order=data; why? The simple kappa will be higher in order=internal than in order=data; order=DATA orders values according to their order in the input data set. order=INTERNAL orders values by their unformat... 31 Oct 2009 00:21

Oracle Prepare Error
quite long and my SQL knowledge is quite short... Only a question: in line 161, where does the brace come from in the GROUP BY.. statement? .... 161 ); Gerhard On Thu, 29 Oct 2009 18:09:46 -0400, J Shafiroff <jeff.shafiroff(a)BLUESHIELDCA.COM> wrote: Hello I am using pass-through c... 2 Nov 2009 17:56

DDE to read Excel file with autofilter turned on?
Perhaps FILTER.SHOW.ALL Equivalent to choosing the Show All command from the Filter submenu on the Data menu. Displays all items in a filtered list. Syntax FILTER.SHOW.ALL() On 10/29/09, Ya Huang <ya.huang(a)amylin.com> wrote: Hi there, Anyone experienced in reading (use DDE) a Excel file with autof... 29 Oct 2009 13:10

Remote session can't connect to oracle
It should work. Is the session started by the spawner starting from the same location and under the same Windows userid as the stand-alone session? -- Jack Hamilton jfh(a)alumni.stanford.org -----Original Message----- From: Vilim Zaksek <vilim.zaksek(a)STERIA-MUMMERT.DE> Sent: Thursday, October 29, 2009 4:... 30 Oct 2009 08:54

Can I specify order=data and order=freq in proc freq?
In proc freq, can I specify order=data and order=freq in proc freq? I want the data order as the input data set, because the data are: Q1R1C1 Q1R1C2 Q2PR2C8 Q2TR1C1 Q2TR1C2 Q2TR10C1 Q2TR10C2 Q12TP1C1 Q12TP1C2 Q12TP1C10 .... but i also want the result display by descending frequency count at the same time.... 28 Oct 2009 18:30