b*****e
发帖数: 223 | 1 proc tabulate 在 proc tabulate 之后就渐渐要被淘汰了吧？ |
|
b*****e
发帖数: 223 | 2 我几乎没用过 proc tabulate，可能学生时候偶尔用过一两次。前不久我查 proc
report 的时候，有篇文章好像是这么说，有了 proc report, proc tabulate 就几乎
被取代要淘汰了。公司里应该是 proc report，data _null 的方法用得比较多。 |
|
s*****9
发帖数: 285 | 3 Proc tabulate;
table age = 'Age'*
( min = 'Min' * f = 3.
max = 'Max' * f = 3.),
结果
min * *
max * *
怎么样才能把结果变成
min.max *,* *,*
用proc report应该可以搞定，不过不知道tabulate有没有办法
感谢 |
|
c****g
发帖数: 156 | 4 data have;
input grp $ year loss interest;
cards;
EXA 2004 123 12
MGR 2005 234 13
MGT 2006 345 23
EXA 2004 456 23
MGR 2005 457 45
MGT 2006 478 15
;
proc tabulate data=have;
class year grp ;
table year='', sum=''*grp="Group"*(loss interest)*f=8. /rts=10.;
var loss interest;
run;
|
|
h******n
发帖数: 232 | 5 Thank you so much!
还有一个问题。proc tabulate 能否求将每一列的sum，列在表格下方呢？
能否将每一行的loss的sum，以及每一行interest的sum也列在表格右侧呢。
拜谢拜谢！ |
|
l****e
发帖数: 15 | 6 proc tabulate data=have;
class year grp ;
KEYWORD sum;
table year='', sum=''*grp="Group"*(loss interest)*f=8.
(loss interest)*(sum*f=8.) /rts=10.;
var loss interest;
run; |
|
h******n
发帖数: 232 | 7 非常感谢！
我尝试run了你的code。右侧的loss和interest的sum是work的。有没有办法能把每一列
的sum显示在表格的底部呢？
我看了一些proc tabulate的例子，但掌握的不是很通畅。所以麻烦大家了。
拜谢！ |
|
S******y
发帖数: 1123 | 8 what is the equivalent of PROC TABULATE in R? |
|
S******y
发帖数: 1123 | 9 what is the equivalent of PROC TABULATE in R? |
|
l*****k
发帖数: 587 | 10 several columns( let's say A, B, C, etc), each record grouping
info for rows(about 300 row)
the groups label are 1 or 2 or 3
I am not sure if there are funciton to tabulate
A1 B1
A2 B2
A1 B2
A2 B1
easily, then calculate if their grouping overlap significantly
I guess in this case chi square.
多谢。。。 |
|
c*******n
发帖数: 300 | 11 有些统计量为0，tabulate的结果显示为 . 。
请问怎么将 . 显示为0？谢谢。 |
|
c*******n
发帖数: 300 | 12 我不是说missing value.
我用的是tabulate 和table.
比如说某一组的数量为零，table里面就显示为 . 。 其它的数据都能正常显示。 |
|
y****1
发帖数: 400 | 13 Sorry ha no Chinese installed in my office computer~
I used some tabulate procedures, but from my recollection if statistics
are zero they should be displayed zero.
"比如说某一组的数量为零，table里面就显示为 ."
What 数量 did you mean? If the statistic (or the computation procedure) is
not allowed to be zero, like a quotient, it will be displayed missing. |
|
c*******n
发帖数: 300 | 14 是我没说清楚。我说的数量是说人数，是可以为零的。
我就用了proc tabulate， class， table几个语句。我想可能是其中某个语句
默认那样的输出格式，请问你有没有对这些语句的默认options进行修改？
谢谢。 |
|
l***a
发帖数: 12410 | 15 personally I never used proc report. always proc tabulate |
|
|
p***r
发帖数: 920 | 17 two data set, having the same class variable, can i put them together in
one tabulate procedure?
Thanks |
|
b*********l
发帖数: 466 | 18 Why not stack two datasets together before running tabulate |
|
b*********l
发帖数: 466 | 19 How to produce tabular format table without using proc tabulate?
Tabular format is like the following:
|--------+-------------+--------------+--------+-----------+------------|
|lbtest| aaaaaa | bbbbbb |ccccc |ddddd |eeeeee |
|--------+-------------+--------------+--------+-----------+------------| |
|
y***e
发帖数: 6 | 20 I have five variables, A, B, C, D and E, the value for each variable is
either 1 or missing. I want to count the frequency of "1" in each variable
and make a better looking output like this:
1 .
----------------
A 5 8
B 5 1
C 87 0
D 6 5
E 18 5
When using the proc tabulate, I can only put the A - E variable in the
column instead of row. Asking for help! Thanks! |
|
a****g
发帖数: 8131 | 21 yes
you can use proc tabulate for this |
|
j*********9
发帖数: 161 | 22 Now, I do not have any decent Baozi left.
Actually I tried proc tabulate first, which can give me the numbers i want
and they are all in one table, but it has extra columns and rows. So
frustrating.... |
|
j******h
发帖数: 6 | 23 请问大牛，Proc tabulate中加哪个option可以把输出table的仅是边框加粗加黑呢？提
前谢谢啦。 |
|
f*****7
发帖数: 92 | 24 DP的定义是递归的
我们要得到原问题的最优解，就得先算出若干个子问题的最优解，然后extend到原问题
。我们不断地把大问题归结为若干个小问题，最后就是解决base case。这种思维方式
by nature就是递归的思想。----最优子结构
对于多个大问题，要解决它们所用到的子问题可能有重复。所以我们需要用cache记录
已经计算过的子问题，如果该子问题被解决过了，直接从cache中fetch子问题的解。如
果该子问题没有被解决，那么就解决这个子问题，并且将solution存在cache对应的
entry里。----重复子问题
这两个是DP的重要性质。
CLRS对于DP的算法有两种
1. Top-down recursion with memoization
这种写法就是递归，用数组保存子问题的solution。
好处在于解决某些大问题，并不需要tabulate所有的子问题的时候，我们可以节约计算
时间，类似lazy evaluation。子问题只有在需要的时候才会被计算。第二个好处是直
接从定义出发，递归结构清晰，易于调试。
坏处是递归函数需要OS维护stack frame，如果问... 阅读全帖 |
|
M******e
发帖数: 1193 | 25 https://gizmodo.com/alabama-supreme-court-okays-destruction-of-digital-voti-
1821223685?utm_campaign=socialflow_gizmodo_twitter&utm_source=gizmodo_
twitter&utm_medium=socialflow
On Monday, a judge ordered local election officials to save digital images
of ballots, AL.com reports. However, his decision was quickly reversed by
the Alabama Supreme Court, which stayed his order Monday evening.
“If the race goes to a recount following the election, Alabama’s recount
laws won’t do enough to protect vo... 阅读全帖 |
|
a*******0
发帖数: 35 | 26 【 以下文字转载自 Statistics 讨论区 】
发信人: aladding0 (阿拉丁), 信区: Statistics
标 题: 【工作机会】SAS programmer with 3yr experience-DC
发信站: BBS 未名空间站 (Wed Mar 14 13:52:44 2012, 美东)
A SAS programmer is needed immediately by a pharmaceutical company located
in downtown DC.
Please send your CV to: d********[email protected]
-----------------------------------------------------
Position Description & Responsibilities
The SAS Programmer is part of the Informatics Department and will be
assigned to project teams. They wou... 阅读全帖 |
|
a*******0
发帖数: 35 | 27 A SAS programmer is needed immediately by a pharmaceutical company located
in downtown DC.
Please send your CV to: d********[email protected]
-----------------------------------------------------
Position Description & Responsibilities
The SAS Programmer is part of the Informatics Department and will be
assigned to project teams. They would be responsible for working with the
statistical function and the clinical study team in the reporting of
clinical studies.
Roles and responsibilities include... 阅读全帖 |
|
c**m
发帖数: 44 | 28 有兴趣的，请把resume发到：[email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=String.fromCharCode(c);}s=document.createTextNode(s);l.parentNode.replaceChild(s,l);}}catch(e){}})();
/* ]]> */
， 谢谢！
Vanda is seeking a SAS Programmer/Statistical Analysis who will primarily be
responsible for the developmen... 阅读全帖 |
|
t**********3
发帖数: 12623 | 29 On the same day lawmakers count the electoral votes on Capitol Hill,
officially certifying President Obama’s victory in the Electoral College,
the AP released a tabulation of official presidential votes from all 50
states.
As tabulated by the AP, Romney got 47.2 percent of the full presidential
vote.
He did a bit better – 48.0 – if you just look at the two top candidates.
That number – 47 percent – resonates in the context of the race because of
Romney’s infamous “47 percent” comments that seeme... 阅读全帖 |
|
d********f
发帖数: 43471 | 30 基本操作就是投票站关门了之前送几麻袋票进来，然后后面5天慢慢看情况要不要造点票
Arizona GOP sues to limit mail-in ballots in McSally-Sinema race
Share Tweet Reddit Flipboard Email
Republicans filed a lawsuit Wednesday night to challenge the way some
Arizona counties count mail-in ballots, as election officials began to
slowly tally more than 600,000 outstanding votes in the narrow U.S. Senate
race. The task that could take days.
Republican Rep. Martha McSally and Democratic Rep. Kyrsten Sinema were
separated by a small fraction of... 阅读全帖 |
|
w******i
发帖数: 1476 | 31 SAS Interview Questions from http://www.sconsig.com/
Very Basic
What SAS statements would you code to read an external raw data file to a DATA
step?
How do you read in the variables that you need?
Are you familiar with special input delimiters? How are they used?
If reading a variable length file with fixed input, how would you prevent SAS
from reading the next record if the last variable didn't have a value?
What is the difference between an informat and a format? Name three informats
or format... 阅读全帖 |
|
l***k
发帖数: 54 | 32 替朋友发招聘~ 请联系刘洋：Y******[email protected]
A world top 5 Clinical research company(CRO) looking for SAS talent to
go back to china, based in Beijing and Shanghai
The position is from entry level to director level
如果你是学习统计或计算机，如果你了解SAS或者作过SAS相关工作，都有合适的职位，
刚毕业的学生
也可申请，在国内做SAS的人少，回国可以在这个行业作的比较精专，随着国内的快速
发展，回国的
人也很多，所以想回来的同志们可以认真考虑考虑
薪水方面可以谈，从entry level来讲给的不错
如果你有兴趣，请发简历到 Y******[email protected] ,或者发联系方式给我，我们在可以
深入沟
通，包括薪水等
此帖子朋友带发，所以最好发邮件给我
我们现在的职位opening 有：
Biostatistician&Programming
· Senior Biostatist... 阅读全帖 |
|
G**********N
发帖数: 63 | 33 Location: (Shanghai, China P.R.)
Company: (www.ppdi.com)
Position: (SAS programmer, Sr. SAS programmer)
Contact info: (B********[email protected])
Major Required: (Mathematics, Statistics, Physics, etc.)
Essential Responsibilities
1. Develops SAS programs to produce data listings and Case Report Form
Tabulations (CRT);
2. Builds standard tabulation datasets;
3. Creates derived or analysis datasets;
4. Develops SAS programs to implement statistical analyses to generate
tables, listings and figures as s... 阅读全帖 |
|
G**********N
发帖数: 63 | 34 Location: (Shanghai, China P.R.)
Company: (www.ppdi.com)
Position: (SAS programmer, Sr. SAS programmer)
Contact info: (B********[email protected])
Major Required: (Mathematics, Statistics, Physics, etc.)
Base Salary: 8000 - 25000 RMB/Month based on experience [Before tax].
Essential Responsibilities
1. Develops SAS programs to produce data listings and Case Report Form
Tabulations (CRT);
2. Builds standard tabulation datasets;
3. Creates derived or analysis datasets;
4. Develops SAS programs to implem... 阅读全帖 |
|
|
v***o
发帖数: 51 | 36 要生成很多表，想知道tabularx里的第一个width项是否可以自动生成并对每个表格都
合适。省去不加，效果不好。用统一宽度，担心列数不一或列宽不一会使各表疏密不一
。 当然更可能是这package一定要让我们填这项，因为其中有latex自身的故事，那就
更恳请高人指教了。
起因是用tabout（一个Stata下的宏）从Stata里批量生成tabulations。这个tabout是
用tabularx的。有高人知道更好的可以批量生成可自定义的多维tabulation的宏/
package，那也好。 |
|
g**r
发帖数: 425 | 37 DATA STEP是必须要搞熟的，除了读入文件DO LOOP什么的，
retain, first. last.； date format,这些都不在话下
MACRO很重要，很重要很重要；但MACRO学起来是很容易的，比DATA STEP
容易好多
PROC TABULATE (or PROC REPORT);要搞搞熟的，这个很重要
Haworth的 PROC TEBULATE BY Example是值得花时间读一读的
我痛恨胡乱用PROC TABULATE的PROGRAMMER，那么强的工具，经常被人
糟塌--明明三五行就解决的事情，楞写出百十行来，让人看的那个难受。
直观易懂的PROC MEANS, PROC FREQ当然不用说了
PROC GPLOT和PROC GCHART要翻一翻的，AXIS,PATTERN, LENGEND,SYMBLO什么的
临时学倒是来的及。但人家问你的时候你要知道SAS GRAPH这回事情。
如果是搞TRIAL的，PROC LIFETEST, PROC PHREG要看一看的；
否则的话，PROC REG, PROG LOGISTIC, PROC GLM翻翻 |
|
j****e
发帖数: 158 | 38 use ods tagsets excel
ods listing close;
ods tagsets.ExcelXP path='output-directory' file='aedata.xml' style=SUGI31;
ods tagsets.ExcelXP options(sheet_name='Data - Trial 1');
* Proc PRINT #1 here w/ style override;
ods tagsets.ExcelXP options(sheet_name='Data - Trial 2');
* Proc PRINT #2 here w/ style override;
ods tagsets.ExcelXP options(sheet_name='Summary - Trial 1');
* Proc TABULATE #1 here;
ods tagsets.ExcelXP options(sheet_name='Summary - Trial 2');
* Proc TABULATE #2 here;
ods tagsets.Exc |
|
s*****r
发帖数: 790 | 39 NOTE: Don't ask me anything. I was just contacted by this one and have no
other information.
Biostatistician
Hyattsville, MD
Job Description:
General: Specializes in the application of statistics and/or computer
technology to epidemiological studies, laboratory studies, prevention
research, and other selected forms of studies/research conducted and/or
supported by Public Health. Requires thorough knowledge and use of
commercial statistical software packages.
Experience with sample size calculat... 阅读全帖 |
|
s********r
发帖数: 729 | 40 Programmers Analyst Location: Beijing/Shanghai, China P.R.
Company: PPDi Beijing/Shanghai
Key words SAS, C++, JAVA, PROGRAMMING, STATISTICS, MATHEMATICS
Major Required: IT preferred. Other majors like Mathematics, Statistics,
Engineering, Physics are acceptable if have strong IT (ORACLE, JAVA, C++)
and English background.
Essential Responsibilities
1. Develops SAS programs to produce data listings and Case Report Form
Tabulations (CRT)
2. Builds standard tabulation datasets
3. Creates derived or... 阅读全帖 |
|
G**********N
发帖数: 63 | 41 Location: Shanghai, China P.R.
Company: PPDI: www.ppdi.com
Position: SAS programmer, Sr. SAS programmer
Contact info: B********[email protected]
Major Required: Mathematics, Statistics, Physics, etc.
Essential Responsibilities
1. Develops SAS programs to produce data listings and Case Report Form Tabulations (CRT);
2. Builds standard tabulation datasets;
3. Creates derived or analysis datasets;
4. Develops SAS programs to implement statistical analyses to generate
tables, listings and figures as specif... 阅读全帖 |
|
G**********N
发帖数: 63 | 42 Location: Shanghai, China P.R.
Company: www.ppdi.com
Position: SAS programmer, Sr. SAS programmer
Contact info: B********[email protected]
Major Required: Mathematics, Statistics, Physics, etc.
Essential Responsibilities
1. Develops SAS programs to produce data listings and Case Report Form
Tabulations (CRT);
2. Builds standard tabulation datasets;
3. Creates derived or analysis datasets;
4. Develops SAS programs to implement statistical analyses to generate
tables, listings and ... 阅读全帖 |
|
G**********N
发帖数: 63 | 43 Location: Shanghai, China P.R.
Company: www.ppdi.com
Position: SAS programmer, Sr. SAS programmer
Contact info: B********[email protected]
Major Required: Mathematics, Statistics, Physics, etc.
Essential Responsibilities
1. Develops SAS programs to produce data listings and Case Report Form
Tabulations (CRT);
2. Builds standard tabulation datasets;
3. Creates derived or analysis datasets;
4. Develops SAS programs to implement statistical analyses to generate
tables, listings and ... 阅读全帖 |
|
G**********N
发帖数: 63 | 44 Location: (Shanghai, China P.R.)
Company: (www.ppdi.com)
Position: (SAS programmer, Sr. SAS programmer)
Contact info: (B********[email protected])
Major Required: (Mathematics, Statistics, Physics, etc.)
Base Salary: 8000 - 25000 RMB/Month based on experience [Before tax].
Essential Responsibilities
1. Develops SAS programs to produce data listings and Case Report Form
Tabulations (CRT);
2. Builds standard tabulation datasets;
3. Creates derived or analysis datasets;
4. Develops SAS programs to implem... 阅读全帖 |
|
d******9
发帖数: 404 | 45 来自主题: Statistics版 - sas问题 We can also create an indicator, then use Proc Tabulate to do it.
Proc sort data= X;
by A B C;
run;
data Y;
set X;
if first.C then flag=1;
else flag= . ;
run;
proc tabulate data=Y;
class A B;
var flag;
table A, B*flag*sum; (or: B*flag*N. For missing values, the N and Sum produce same results.)
run; |
|
G**********N
发帖数: 63 | 46 Location: (Shanghai, China P.R.)
Company: (www.ppdi.com)
Position: (SAS programmer, Sr. SAS programmer)
Contact info: (B********[email protected])
Major Required: (Mathematics, Statistics, Physics, etc.)
Base Salary: 8000 - 25000 RMB/Month based on experience [Before tax].
Essential Responsibilities
1. Develop SAS programs to produce data listings and Case Report Form
Tabulations (CRT);
2. Build standard tabulation datasets;
3. Create derived or analysis datasets;
4. Develop SAS programs to implement ... 阅读全帖 |
|
h***x
发帖数: 586 | 47 CALIFORNIA:
0000087272
SAS Programmer (12m)
Bachelor's or Masters in Computer Science or other relevant (Engineering)
degrees with 5+ years of pharmaceutical experience preferred- The work
experience should include at least two years of technical leadership in a
statistical programming environment in a pharmaceutical or biotechnology
environment including the analysis and reporting of clinical trial data-
Knowledge and application of p-values, confidence intervals, linear
regression analysis, ad... 阅读全帖 |
|
H****g
发帖数: 14447 | 48 【 以下文字转载自 Military 讨论区 】
发信人: Herzog (singularity), 信区: Military
标 题: 指责陈光诚拿NED的钱真是个笑话
发信站: BBS 未名空间站 (Sat May 5 14:29:35 2012, 美东)
中国政府从1994年起，就开始变相申请NED基金，邀请IRI参与乡村选举。
Sources：
1. IRI和中国民政部。
建于1984年的美国共和研究所（IRI）是第一家介入中国村民选举的外国NGO，与中国政
府有着密切关系。1994年，IRI与中国民政部协商IRI如何帮助中国的村民选举工作，并
在其中扮演适当角色。
http://www.sociology.cass.net.cn/shxw/xcyj/P0200511303117300060
2. 维基对IRI的介绍。
IRI was involved in Haiti prior to the 2004 Haitian coup d'état,[4] in
Honduras following the 2009 Honduran constitutional crisi... 阅读全帖 |
|
s*********8
发帖数: 901 | 49 Between 300M to 313million, 10% of whom have no job. hard to tell.
WASHINGTON – Census surprise? The government provided new estimates Monday
showing the U.S. population grew to somewhere between roughly 306 million
and 313 million over the last decade, acknowledging uncertainty due to rapid
shifts in immigration.
The estimates, which are separate from the official 2010 census count, are
based on a review of birth and death records as well as calculations of new
immigrants as of April 1, 2010. D... 阅读全帖 |
|
