Thank you Tom for the response and sorry for not being able to explain you clearly. What Patrick has shown is what I am trying to achieve. Basically, I want both the table columns side by side but the data should display first from table 1 and then from table 2. ... View more

Thank you for the quick response. I wanted something like this, only difference is I don't have a fixed count of observations as it is dependent on number of rows for table 1 and 2.  ... View more

Thank you. I tried proc sql but the update command under proc sql is not recognized.( The update text does not turn blue like the select text ) ... View more

Thank you for your response but all the values are bringing the same value for isblank(type). If type is 1 ,2 or . the isblank is bringing 0 for it. So I cant use this for checking non null values. It is storing the null with a . and thats causing all the confusion. ... View more

I checked the length and it is bringing 1 for all three value , 1 , 2 and . ... View more

Hi I tried your version %macro dummy; %DO COUNTER = 1 %TO 3; DATA Temp; SET CTRL; IF ObsNo = &COUNTER; call symputx ('sex',sex); call symputx ('labels',compress(labels)); RUN; %put &sex.; proc sql; select * from sashelp.class where age = 14 %if %length(&sex.) > 0 %then AND name = 'Henry'; ; quit; %end; %mend; %dummy; I uploaded the excel in the ctrl sas table and then I am using the sex & label columns to pass it as a variable in the sql. Sex has value 1 in the first row , 2 in the second and blank in the third. I was expecting the third row to bring all results since it is not greater than 0 but it brings only Henry as its output. ... View more

Thank you, I appreciate your response and I realize i should have provided more details. I have added the required code snippet, like you noted there is an error in the part where i am checking for null condition but what is it? ... View more

Thank you, I think I understand it now. The program is pretty long but I will try to give you full details.   proc format; value type1 = 'Female' 2 = 'Male' ; run;   Here is my program, it is using an excel which has value 1 in the Type Field and min age is also populated with value like >20   macro master; %put &type.;   It prints 1 for me select age, type, name, orderdate, code from  table P where  code in ('5435','4234',786')  and   %if &type. > ' ' %then AND p.type_c = &type; %if &minage. > ' ' %then AND TRUNC(months_between(orderdate, BIRTH_DATE) / 12) &minage.; and line =1 ); quit; %mend master;   However this code errors out when there is no value in the type field ..in the error message it prints missing expression and it prints p.type_c = .   Like you both mentioned the  >'  ' is not working as expected. Type only has value 1 or 2 or blank ... View more