l*********s
发帖数: 5409 | 1 very difficult if possible.
// to correct myself, check out this SUGI paper which might be your answer.
"Using Styles and Templates to Customize SAS® ODS Output" |
|
|
n******r
发帖数: 1247 | 3 UTF-8格式
有人有code可以share吗？
谢谢！ |
|
a*****3
发帖数: 601 | 4 什么是 x window ??
反正我觉得sas造了个黑盒子， 文档也写得不明不白, 比如最简单的format/informat,
这连个东西什么区别，里面的实现机制， 文档里可是语焉不详， 我看了好几遍都没
看懂. 问个最最简单的，如何定义 numeric/character informat/format = ? 我出20
伪币 看谁能把定义从文档里找出来.
再比如说排序这个事, 里面的mechanics也不清楚， 比如说，排玩序了，是在dataset
里面做了记号，还是在pdv里面做了什么手脚？ First. Last. 然后是根据什么生成的
？尤其象by var1 var2 var3， 然后引用First.Var2 这种情况 文档里可是一点没说
呀.
还有通过ods结合各种procs生成的dataset, 里面是什么变量，什么命名规则，目前还
没研究过文档..估计也是写得一塌糊涂.
总之 这个黑盒子也许不错, 就是太黑了。 |
|
p********a
发帖数: 5352 | 5 OPEN的时候每次都要提示 it is in a different format than specified by the
file extension. Verify that file is not corrupted ...
这很ANNOYing，有没有办法不让EXCEL出这个提示呢？我知道它其实是XML。 |
|
|
s*******e
发帖数: 1385 | 7 为什么我没有过这种问题，你specify的file name那么是XXXXXX.xls吗？ |
|
p********a
发帖数: 5352 | 8 Yes, Excel extensions.
My file was created under unix SAS. Maybe it is because of Unix?
My other files created under Windows don't have such issues. |
|
s*******e
发帖数: 1385 | 9 I don't have this problem with unix SAS either. |
|
|
m******u
发帖数: 277 | 11 总结一下面试被问到的一些问题。
General questions:
- Why are you interested in this position?
- Tell me something about yourself.
- Give me an example how you deal with challenging problems.
- Describe how you deal with multi tasks.
- Show us a writing example that you recently completed.
- What is your career goal in 5 years?
- How do you communicate with your collaborators?
- Have you ever worked on a project in a team? How did you do it?
Technical questions:
- How do you describe your SAS/R skills?
- Where d... 阅读全帖 |
|
d******9
发帖数: 404 | 12 ODS + style
Visit SAS web to find details. |
|
a********a
发帖数: 19 | 13 楼主背景是生统小硕即将毕业，没有Phama的实习经验，只有学校RA，没有sas证。投的
简历不多，主要是在2月份，陆陆续续的有10多家。这是第一个offer，不是top的公司
，但是给的package对于我这个没什么经验的人来说还不错，就从了。以下是面试的经
过分享给大家，版上的经验贴很QQ群里给我提示很多，谢谢这些前辈们分享的宝贵经验。
电面直接是hiring manager，听上去比较 relax, 没有问细节的专业问题，只是问了简
历相关的，我在学校做的RA具体的responsibility是什么。然后问我希望什么时候开始
工作，是打算毕业以后休息一下还是马上开始。然后直接告诉我他们会让我去公司谈，
因为距离比较近，相当于local。
onsite是四天后，而且这是我第一个onsite, 所以几乎没有时间准备.见了hr和team的4
的人：sr programmer， sr biostatistician，sr data manager
和部门的头儿。他们问的问题也跟他们自己的职位没有太相关，而且很多时间都在闲聊
，汗...onsite两周以后通知的offer.
能想起来的有以下... 阅读全帖 |
|
z**********i
发帖数: 12276 | 14 First, I will suggest to use "ods trace on" to make sure the table names. |
|
d******9
发帖数: 404 | 15 It should work, the codes look fine except:
ods pdf file="plot&it..pdf";
You need use 2 dots rather than 1 dot after the macro variable. |
|
m*********n
发帖数: 413 | 16 现在还在用SAS Graphics的人比SAS Graphics还脑残，是不是都是用盗版的学生在这里
灌水，没听说过ODS Graphics吧，9.4都快出来了，你们还在讨论9.1.3吧 |
|
p***r
发帖数: 920 | 17 在学校很简单的用过，觉得不顺手。还是 macro + proc tabulate + ODS 好啊，一次
性生成几百个table 十几分钟就搞定了。 |
|
G*********e
发帖数: 182 | 18 一个dataset有5个variables.
Name, Company, email, Home Phone, Work Phone, Cell Phone
每条记录生成一个table,每个table占一页.
Table的边不是用"-","|"构成的,而是用ods pdf直接生成.
|-------------------------------------------------|
| Name: | |
|-------------------------------------------------|
| Company: | |
|-------------------------------------------------|
| Email: | |
|--------------------------------------------... 阅读全帖 |
|
v*******e
发帖数: 133 | 19 SAS table, variable A, B, C
现在需要的到一个excel spreadsheet, 只保留variable A, B, 但是highlight部分
rows,是否highlight是由C来决定。
用ODS output，proc report里面的computer block，highlight了需要的rows,但是没
有办法去掉column C且同时highlight。
请教SAS 高手。 |
|
o******6
发帖数: 538 | 20 proc means data=a p50;
var xxx;
ods output summary=median;
run;
data a;
if _n_=1 then set median;
set a;
if xxx=. then xxxcat=.;
else if xxx le xxx_P50 then xxxcat=0;
else xxxcat=1;
run;
或者用 CALL SYMPUT:
data _null_;
set median;
call symput ('median',xxx_p50);
run;
............. |
|
z**********i
发帖数: 12276 | 21 你的签名档是哪来的数据？
我也很感兴趣我过去10来年的成长经历。
多谢！
用的不多，用ods trace on; 看看都有什么可以提取的？
如果，不能自动predict,自己把需要的数提出来，简单写个公式算一下，就可以得到
predicted value吧？
dependent |
|
|
p******m
发帖数: 65 | 23 请注意这里是‘cvs'
ods csvall file='c:\test.cvs'
这样的话正确答案是c
但是这个估计是typo.
因为在正式考试里我也碰到了这道题，他就变成了'csv'.
答案就是b |
|
S********s
发帖数: 42 | 24 我在考试的时候也碰到了这道题， 题目给的是：ods csvall file='c:\test.csv',答
案应该是b. |
|
c**d
发帖数: 104 | 25 maybe you can do this way (I did not write the whole codes):
/* 1: work on numeric */
/* output data include 3 columns:id, label, max value */
proc means data = test;
class id;
var _numeric_;
output out= max = _max;
run;
/* transpose by id and use label as variable name*/
proc transpose;
run;
/* 2: work on char variables */
/* you can also get id, varname, unique value and freq */
proc freq data = test;
table id*_char_;
ods output freqtable;
run;
/* do a data step to remove the row id*id in the... 阅读全帖 |
|
a***d
发帖数: 336 | 26 glmselect does not seem to have an option like outest..
do I have to manually copy the coefficients from the ODS outputs?
Thanks a lot! |
|
|
s***1
发帖数: 343 | 28 签了orange county那个，原因是后来他们说也做一些data mining，这个弥补了我之前
的犹豫。同时答应立刻给办H1-B。
这个公司的相关面经，面了4轮：
第一轮电面：recruiter
intern experience
用过的methodology
background的强处在哪里
co-worker对你的评价
缺点
sampling的方法和具体怎么做（这个比较汗，我说什么她明显没明白，到头来她自己笑
了，说是公司让她问的，看我做过就行。。）
第二轮店面： Clinical Operation Director
go over resume
imputation method
study design experience
SAS questions(ODS/Sql/..)
第三轮onsite: Clinical Operation Director/Clinical Scientist/VP/HR
go over projects and intern experience, 问得非常非常细
HR问了好多behavioral question，但是没有特别刁难的
第... 阅读全帖 |
|
l*****8
发帖数: 483 | 29 写到excel得时候，可以试下 select '"'||colm1|'"' as colum2.
或者 """||colum1||""" as colum2
总之就是加 两个 引号在数字的两边。
具体哪个我忘了 |
|
w******8
发帖数: 59 | 30 Hi, All,
1) I can't copy a table out of the output window or anything for that matter
. I know I can use ODS to get the table but is there any way to go around
it?
2) I can't really insert text in the editor as well. All it does is
replacing the following text if you know what I mean.
Thanks for your help! |
|
|
h******s
发帖数: 3420 | 32 proc report, ods, sql join (left, right)
SAS |
|
y*****w
发帖数: 1350 | 33 各位distribution大拿好，我最近有个sample size calculation project。是count
data，具体说是number of patient visits, with number of episodes for each
number of visit。请各位帮着参谋看一下我做的是否合适，给些意见。
Sample data如下：
# patient visit episode
---------------------------------
1 156
2 287
3 589
4 899
5 1535
6 1408
7 1017
8 ... 阅读全帖 |
|
j********t
发帖数: 201 | 34 got your message from private box - sorry to reply late:
a few things that might be useful, but please contact your regulatory
department for the final formats:
1) even for non-cdisc compliant submission, it's useful to provide a define.
xml(use proc contents, ods tagsets.excel) and define.pdf (refers to http://www.lexjansen.com/pharmasug/2012/AD/PharmaSUG-2012-AD14.pdf).
2) limit length of variable names to 8 even SAS 9.2 or later goes beyond
that. (label length = 40).
3) make xpt files that le... 阅读全帖 |
|
j*****3
发帖数: 6 | 35 Anyone interested please send resume to j************[email protected] or apply
through the following link:
http://careers.peopleclick.com/careerscp/client_medtronic/exter
Position Description
Provide experienced, comprehensive technical expertise as part of the
Statistical Programming (SP) team to develop and maintain programs and
process methodology to meet internal and external clients’ needs. Plan and
lead the development of solutions to all statistical analysis programming
needs, particularly com... 阅读全帖 |
|
b****d
发帖数: 35 | 36 【 以下文字转载自 JobHunting 讨论区 】
发信人: budbud (I am bored), 信区: JobHunting
标 题: job opening in northern NJ, key word: statistical modeling, SAS, commerial lending
发信站: BBS 未名空间站 (Wed Oct 16 20:26:11 2013, 美东)
Urgent Hire, expect to start ASAP.有兴趣请站内联系。
AVP, Quantitative Analyst (Credit Scoring Models)
This is a position within the Quantitative Development & Analysis Group.
The incumbent is expected to design, develop, implement and maintain various
credit scores and their applications in credit decisi... 阅读全帖 |
|
k*z
发帖数: 4704 | 37 【 以下文字转载自 Database 讨论区 】
发信人: kiz (泥偶), 信区: Database
标 题: 问一个初级的问题关于数据仓库的维度
发信站: BBS 未名空间站 (Tue Nov 12 15:20:30 2013, 美东)
如果我的OLTP表是一个宽表。里面有时间，地点，产品，产品属性，产品厂商，运营数
据等等。
现在数据是每天同步到ODS一个Staging数据库里。
如果我想把这个宽表拆成 多个维度，和最后的事实表-运营数据。
我怎么让两个表里的维度key统一呢？如果增加了一个维度的值的话，怎么处理呢？这
个key怎么自增加，怎么保持唯一。
说的有点笼统，但是请尽量回答。谢谢。
一般来说生产库的表不会是宽表，但是我们这个数据库本身就是给前台用的优化过的逻
辑表。所以基本我们需要的东西都有了。 |
|
j********t
发帖数: 201 | 38 SAS的前景可怕吗？
One student got a job from pharmaceutical industry and asked me to be her
referral. At the end of our conversation, she asked if her SAS programmer
position is stable and if she needs to learn Python ASAP.
Her quote is: some people at MITBBS had created the feeling that SAS is
going to die.
I know the posts about R/Python. But I did not know they are so influential
to the new gradates. Therefore, I feel it is necessary to post my 3 cents
from my point of view.
Here are a few point... 阅读全帖 |
|
j********t
发帖数: 201 | 39 1) focus on projects. No matter how small the projects are, you should pick
one. I use SAS to process my credit cards account records and
bankstatesments. I also use SAS to find houses in the realtor.com and the
build models for the prices.
2) focus on the basic skills, not every thing. What are the basic skills
then? Well, SAS base - that is that is the "real" SAS language. In fact,
you can do everything using SAS base. you do not have to use proc sql, you
do not have to use ods to produce the... 阅读全帖 |
|
p***r
发帖数: 920 | 40 check ods system in SAS |
|
z**********i
发帖数: 12276 | 41 Ods trace on; 看到table的名字 输出到data set. |
|
y*****n
发帖数: 5016 | 42 这玩儿到底产生出来什么东西。能给个very high level的表述不？ |
|
p********y
发帖数: 15 | 43 这回确定了，于刘两位经理是真有仇。刘经理躲着，于经理还要努力召唤刘经理出来挨
骂。 |
|
|
|
t******g
发帖数: 27 | 46 走好，不送 - 没人稀罕你那半吊子醋玩意，就一自恋狂。
临别赠言：欲练神功，必先自宫。挥刀自宫，未必成功。 |
|
|
|
l****u
发帖数: 529 | 49 google "ods tagsets"
难者不会，会者不难. 更要学会怎样有效，主动的学习 |
|
c******d
发帖数: 43 | 50 加上这句
ods path(prepend) work.templat(update);
想用COLORMODEL可以用COLORMODEL=yourcolorramp 加上 define style
class yourcolorramp /
endcolor=r
startcolor=g
neutralcolor=b;
; |
|
