l******9
发帖数: 579 | 1 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: get value returned by SQLstored procedure from python
发信站: BBS 未名空间站 (Fri Aug 1 18:07:59 2014, 美东)
I need to check the returned value from a stored procedure on SQL server
2008 R2.
import pyodbc
sql_str = """
DECLARE @return_value int
SET @return_value = -1
INSERT INTO [my_database].[dbo].[my_table]
EXEC @return_value = [my_database].[dbo].[my_stored_
proce... 阅读全帖 |
|
z****e
发帖数: 2024 | 2 为什么书上都是fitted value，可是身边的头头告诉我要用fit value.
到底是那个？
请权威大侠辨析。
多谢。 |
|
x***i
发帖数: 135 | 3 Sorry, I can't input Chinese now.
I am using SAS to to linear regression and logistic regression. The p value
for the linear model (eg: X1, X2) shows <0.0001. But, my boss want the exact
p value (such as 1X10-7). I am wondering how to get the exact p value.
Thanks a lot! |
|
b***9
发帖数: 34 | 4 我的文章刚修回，文章中只有一个试验是用two-way ANOVA 分析的，我标了F 和P
value. 其他的都是用one-way ANOVA 分析的，仅写了p value。但是reviewer要我都
写全，查了一下发表的paper，好像F value只用于two-way or three-way ANOVA，没有
用于one-way ANOVA的。 我应该怎样回复呢？如果补全要占不少篇幅呢，哪位高手给指
点一下呀。多谢！ |
|
x***x
发帖数: 3401 | 5 Again, the problem is how to modify the value of city. using a macro.
The change from "1. Beijing" to "Beijing" should be done by the macro.
I did NOT mean to manually change the format value and then use a macro to
attach the new format to the variable.
The goal is to call a macro to modify the format value automatically. |
|
z****n
发帖数: 67 | 6 现在有一个data set，如下：
data survey;
input id diet exer hours xwk educ;
datalines;
1 1 . 1 3 1
1 . 2 1 4 2
1 . 4 . . .
1 1 5 2 3 .
2 . 9 2 3 .
2 5 9 2 4 .
2 . 3 . 5 3
3 2 . . . .
;
我有一个macro可以自动count给定列的每个id的missing value个数，但只能够给出一
列。如果
我想要写一个macro，运行一次自动给出多列，比如此列中diet exer educ的missing
value
该怎么改呢，是否该用array？（实际我要用的data set 有300 多个变量需要测missing
value）
options nodate pageno=1 linesize=80 pagesize=60;
%macro countm(col);
count(case
when &col~= . then "count me"
end) as N |
|
y*********s
发帖数: 24 | 7 我读了一些怎样IMPUTE MISSING VALUES 的材料，
根据 MAXIMUM LIKELIHOOD， 还有EM 之类 去IMPUTE，
麻烦的是 如果 MULTIPLE IMPUTATION，
是取 AVERAGE OF THE SAMPLINGS 代替 MISSING VALUES 吗， 然后再 MODEL？
在工业中， LARGE DATA SETS， 都用什么方法 IMPUTE 这些MISSING VALUES 呢？
求讲解！！！~~~
新年快乐！！ |
|
t**********h
发帖数: 100 | 8 In SAS, 请教怎样在Character value 里面输入numerical value. 比如
do i = 1 to 5;
if 100*(i-1) =< time =< 100*i then min = ' 5*(i-1)- 5*i minutes';
end;
我需要min的名字跟着i一起变，但是它的值是character。 我记得好像要加几个符号，
但是忘了。多谢了。 |
|
s********g
发帖数: 889 | 9 我有个试验研究两个factor（每个factor有三个level）对一个产品特性的影响。所以
一共有9个试验样品。另外每个样品按两个试验条件做了两次试验。
我对试验条件A下做出的9个试验结果做了two-way ANOVA。
两个factor对结果的影响的p-value分别为 1e-5，2e-5。
对实验条件B下做出的9个试验结果也做了two-way ANOVA。
两个factor对结果的影响的p-value分别为 1e-8，2e-8。
我的问题是我能不能得出这样的结论：试验条件B更能反映出这两个factor对产品特性
的影响。或者说这两个factor在试验条件B下对产品的影响更大。
其实这个问题也就是说两个ANOVA的p-value能不能相互比较。
谢谢！ |
|
s********g
发帖数: 889 | 10 我有一个two-way anova的结果：
Df Sum Sq Mean Sq F-value p-value
Mix type 3 0.056 0.019 19.9 < 0.001
Aggregate type 2 0.218 0.109 115.6 < 0.001
Interaction 6 0.014 0.002 2.5 0.054
Residual 24 0.023 0.001
结论是两个因素都对实验结果有显著影响，但我可不可以继续说Aggregate type对实验
结果影响更significant?因为他的F-value大很多。
谢谢 |
|
A*******s
发帖数: 3942 | 11 One senior statistician told me his own convenient way for missing values.
He replace the missing values with 0, and then create an indicator for
missing values (1 as missing and 0 otherwise).
I never heard of it. So what are the pros and cons about this method? |
|
T*******I
发帖数: 5138 | 12 A missing value = an umknown fact
由此我们也就知道了该如何处理missing values in a dataset. 由此我们也就知道了如果一个missing value被一个真值取而代之意味着发生了什么。 |
|
p***r
发帖数: 920 | 13 Nice start! Let's complicate the situation: Here is the real problem
14 weather stations with four month hourly temperature (2208 hrs in total)
with missing values in some station and some hours (one hour or 20 hours
consecutively).
Data:
time station1 station2 ... station14
-------------------------------------
1 . 5
3 9 7
4 8 10
... ... ...
. 8 11
. 5 ... 阅读全帖 |
|
i*****c
发帖数: 1322 | 14 From the data analysis, I found that a measurement is associated with the
disease. I use the value that identify 60% patients and 20% non patients as
the cut-off value. Is there better way to express this cut-off value other
than OR? Thanks. |
|
r********n
发帖数: 6979 | 15 对于几乎任何statistical tests
两组不同的方法
相同的test
得到两个p－value
一个是0.00001
一个是0.000001
都是highly significantly
我（有多大把握）能不能把这个p－value作为选择方法2的依据呢？
因为方法2的p－value更小
举个例子
假设我有1000个samples
用分类方法一把这1000个sample分成两个组
做一个t－test
得到p1＝0.00001
用另一个分类方法也分成两个组
做一个t－test
得到p2＝0.000001
能不能说明方法2要更好？ |
|
c**********e
发帖数: 2007 | 16 Here is the example:
proc genmod data=data_one;
class id x1 x2 x3;
model y = x1 x2 x3 / dist=normal;
repeated subject=id / type=exch;
run;
The default output has p-values for each dummy variable generated by x1, but
not a p-value for x1.
Anyone help please? Thanks a ton. It seems GLM gives such p-values by
default. |
|
l******9
发帖数: 579 | 17 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: keep group of values of SQL procedure in one table
发信站: BBS 未名空间站 (Sat May 24 09:48:08 2014, 美东)
I need to print out a group of values from a procedure on SQL server 2008.
If I use select , it generated a distinct table into the result part of SQL
server 2008 managemetn studio every time the procedure is called.
i need to call the procedure in a loop. I want to print the values into one
table.
Thx!
while
begin
my_proce... 阅读全帖 |
|
w*******y
发帖数: 60932 | 18 Free Item with any $10 Purchase through 12/24/10:
http://ebm.cheetahmail.com/r/regf2?aid=528207786&a=0&n=47&D_CODE=3672
Use code 3672 in U.S. stores only
Use code FREE4U ONLINE AT CHECKOUT
Fine Prints:
Free Item with Any $10 Purchase
Up to a $13 value. Offer excludes gift sets. Limit one offer per customer.
No substitutions. Change will not be given for product with less than a $13
value. To redeem online, add $10 of merchandise to your shopping bag, a free
item up to a $13 value, enter promotio... 阅读全帖 |
|
w*******y
发帖数: 60932 | 19 Amazon is running a buy one, get one 50% off on select games right now,
which makes for some great deals, and many of these games have trade-in
values at more than 50% off, meaning the deal gets slightly slicker for the
price of one after trade-in credit. Here are some of the better combos I've
noticed:
Gran Tursimo 5 ($53.99) - 2 for $80.98 - 32 tiv = $48.98
Call of Duty: Black Ops ($54.99) - 2 for $82.48 - 36.50 tiv (X360) = $45.98
Splatterhouse ($53.00) - 2 for $79.5 - $33 tiv = $46.50
Right... 阅读全帖 |
|
w*******y
发帖数: 60932 | 20 George Foreman 144'' Family-Sized Grill and Hamilton Beach 5-Quart Slow
Cooker Bundle Walmart Value of the Day.
$49.00
Shipping Free with Site to Store Pickup.
Standard Shipping to PA is $1.97
Here is the link:
http://www.walmart.com/ip/George-Foreman-Grill-and-Ham-Beach-5- Description
#Item+Description" rel="nofollow" target="_blank" onclick="_gaq.push(['_
trackEvent', 'thread', 'click', '2619777 - george-foreman-144-familysized-
grill-and-hamilton-beach-5quart-slow-cooker-bundle-49.00-at-walma... 阅读全帖 |
|
w*******y
发帖数: 60932 | 21 Multipet Dog Toys in Bone Bag, 7-Piece Assorted Value Pack $5.80 free
shipping with Prime (FSSS) from Amazon. Good Reviews. Price subject to
change.
Bundle includes12-inch Original Loofa dog toy
7-1/2 plush curly pet toy
7-inch rope toy
5-inch vinyl football
3-inch tennis ball
4-inch knotted rope ball
4-inch rubber ring
Multipet Dog Toys in Bone Bag, 7-Piece Assorted Value Pack:
http://www.amazon.com/Multipet-Toys-7-Piece-Assorted-Value/dp/B
|
|
|
w*******y
发帖数: 60932 | 23 So this year eBay will be doing a 20% eBay Final Value Fee Discount for
Listings Posted November 24- December 25 available to all sellers, and it
stacks with Power Seller discounts (40% total discount). I read about this
in the Power Seller Magazine, and it is online as well.
Key thing will just be to make sure you set up your listings right:
- Select "Expedited Shipping" under Services for U.S. shipping. 'Expedited'
is pretty arbitrary.
- Select handling time as "1 Business Day"
Just wanted to ... 阅读全帖 |
|
w*******y
发帖数: 60932 | 24 MSN Offers (formerly Bing Daily Deals) is offering 2 fandango.com movie
tickets for $12 just like every other site right now BUT if someone sends
you an invite link you get a free $5 credit.
$12 - $5 credit = $7 for two movie tickets
"We'll give your friends $5 just for joining MSN Offers...and then give you
$5 when they purchase their first deal!"
So create an account, send yourself an invite to a different email address,
create a new account from that link and you will have $5 credit to use
to... 阅读全帖 |
|
|
w*******y
发帖数: 60932 | 26 Just returned home from my local Walmart store in SE Michigan where they had
the Disney Cars Mega Track Value Pack for $20 (online price is still $34.97
). The Black Friday price for this was $25.
It includes:Spy Jet Escape Track Set
Tokyo Spinout Track Set
Barrel Blowout Track Set
Link:
http://http://www.walmart.com/ip/Cars-2-X3129/17126356?adid=bzv Description
#Item+Description" rel="nofollow" target="_blank" onclick="_gaq.push(['_
trackEvent', 'thread', 'click', '3653128 - disney-cars-mega-... 阅读全帖 |
|
|
w*******y
发帖数: 60932 | 28 Ok folks this is for existing customers only or people who want to go in
with a Value Plan - that's the T-Mobile bring your own phone plan with no
phone subsidies. This is NOT a good deal for people who get phone subsidies
in their plans. This is NOT one of the T-Mobile Value Plan "sales" where
you have a down payment and then a monthly cost, this is the total price for
the phone.
T-Mobile has the Nokia Astound for 99.99 as an upgrade option for people who
don't get phone subsides. You must s... 阅读全帖 |
|
|
p*****0
发帖数: 3104 | 30 【 以下文字转载自 bluechips 俱乐部 】
发信人: phenix0 (清风道场－super傻蛋), 信区: bluechips
标 题: [zt]Pictet Clean Energy Fund Finds Value in Cree’s LEDs
发信站: BBS 未名空间站 (Thu May 6 00:15:25 2010, 美东)
Ask Pictet Clean Energy Fund manager Philippe de Weck where he finds
investment value in a world more concerned about the economic recession than
reducing emissions and the short answer is in technology pioneers.
LEDs, or energy-efficient light-emitting diodes, shine in de Weck’s
investment universe as they are “ultimatel... 阅读全帖 |
|
y*****l
发帖数: 5997 | 31 ☆─────────────────────────────────────☆
JadeFans (翡翠粉丝) 于 (Fri Nov 5 01:30:50 2010, 美东) 提到:
Regional banks should be fine:
RF
SNV
MI
OKSB
BANR
UCBI
CRBC
BPOP
☆─────────────────────────────────────☆
MGM (香帅) 于 (Fri Nov 5 01:35:31 2010, 美东) 提到:
我持有bpop
☆─────────────────────────────────────☆
JadeFans (翡翠粉丝) 于 (Fri Nov 5 01:37:25 2010, 美东) 提到:
I have 3 banks: BAC/BANR/UCBI, and may add any others
☆─────────────────────────────────────☆
KevinsFather (大胖小子) 于 (Fri Nov 5 01:41:... 阅读全帖 |
|
y*****l
发帖数: 5997 | 32 ☆─────────────────────────────────────☆
JadeFans (翡翠粉丝) 于 (Fri Nov 5 01:30:50 2010, 美东) 提到:
Regional banks should be fine:
RF
SNV
MI
OKSB
BANR
UCBI
CRBC
BPOP
☆─────────────────────────────────────☆
MGM (香帅) 于 (Fri Nov 5 01:35:31 2010, 美东) 提到:
我持有bpop
☆─────────────────────────────────────☆
JadeFans (翡翠粉丝) 于 (Fri Nov 5 01:37:25 2010, 美东) 提到:
I have 3 banks: BAC/BANR/UCBI, and may add any others
☆─────────────────────────────────────☆
KevinsFather (大胖小子) 于 (Fri Nov 5 01:41:... 阅读全帖 |
|
l******9
发帖数: 579 | 33 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: get value returned by SQLstored procedure from python
发信站: BBS 未名空间站 (Fri Aug 1 18:07:59 2014, 美东)
I need to check the returned value from a stored procedure on SQL server
2008 R2.
import pyodbc
sql_str = """
DECLARE @return_value int
SET @return_value = -1
INSERT INTO [my_database].[dbo].[my_table]
EXEC @return_value = [my_database].[dbo].[my_stored_
proce... 阅读全帖 |
|
d*****d
发帖数: 2449 | 34 6 buddy tickets ($74 per ticket) if buy before 4/14, a little more expensive
than this year.
$209/$189 for children.
Difference between local and value is that local is valid and Northstar and
Kirkwood 7 days a week, value cannot be used on Saturdays.
http://www.snow.com/epic-pass/passes/tahoe-value-pass.aspx |
|
d*******2
发帖数: 3045 | 35 【 以下文字转载自 USANews 讨论区 】
发信人: likeke (知音难觅,知己难寻), 信区: USANews
标 题: 今年的大选就是要站边，是American Values vs. Un-American
发信站: BBS 未名空间站 (Sat Oct 15 23:01:51 2016, 美东)
美国是一个法律公正，民主自由的国家，美国的新闻媒体一直是保证美国继续伟大的主
要力量。
请您问一问你自己，这次大选，
为什么没有一家大的报社endorse Trump？
为什么有这么多的右派的报社公开endorse Hillary？
为什么有这么多的共和党大佬公开endorse Hillary ？
为什么有这么多的共和党大佬说要把票投给第三方侯选人而不选Trump？
为什么？
因为今年的大选和以往不同。以前的选举，只是左派和右派的较量，左派和右派各自支
持自己的候选人，不会跑到对方阵营里为对方候选人助威。
而今年则不同，今年是American Values和Un-American的较量。Trump代表的是Un-
American，支持Hillary反对Trump就是选择了美国价... 阅读全帖 |
|
j**f
发帖数: 3137 | 36 借用个行业术语
女人time value较强属性
随time增长
女人的容貌 生育能力 综合value都二阶导数下降
内sb星光就不懂这道理。
以为自己20出头时 别人给开了100块的offer伊都没干
现在50块的offer你是特么打发叫花子呢
殊不知明年30块的offer都不会有人给你开了好伐
接着剩到老太婆吧 |
|
p***e
发帖数: 3852 | 37 value会随时间decay没错，不过仓促嫁给低端人口value就清零了 |
|
d********m
发帖数: 3662 | 38 1，楼主说的通过自己计算得出“p value都是瞎编”的结论
2，你说没见过报道raw data的文章
3，根据这两点，除了用sample mean, sd计算p value，没有别的办法
4，non-parametric根本就是钻牛角尖了
5，你说是不是？ |
|
k**********4
发帖数: 16092 | 39 我日，他说的本来就是扯蛋，除了最简单的sample size大又是normal dstribution又
只用个t test,根本无法用mean, sd计算p value，你说的也不对，biochemical
reserch中有很多不是正太分布的，或者是但是用其他test方法的,都不能用mean和sd来
计算 p value |
|
n*******t
发帖数: 7254 | 40 【 以下文字转载自 Rainbow 讨论区 】
发信人: newtenant (A-W), 信区: Rainbow
标 题: zz Gay men place less value on monogamy?
发信站: BBS 未名空间站 (Sun Jan 31 16:30:54 2010, 美东)
http://fridae.com/newsfeatures/2010/01/28/9607.gay-men-place-less-value-on-m
onogamy-than-straights
Is it generally true that gay male couples place less emphasis on sexual exc
lusivity than opposite sex couples?
Joy Behar, co-host of the talk show The View on ABC (American Broadcasting C
ompany), on Tuesday recounted her conversation with famed g |
|
y****t
发帖数: 10233 | 41 小左们,
你们真的要献屁眼给我,我就不客气了.
“Americans believe in the importance of community, responsibility, and,
most of all, family. We need to strengthen this institution that - for most
of us - is the central work of our lives and the foundation of our own and
our children’s success.”
- john edwards
http://www.issue2008.com/john-edwards-position-on-family-values
发信人: SteelDragon (金箍如意), 信区: USANews
标 题: Re: 跟小左谈逻辑真是累死.
发信站: BBS 未名空间站 (Fri Jan 20 16:53:43 2012, 美东)
Give me at least one example. Liberal presid... 阅读全帖 |
|
l****z
发帖数: 29846 | 42 By Andrew Higgins and Maureen Fan, Published: May 18 | Updated: Saturday,
May 19, 11:10 AM
CAMBRIDGE, Mass. — When scholars gathered at Harvard last month to discuss
the political tumult convulsing China’s ruling Communist Party, a demure
female undergraduate with a direct stake in the outcome was listening
intently from the top row of the lecture hall. She was the daughter of Xi
Jinping, China’s vice president and heir apparent for the party’s top job.
Xi’s daughter, Xi Mingze, enrolled at Harv... 阅读全帖 |
|
j*****v
发帖数: 7717 | 43 何況這些回答記者的排比句都是事先想好詞。
他主動攻擊trump，用ny value也是提前想好的。沒想到trump實在是反應太快了，幾句
煽情辭就化被動爲主動，Cruz居然沒辦法接招，衹好僵硬的鼓掌。
我衹能說，trump的確是個老流氓，把堂堂哈佛辯論高手秒殺
.
on
to
out |
|
发帖数: 1 | 44 New York Value 和 California Value (if there's one) 最大的区别是什么？ |
|
h******k
发帖数: 15372 | 45 New York Value主要是黑，California Value主要是墨。所以California比New York要
“土”一点！ |
|
H***l
发帖数: 1936 | 46 好歹也比Alberta Values强。
一个前加拿大公民， 在美国土地上攻击New York Value，现在又跑到NYC去拉票，真是
又要当婊子又要立牌坊。
他当过了这两月，把脸一抹擦，还真成了良人，大家就都忘了他本来的面目了？ |
|
A**d
发帖数: 13310 | 47 你还能更傻逼一点吗？科鲁兹说的New York value 显然是攻击床铺在堕胎、禁枪、赌
场这些事情上的liberal value。根华尔街有个屁关系？跪舔希拉里舔的都离不开华尔
街了？ |
|
m****g
发帖数: 822 | 48 准备买一辆二手车，三年6万miles
warranty里有一条规定是
Transferable - The powertrain warranty can be transferred from owner to
owner, adding value at the time of resale or trade-in.
请问“adding value at the time of resale or trade-in”什么意思？
另外这个warranty是powertrain warranty，有什么特殊的吗？不懂车，谢谢解答！ |
|
g**********0
发帖数: 180 | 49 So which one I would choose if I want to sale it personally to a guy?
Or I choose a value between these two?
Thanks. |
|
j*****A
发帖数: 1395 | 50 你那死脑筋转不过弯来。
车子出了大的车祸，只能自认倒霉，车子再怎么修好，也是一辆撞过的车。保险公司只
负责修好车，value loss 那是你自己的事，因此开车尽量避免车祸。
即便人没问题，你还是可以通过律师向对方保险公司索取医疗赔偿，如果这部分钱能
cover你的value loss, 你应该感到满足了。 |
|
