Hi everyone, %let alparle = NCEPA7,NCEPA8; (note: ncepa7 and ncepa8 are names of variables in work.datahave) proc sql; create table levo as select ALT, scan("&alparle." ,1, ",") from work.datahave ; quit; i want to call only NCEPA7 as variable to my table but the scan function output is "ncepa7" for this reason, my tablo look like as : ALT _TEMA001 ANC NCEPA7 NON_MARK NCEPA7 MARK_SPEC NCEPA7 ANC NCEPA7 But i want to get the table as : ALT NCEPA7 ANC 5 NON_MARK 7 MARK_SPEC 15 ANC 1 so which function should i use or how can i eliminate the quotation marks? thank you in advance Best Regards.
... View more