Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[bug] %desc_coun 分类名称长度超出 200 时结果被截断 #13

Closed
Snoopy1866 opened this issue Feb 23, 2024 · 1 comment
Closed

[bug] %desc_coun 分类名称长度超出 200 时结果被截断 #13

Snoopy1866 opened this issue Feb 23, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@Snoopy1866
Copy link
Owner

原因：程序内部使用 PROC SQL 生成数据集，在 PROC SQL 中，使用了 CAT 函数家族进行字符串的连接。在 PROC SQL 中，CAT 函数返回值始终为 200（即便事先指定了变量的 length = 32767），导致 sql 表达式的结果被截断。

image

解决办法：改用字符串连接符 ||，并配合 left, trim, strip 去除前后空格。
@Snoopy1866 Snoopy1866 added the bug Something isn't working label Feb 23, 2024
@Snoopy1866 Snoopy1866 changed the title [bug] %desc_coun 分类名称超出 200 时结果被截断 [bug] %desc_coun 分类名称长度超出 200 时结果被截断 Feb 23, 2024
@Snoopy1866
Copy link
Owner Author

537306a

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Snoopy1866