楼主: bobguy
1698 2

[学习分享] WHICHN function syntax, usuage, example. (Also see WHICHC function) [推广有奖]

学科带头人

7%

还不是VIP/贵宾

-

威望
0
论坛币
14187 个
通用积分
28.9279
学术水平
344 点
热心指数
363 点
信用等级
228 点
经验
104882 点
帖子
1846
精华
0
在线时间
1608 小时
注册时间
2008-7-18
最后登录
2019-3-8

中级热心勋章

楼主
bobguy 发表于 2012-12-22 21:35:55 |AI写论文

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币
Syntax WHICHN(argument, value-1 <, value-2, …> )

Required Arguments argument is a numeric constant, variable, or expression that specifies the value to search for.
value is a numeric constant, variable, or expression that specifies the value to be searched.



Details The WHICHN function searches the second and subsequent arguments for a value that is equal to the first argument, and returns the index of the first matching value.
If string is missing, then WHICHN returns a missing value. Otherwise, WHICHN compares the value of string with value-1, value-2, and so on, in sequence. If argument value-i equals string, then WHICHN returns the positive integer i. If string does not equal any subsequent argument, then WHICHN returns 0.
Using WHICHN is useful when the values that are being searched are subject to frequent change. If you need to perform many searches without changing the values that are being searched, using the HASH object is much more efficient.


Example The following example searches the array for the first argument and returns the index of the first matching value.

data _null_;
   array dates(*) Columbus Hastings Nicea US_Independence missing
                  Magna_Carta Gutenberg
                  (1492 1066 325 1776 . 1215 1450);
   x0=whichn(., of dates(*));
   x1=whichn(1492, of dates(*));
   x2=whichn(1066, of dates(*));
   x3=whichn(1450, of dates(*));
   x4=whichn(1000, of dates(*));
   put x0= / x1= / x2= / x3= / x4=;
run;
SAS writes the following output to the log:
x0=.
x1=1
x2=2
x3=7
x4=0
二维码

扫码加我 拉你入群

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

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

关键词:function example SYNTAX Which ExamP first expression subsequent function

沙发
zhentao 发表于 2012-12-23 16:55:11
谢谢,学习了。

藤椅
南海游客 发表于 2012-12-23 16:58:06
支持 留个水印

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群
GMT+8, 2025-12-31 02:41