Hello,                 i have simple proc sql statement to create macro variable name custid. I use this custid macro variable in other sql shown below to create table cust_dtl. The problem arises when custid has 0 rows selected from cust_tbl which then gives error in sas log saying apparent symbolic reference not resolved. How do i replace value of custid with default value of 00 so it can be used in other proc sql without error.   proc sql noprint;             select distinct cust_id format 15. into :custid SEPARATED BY ','             from wk.cust_tbl             ;             quit;                                        %put &custid. ;   proc sql; create table cust_dtl as select name,dob from cust_det where cust_id in (&custid.); quit;   ... View more

i am importing multiple csv files from a folder using infile statement. Some files give me error Physical file not found. When i rename it , it works file.   Example of file name with issue- ab[bmp]c[8_4_203].csv when i remove square [] brackets it works fine.   Is there a way i can take care of all special characters when reading csv file using infile statement?   ... View more

Hi            i have a sample dataset where i need to apply logic to unique_id as per code it has in waterfall manner.   For instance if for unique ID 1,  Code A is found which gets Yes in preference then other instance of unique ID 1 will get "no" in Preference column for unique ID 2 Code B is found which gets Yes in preference then other instance of unique ID 2 will get "no" in Preference column for unique ID 3 Code E is found which gets Yes in preference  then other instance of unique ID 3 will get "no" in Preference column   so waterfall for Code follows the order as A,B,E,D,C. So A gets first prefernce if found for unique id,      B gets second and so on How can i apply this waterfall for unique id. So in nutshell if i find a code for unique id as per Waterfall it should get Yes in preference and rest all other instance of same unique id get No in preference.   UNIQUE_ID        CODE          Preference         1                    A                    Yes         1                    B                     no         2                    B                     Yes         2                    C                      no         3                    C                      no         3                    D                      no         3                    E                      Yes ... View more

i have simple code that works fine as long as :mact macro variable is not empty. But when macro variable :mact is null/blank it throws error. How do i fix this using if then else logic so it can see if macro is null and then execute?   proc sql noprint;    select distinct mac_id format 15. into :mact SEPARATED BY ','    from km.dmc_f    where king = 'No';   quit;   /* Execute when macro is not null */         proc sql;     create table km.mac_king as     select id.*,     case when id.macid in (&mact.) then 'Yes'     else '' end as Duplicated    from km.dmc_f id; quit;   /* Execute when macro is null */         proc sql;     create table km.mac_king as     select id.*,     '' as Duplicated    from km.dmc_f id; quit; ... View more

i am rewriting the question posted previously in new post.   i have following lookup table that as code and description. i have approximately 80 rows in lookup table.     Code Description 1 abc          1-this is for value a 2 bgcbs      2-contact customer 3 jfhfg         3-wait for response 4 shdg         4-should be ready 5 mi 5-made indoor 80 ni 6-not indoor    i have created Combined Codes column using array. i am trying to convert Combined Codes column like Combined description by applying format from above lookup table. Combined Codes are seperated by ' : ' .   Customer name abc_check bgcbs _check jfhfg_check         shdg_check         mi_check ni_check Combined Codes Combined Description a abc            jfhfg           mi   abc  : jfhfg : mi 1-this is for value a : 3-wait for response :  5-made indoor b       shdg           ni shdg : ni 4-should be ready :  6-not indoor c   bgcbs          mi   bgcbs : mi  2-contact customer : 5-made indoor d abc            jfhfg               abc  : jfhfg         1-this is for value a :   3-wait for response e   bgcbs        shdg         mi   bgcbs : shdg : mi  2-contact customer : 4- should be ready : 5-made indoor f       shdg           ni shdg : ni 4-should be ready :  6-not indoor     Thanks ... View more

i am rewriting the question. apologize for creating confusion   i have following lookup table that as code and description. i have approximately 80 rows in lookup table.     Code Description 1 abc          this is for value a 2 bgcbs       contact customer 3 jfhfg          wait for response 4 shdg         should be ready 5 mi made indoor 80 ni not indoor    i have created Combined Codes column using array. i am trying to convert Combined Codes column like Combined description by applying format from above lookup table. Combined Codes are seperated by ' : ' .   Customer name abc_check bgcbs _check jfhfg_check         shdg_check         mi_check ni_check Combined Codes Combined Description a abc            jfhfg           mi   abc  : jfhfg : mi this is for value a :   wait for response :  made indoor b       shdg           ni shdg : ni should be ready :  not indoor c   bgcbs          mi   bgcbs : mi  contact customer : made indoor d abc            jfhfg               abc  : jfhfg         this is for value a :   wait for response e   bgcbs        shdg         mi   bgcbs : shdg : mi  contact customer : should be ready : made indoor f       shdg           ni shdg : ni should be ready :  not indoor     Thanks ... View more