Oh - that's still quite straight-forward. data code1 code2 code3 code4 code5; set master; select(event); when('xxxxx') do; code = 'code1'; output code1; end; when('yyyyy') do; code = 'code2'; output code2; end; when('zzzzz') do; code = 'code3'; output code3; end; when('aaaaa') do; code = 'code4'; output code4; end; when('bbbbb') do; code = 'code5'; output code5; end; otherwise; end; Since they're all distinct or mutually exclusive conditions, a select statement is the way to go. And you can write them all out in one pass of your source dataset. ... View more

I would have thought that replace should be that you would need. What error message do you get when you run the code where the file already exists?   If replace doesn't work in this case, maybe some hacking of my Excel backup delete macro might help?   ... View more

Here's how I would do it (note the correction of variable name pg to pagenum...)   data one; length var1 $8. pagenum 3.; input var1 pageNum; datalines; subjid 1 usubjid 2 aval 3 subjid 5 ; run; proc sort data=one; by var1 pagenum; run; data one_output; set one; by var1; attrib pagenums length=$ 20; retain pagenums first_pagenum; if first.var1 then do; first_pagenum = pagenum; call missing(pagenums); end; pagenums = catx(',', pagenums, strip(putn(pagenum, 'best.'))); if last.var1; keep var1 pagenums first_pagenum; run; proc sort data=one_output out=one_output(keep=var1 pagenums); by first_pagenum var1; run; I retained the lowest pagenum per var1 (as first_pagenum), so I could sort by that to retain the order in your output dataset.    Extend the length of the character variable pagenums if you have many more references. ... View more

SAS is very simply typed. It knows about character and numeric fields. The simple replacement for your first statement would be:     If '00:00:00.000't <= Time <= '06:00:00.000't then Time= 'Night';   But that won't do what you want. Note, for example that if the time is exactly 6am, your next statement will override it with Morning. But that isn't right either! Because you've already implicitly defined Time as being 5 characters long (Night), it'll be Morni. But that won't work either, because you've already defined Time as numeric. So you need a new variable.   Here's how I would recommend you re-write it. Data TimeofDay; set Airplane; length Timename $ 9; select; when('00:00:00't <= Time < '6:00:00't) Timename= 'Night'; when('06:00:00't <= Time < '12:00:00't) Timename= 'Morning'; when('12:00:00't <= Time < '18:00:00't) Timename= 'Afternoon'; otherwise Timename = 'Evening'; end; run; ... View more