sas中一些小的选项的含义

最新推荐文章于 2025-04-01 11:20:54 发布

weixin_34235457

最新推荐文章于 2025-04-01 11:20:54 发布

阅读量145

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/yican/p/3885369.html

本文深入探讨了SAS数据处理中如何设置文件行长度和处理数据溢出，详细解释了DROPOVER选项的作用及与MISSOVER、TRUNCOVER的区别，并通过实例展示了如何利用这些功能进行高效的数据读取和输出。

确定文件中一行的长度。

LRECL= specifies the physical line length of the file. LINESIZE= tells the INPUT statement how much of the line to read.

DropOver以及不用此选项的默认执行的具体过程

By default, data that exceeds the current line length is written on a new line. When you specify DROPOVER, SAS drops (or ignores) an entire item when there is not enough space in the current line to write it. When an entire item is dropped, the column pointer remains positioned after the last value that is written in the current line. Thus, the PUT statement might write other items in the current output line if they fit in the space that remains or if the column pointer is repositioned.

9:Missover和TruncOver的区别

You need the TRUNCOVER option when you are reading data using column or formatted input and some data lines are shorter than others

missover和truncover的区别，对于一行结束时有缺省，如果是按列方式读取，(就是规定了列的数量)missover会把最后一个变量也置为缺失，而truncover会把缺失部分截除掉。

图上面的数据集是truncover的结果