I defined a format using proc format, and then try to use it in proc sql, but an error message keeps coming out and I don't know what I did wrong. Hope someone can help me with it, thanks a lot!
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, put(Score,$range.) as range 38 from 39 project.student;
40 quit;
The message is like: error: character format $range in PUT function requires a character argument.
... View more