See below code which works using hard coded values: data DQA.BASE_DATA3; set DQA.BASE_DATA2; DQA_ISSUES = DQA_ISSUES; length word $27 ; IF DQA_RA_BACKLOG = 'N' THEN do word = 'RAE001,', 'RAE002,', 'RAE003,', 'RAE007,', 'RAE011,', 'RAE012,', 'RAE013,', 'RAE014,', 'RAE015,', 'RAE016,', 'RAE017,', 'RAE021,', 'RAE022,', 'RAE024,', 'RAE030,', 'RAE031,', 'RAE033,', 'RAE035,', 'RAE037,', 'RAE038,', 'RAE040,', 'RAE044,', 'RAE045,', 'RAE046,', 'RAE047,', 'RAE048,', 'RAE049,'; DQA_ISSUES = tranwrd(' '||DQA_ISSUES, ' '||strip(word)||' ', ' '); end; DQA_ISSUES = compbl(DQA_ISSUES); drop word ; run;
... View more
