全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 SAS专版
9597 4
2011-01-03
如题,下面是帮助文档里面的文件,以前不怎么看帮助文档,不过最近在里面找了一下,发现很全很强大,就是看起来觉得很不适应,估计是英文水平比较菜。请高手们帮忙看看,总结一下这两个函数的差别,谢谢了。
好的英语水平真的很重要啊!

%UPCASE and %QUPCASE Functions
Convert values to uppercase.
Type:Macro function
See also:
%LOWCASE and %QLOWCASE Autocall Macros
%NRBQUOTE Function
%QLOWCASE Autocall Macro
Syntax
Details
Comparison
Examples
Example 1: Capitalizing a Value to be Compared
Example 2: Comparing %UPCASE and %QUPCASE
Syntax
%UPCASE (character string | text expression)
%QUPCASE(character string | text expression)



Details

The %UPCASE and %QUPCASE functions convert lowercase characters in the argument to uppercase. %UPCASE does not mask special characters or mnemonic operators in its result, even when the argument was previously masked by a macro quoting function.
If the argument contains a special character or mnemonic operator, listed below, use %QUPCASE. %QUPCASE masks the following special characters and mnemonic operators in its result:
& % ' " ( ) + - * / < > = ? ^ ~ ; , # blankAND OR NOT EQ NE LE LT GE GT IN
%UPCASE and %QUPCASE are useful in the comparison of values because the macro facility does not automatically convert lowercase characters to uppercase before comparing values.
Comparison


  • %QUPCASE masks the same characters as the %NRBQUOTE function.
  • To convert characters to lowercase, use the %LOWCASE or %QLOWCASE autocall macro.
Examples


Example 1: Capitalizing a Value to be Compared In this example, the macro RUNREPT compares a value input for the macro variable MONTH to the string DEC. If the uppercase value of the response is DEC, then PROC FSVIEW runs on the data set REPORTS.ENDYEAR. Otherwise, PROC FSVIEW runs on the data set with the name of the month in the REPORTS data library.
%macro runrept(month);   %if %upcase(&month)=DEC %then       %str(proc fsview data=reports.endyear; run;);   %else %str(proc fsview data=reports.&month; run;);%mend runrept;
You can invoke the macro in any of these ways to satisfy the %IF condition:
%runrept(DEC)%runrept(Dec)%runrept(dec)

Example 2: Comparing %UPCASE and %QUPCASE These statements show the results produced by %UPCASE and %QUPCASE:
%let a=begin;%let b=%nrstr(&a);%put UPCASE produces: %upcase(&b);%put QUPCASE produces: %qupcase(&b);
When these statements execute, the following is written to the SAS log:
UPCASE produces: beginQUPCASE produces: &A
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

全部回复
2011-1-4 07:31:04
假设有一字符串,以逗号分隔。
%let string=aaa,bbb,ccc;

如果想检测其第二个词的大写形式是不是BBB:
因为函数中也需要用逗号分隔各个参数,为了让SAS将字符串aaa,bbb,ccc中的两个逗号看作普通字符,而不是参数分隔符,就需要将该字符串中的逗号的参数分隔功能屏蔽掉,这时会需要用到%QUPCASE:
%let second=%scan(%qupcase(&string),2,%str(,));
%put %sysfunc(ifc(&second eq BBB, The second word is BBB., The second word is not BBB.));

这里%qupcase()相当于 %quote(%upcase())
%let second=%scan(%quote(%upcase(&string)),2,%str(,));
%put %sysfunc(ifc(&second eq BBB, The second word is BBB., The second word is not BBB.));
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2013-4-23 22:33:23
二楼举得例子不错。
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2015-8-19 03:55:39
多谢楼主分享!!!
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2015-8-19 09:03:29
第二个例子是说,能屏蔽& AND %
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群