Thanks Tom for your response. it is giving me "2412","erer","ghgh" for nonmissing values but if I have any missing value it is giving me "2431"," "," " if I have missing values. If I have missing values then I just want "2431". so that my data pull does not give me any blank cells when I use this in my where clause. Thanks, I have a dataset where I have different customers cust 1, cust 2, ...custn in each rows and then their corresponding ids as id1, id2, id3. Sometimes more than 1 id is missing but at least one id will be populated. I have 150 rows. I have to create a summary for each customer (if there id in id1,id2, and id3) for example - how many shirts they have bought. so if I have a variable for id then I can use that in a where clause as PROC SQL ; SELECT COUNT(*) INTO :NUMROWS FROM want; QUIT; PROC DELETE DATA=TOGETHER; %MACRO SHIRT; %DO I=1 %TO &NUMROWS; DATA CHECK;SET WANT; IF _N_=&I;RUN; PROC SQL; SELECT CUST AS CUST, ID AS ID INTO :CUST, :ID FROM CHECK; QUIT; PROC SQL; CREATE TABLE CLMS AS SELECT * FROM OTHERDATA WHERE A.ID IN ("&ID.") AND A.CUSTOMER IN ("&CUST.") QUIT; %END; Thanks,
... View more