求大神帮忙看下这段sas问题到底出在哪里一直返回error，感激不尽

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

先define了一个format，然后在sql中一直返回error说character format $range in PUT function requires a character argument.
求问问题在哪，应该怎么修改呢，感恩！

format:
17   proc format library=Project;
18   value $ range
19   810-high = '810+'
20   790-809 = '790-809'
21   770-789 = '770-789'
22   750-769 = '750-769'
23   730-749 = '730-749'
24   710-729 = '710-729'
25   690-709 = '690-709'
26   670-689 = '670-689'
27   650-669 = '650-669'
28   630-649 = '630-649'
29   low-629 = '<630'
30   other = 'Null or Zero';
31   run;



32   OPTIONS FMTSEARCH=(Project);
33   run;
34
35   proc sql;
36   create table project.n1 as
37   select score,
42   put(Score,$range.) as range
43   from
44   project.student
error: character format $range in PUT function requires a character argument.put不是num转char的function吗, 哪里需要character argument呢？还是我定义的format有问题，求解。

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Error SAS问题 感激不尽 err Character character function library error

变量score是字符型的吧  加"" 就应该可以了
   proc format library=Project;
   value $ range
  “810-high” = '810+'
   “790-809” = '790-809'
   “770-789” = '770-789'
   “750-769” = '750-769'
   “730-749” = '730-749'
   “710-729” = '710-729'
  “690-709” = '690-709'
  “670-689” = '670-689'
   “650-669” = '650-669'
  “630-649” = '630-649'
  “low-629” = '<630'
  “other” = 'Null or Zero';
run;