由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Statistics版 - 寻找相对应sql over partition by的sas code
相关主题
[合集] 面试的一个case study,求帮助~再求个 sas 的 quick answer
How to predict patient's hospital admission next year?能不能帮忙查个老文献?
请问一个有关procedure的问题请推荐simple and good reading material for recursive partitioning
interview questions for health care insurance company?了解RPA的同学来指点我一下
HealthCare Economics Consultant position At UHG统计学的新地平线——陈立功与他的自权重曲线
请教一个住院死亡率比较的问题Partition 3 x 2 Contigency Table - Logical Analysis
新手问:如何STEP BY STEP 地运行SAS MACROSQL求教:如何求出各组Top N的记录?
What is R equivalent to SAS format?Lasso (question on tuning parameter and final model)
相关话题的讨论汇总
话题: sql话题: partition话题: sas话题: process话题: complete
进入Statistics版参与讨论
1 (共1页)
x*******i
发帖数: 1237
1
一直用sas sql,不太懂sql,这个partition by in sql code有点像sas group by?
有没有相对应的sas function? 谢谢谢谢
SELECT
MAX
(CASE WHEN ifm.flo_meas_id = '222301'
THEN DECODE(ifm.meas_value,
'In Process', '1 - In Process',
'Complete', '2 - Complete',
'Discontinued', '3 - Discontinued',
'Not Applicable', '4 - Not Applicable'
)
END) OVER (PARTITION BY pat_enc.inpatient_data_id ORDER BY ifm.recorded
_time desc)
AS Intake_Status
From .....;
Group by.......;
1 (共1页)
进入Statistics版参与讨论
相关主题
Lasso (question on tuning parameter and final model)HealthCare Economics Consultant position At UHG
regression discontinuity design请教一个住院死亡率比较的问题
这两个工作机会哪个更有发展?新手问:如何STEP BY STEP 地运行SAS MACRO
SQL相关的Interview问题请教What is R equivalent to SAS format?
[合集] 面试的一个case study,求帮助~再求个 sas 的 quick answer
How to predict patient's hospital admission next year?能不能帮忙查个老文献?
请问一个有关procedure的问题请推荐simple and good reading material for recursive partitioning
interview questions for health care insurance company?了解RPA的同学来指点我一下
相关话题的讨论汇总
话题: sql话题: partition话题: sas话题: process话题: complete