首页 \ 问答 \ sas存储过程中的宏变量(Macro variable in sas stored process)

sas存储过程中的宏变量(Macro variable in sas stored process)

我有一个SAS代码。

proc sql;
create test as select * from test2 where user_name = &username;quit;

当我用%let username=Bob在SAS EG中运行时,它运行正常。 但我需要使用存储过程运行它(变量用户名是连接用户的内部参数,我从sas存储过程代码中删除%let username=Bob )。 存储过程制动器出错。

在日志文件中我看到变量:

_username=Bob但存储过程中的代码找不到它。 如何在SAS存储过程代码中使用这个变量? 谢谢!


I have a code in SAS.

proc sql;
create test as select * from test2 where user_name = &username;quit;

when I Run in SAS EG with %let username=Bob it runs normal. But I need to run it with stored Process (variable username is internal parameter in connected user and I delete %let username=Bob from sas stored process code). Stored Process brake with an error.

In log file I see variable:

_username=Bob but code in stored process can not find it. How to use this variable in SAS Stored process code? Thank you!


原文:https://stackoverflow.com/questions/34200750
更新时间:2023-04-12 16:04

最满意答案

iOS SDK不支持RTSP协议。
这是适用于iPhone的自定义RTMP库


The iOS SDK does not support the RTSP protocol.
This is custom RTMP Library for iPhone

相关问答

更多

相关文章

更多

最新问答

更多
  • 在开发React应用程序时编译/转换代码(Compile/transpile code while developing React app)
  • 将MultiPoint序列化为GeoJSON文件(Serialize MultiPoint to GeoJSON file)
  • 将字符串截断为特定数量的字符,忽略HTML(Truncate string to certain amount of characters, ignoring HTML)
  • Sqlserver监视时间的变化(Sqlserver watch for time change)
  • Srcset属性 - 最大宽度问题(Srcset attribute - max-width issue)
  • 如何验证数据库中是否存在记录?(How to verify existence of a record in database?)
  • SQL JOIN来自不同表的行具有相同的值(SQL JOIN row from different table with the same values)
  • NSTextField - 使用KVO进行输入验证?(NSTextField - Input validation with KVO?)
  • 在Javascript中,如何检查数组是否有重复值?(In Javascript, how do I check if an array has duplicate values? [duplicate])
  • 获取过滤器从spark数据帧中删除的行的示例(Get examples for rows that are removed by a filter from a spark dataframe)
  • 如果Shape在屏幕外,是否执行Graphics2D.draw?(Is Graphics2D.draw performed if the Shape is offscreen?)
  • 如果没有头文件,如何定义静态成员?(How to define a static member in case there is not header file?)
  • NSLocalizedStringFromTableInBundle:没有获取key的值(NSLocalizedStringFromTableInBundle : not getting values for key)
  • Google Cloud Messanger,“比预期的更多”(Google Cloud Messanger, “More acks than expected”)
  • HorizontalScrollView不起作用(HorizontalScrollView not working)
  • 关闭所有表单后退出应用程序(Quit Application when all forms is closed)
  • 玉林哪个会计培训学校有周末上课的!
  • java的。(java. Unique identifier for each visitor. How better generated?)
  • 希望大家告诉我学java编程的方法?
  • 在GAS嵌入式环境中通过Javascript刷新HTML文档(Refresh HTML Document via Javascript in a GAS Embedded Environment)
  • 当我在另一个类中调用它时,setText不起作用(setText does not work when I call it in another class)
  • 无法在静态字段中设置变量值(Can't Set variable value in Static Field)
  • IE9布局错误 - 在早期的IE版本中很好(IE9 Layout Bug - fine in earlier IE versions)
  • 按钮命令上的WPF新DataGrid行参数为NULL(WPF New DataGrid Row Parameter NULL on Button Command)
  • Wordpress上的CSS配置(CSS configuration on Wordpress )
  • 关于OpenGL设置的问题以及在窗口中绘制掩码的问题(Questions about OpenGL Settings and drawing over a mask in a window)
  • Matlab编码器fzero功能(Matlab coder fzero function)
  • Autodesk Maya,C ++和OpenGL渲染引擎(Autodesk Maya, C++ and OpenGL rendering engine)
  • 选择记录字段包含另一个字段的最大值(Select field of record contains max of another field)
  • 可选参数在Swashbuckle.AspNetCore中导致null异常(Optional parameter causes null exception in Swashbuckle.AspNetCore)