SemanticException[错误10004]无效的表别名或列引用

Question

我试着按ID在每组中的第一行记录。行号按ID的顺序生成。我一直得到同样的错误[10004]。

此配置单元脚本是在SAS studio环境中构建的，下面是proc sql代码的一段：

execute (create temporary table event_id_f1 as
        select *,ROW_NUMBER() OVER(ORDER BY id) as rownum
        from id_f
                        group by id
                        having rownum = min(rownum)
        )
by df20;

execute (create temporary table event_id_f1 as

        from (
             select *,
             ROW_NUMBER() OVER(ORDER BY id) as rownum
             from id_f
              group by id
              having rownum = min(rownum) ) ranked
             WHERE ranked=1
             )
by df20;

Answer 1

我会这么写的。如果有任何错误请告诉我：

execute (create temporary table event_id_f1 as
    select * 
    from (
        select id, ROW_NUMBER() OVER (ORDER BY id) as rownum
        from id_f
        group by id 
    ) ranked
    where ranked.rownum = 1         
) by df20;