w*******n
发帖数: 469 | 1 proc sort data=one; by id; run;
%macro search()
%do i=1 %to num;
%searchone(&i);
%end;
%mend;
%macro searchone(index);
data oneobs;
set DatA(firstobs=&index obs=&index);
run;
data one;
if 1=1 then delete;
run;
data dataB one;
merge oneobs(in=inone) dataB(in B);by id;
if inone & B then output one;
if inone & B then delete;
output dataB;
data match;
set match one; run;
%mend; |
|
f******y
发帖数: 14 | 2 使用VC++编程；
我建立一个序列，希望每次加1，
我在sql plus下执行
select SEQ_MESSAGE_MESSAGE_NUM.nextval from dual;
每次都是对的；
但在程序里面每次却加2，让我不理解;
序列创建：
CREATE SEQUENCE SEQ_MESSAGE_MESSAGE_NUM
INCREMENT BY 1
START WITH 1
MAXVALUE 1.0E28
MINVALUE 1
NOCYCLE
CACHE 20
ORDER;
程序：
ODatabase datab;
ODynaset dyn;
... ...
nOracleRet=dyn.Open(datab,"select
SEQ_MESSAGE_MESSAGE_NUM.nextval from dual");
int nNextVal;
dyn.GetFieldValue(0,&nNextVal);
dyn.Close();
... ...
CString szSql;
szSql.Format("Insert into Transmit_Message
(Message_Nu |
|
p********a
发帖数: 5352 | 3 ☆─────────────────────────────────────☆
Bighappy (快乐大大大) 于 (Fri Apr 6 14:47:46 2007) 提到:
大侠帮忙看看下面的程序：
data dataA;
input var1 var2;
datalines;
1.2 2.0
4.2 3.2
3.8 1.8
6.0 9.3
7.5 5.4
8.6 7.2
;;;;
data dataB;
input var3 var4;
datalines;
2.1 2.4
2.3 7.2
3.4 2.8
9.4 5.5
5.5 5.9
7.8 7.2
1.1 1.4
4.5 6.5
;;;;
data new;
merge dataA dataB;
run;
proc print; run;
产出的结果如下：
Obs var1 var2 var3 var4
1 1.2 2.0 2.1 |
|
|
y****t
发帖数: 10233 | 5 加州是怎么被搞破产的?
About 80 percent of government budgets are spent on salary and related
personnel costs such as health benefits and pension contributions.
That's $12,200,000,000.
Ever wondered how much your city is paying that cop who just pulled you over
for blowing through a red light? How about the worker who cleans the
restrooms at the park down the street?
The details of more than $12.2 billion in tax money spent on local
government salaries in 2009 are now available on a searchable online
datab |
|
x*****i
发帖数: 253 | 6 wtf do you mean by beating a software using
another software? i told you, xx's AI strength
is higher than xql's, and this is proved in international
matches.. don't you get it??
ur logic is that u mixed the human intelligence and
software against another software without any aid.
and that's why u made such a big joke saying "software
strength depends on how you train it"
do i need to teach you what *fair comparison* is?
same environment, same speed pcs, same seconds/move,
same hard-coded datab |
|
D*****E
发帖数: 9352 | 7 只要你能说服航空公司AGENT让你登机，墨西哥移民局那边没有问题。因为IATA的DATAB
ASE里只说明了VISA，没说明AP，所以你得说服航空公司的AGENT |
|
|
|
|
n********a
发帖数: 68 | 11 run $ORACLE_HOME/sqlplus/demo/demobld.sql
让 |
|
|
B*****g
发帖数: 34098 | 13 the answer for these questions is "depends".
Without talking about more database structure like index, and without analys
is the real data, can not answer this questions.
但是一般来说，最好不要太依赖database。你是最了解你自己的table的，而不是datab
ase
index( |
|
M*****r
发帖数: 1536 | 14 http://blog.wired.com/monkeybites/2008/04/microsoft-datab.html
By Scott Gilbertson EmailApril 28, 2008 | 8:04:40 AMCategories: security
sqltablesattack.jpg
A new SQL injection attack aimed at Microsoft IIS web servers has hit some
500,000 websites, including the United Nations, UK Government sites and the
U.S. Department of Homeland Security. While the attack is not necessarily
Microsoft's fault, it is unique to the company's IIS server.
The automated attack takes advantage to the fact that Mic |
|
|
s*****n
发帖数: 2174 | 16 在R里面, 你也可以每个data 一个 matrix, 或者用R里面专门的dataset 概念.
即使merge, 也比SAS里面的merge简洁的多.
merge(dataA, dataB, by=c("var1", "var2")) 就行了.
如果两个dataset不是完全匹配, 你可以加上 all.x = T, 或者 all.y = T 的选项.
完全等价于SQL里面的 left join, right join, 等等这些概念.
反倒是SAS里面的merge, 非常罗嗦,
首先是必须sort, 如果不完全匹配的话, 还要搞什么 dataA(IN=x), 非常不符合通常的
编程习惯. |
|
d******9
发帖数: 404 | 17 Data B;
Retain C 0;
Set A;
A2=A1-C;
C=A1;
run;
or:
DataB;
Set A;
If _N_=1 then A2=A1;
Else A2= DIF(A1);
Run; |
|
A*******s
发帖数: 9638 | 18 一个眼科医生一年光从medicare拿了2千万，难怪医生工资被消减， 底层医生倒霉。
WASHINGTON — Medicare paid a tiny group of doctors $3 million or more
apiece in 2012. One got nearly $21 million.Those are among the findings of
an Associated Press analysis of physician data released Wednesday by the
Obama administration, part of a move to open the books on health care
financing.Topping Medicare's list was Florida ophthalmologist Salomon Melgen
, whose relationship with Sen. Robert Menendez, D-N.J., made headlines last
year after news ... 阅读全帖 |
|
