Hi All,   I have  a table which contains  values of "if then else conditions" in a variable. how can loop them in a data step. currently we are copying all rows from that column into a data step like below data have; SET test (WHERE=(TIMESTAMP BETWEEN &START. AND &END.)); /* row1 */ IF ( domain GE 21.00000 ) THEN name = '03. >= 21.00000'; /* row2 */ IF ( SYSTEM EQ -999999 ) THEN op = '01. Especial Value = -999999'; ELSE /* row3 */ IF ( SYSTEM LT 17.00000 ) THEN op = '02. < 17.00000'; ELSE /* row4 */ IF ( SYSTEM GE 17.00000 AND SYSTEM LT 20.00000 ) THEN op = '03. >= 17.00000 and < 20.00000'; ELSE /* row5 */ IF ( SYSTEM GE 20.00000 ) THEN op = '04. >= 20.00000'; /* row6 */ IF ( region LT 2.00000 ) THEN LN = '01. < 2.00000'; ELSE /* row7 */ IF ( region GE 2.00000 AND region LT 10.00000 ) THEN LN = '02. >= 2.00000 and < 10.00000'; ELSE /* row8 */ IF ( region GE 10.00000 AND region LT 11.00000 ) THEN LN = '03. >= 10.00000 and < 11.00000'; ELSE /* row9 */ IF ( region GE 11.00000 ) THEN LN = '04. >= 11.00000'; /* row10 */ IF ( status LT 2.00000 ) THEN cn = '01. < 2.00000'; ELSE /* row11 */ IF ( status GE 2.00000 AND status LT 4.00000 ) THEN cn = '02. >= 2.00000 and < 4.00000'; ELSE /* row12 */ IF ( status GE 4.00000 AND status LT 7.00000 ) THEN cn = '03. >= 4.00000 and < 7.00000'; ELSE /* row13 */ IF ( status GE 7.00000 ) THEN cn = '04. >= 7.00000'; run; I am looking like below macro that loops all rows. data have; SET test (WHERE=(TIMESTAMP BETWEEN &START. AND &END.)); <&rows>; run;   Thanks, Sathya. ... View more

Hi All,   I know only the column name(PART_NUMBER)  but not the table name. I have searched for the column name in SAS DI and I found it . when I try to see the properties but it is not let me see it. How can I find the table name based on column in SAS DI/SAS SMC.      ... View more

Hi Al, I am able to get the datatime in the ddmmyyhhmmss  format  but 0 is missing at start  output :-3102023100202 but looking for :- 03102023100202   %let now=%sysfunc(datetime()); %let date_time = %sysfunc(inputn(%sysfunc(putn(%sysfunc(datepart(&now)),DDMMYYN8.)),8.))%sysfunc(timepart(&now),B8601TM6); %put &date_time.; Thanks, SS ... View more

I am trying to get the output if  if conditions are met then output something or print table but Conditions doesn't work. Even below condition is true or not true it always giving true output. Tried with different true or false conditions but it prints always true condition which is not right. Am I missing some logic. See the attached file for data. proc import datafile="/test/test.xls " out=test dbms=xls replace; run; proc sql noprint; select Despatches into :COL from test where inflight_type = 'Collect' ; quit; proc sql noprint; select a2_Sales into :COL2 from test where inflight_type = 'Collect' ; quit; proc sql noprint; select Despatches into :POST from test where inflight_type = 'Post'; quit; proc sql noprint; select a2_Sales into :POST2 from test where inflight_type = 'Post' ; quit; proc sql noprint; select Despatches into :DEPOT from test where inflight_type = 'Depot'; quit; proc sql noprint; select a2_Sales into :DEPOT2 from test where inflight_type = 'Depot' ; quit; %put &COL &COL2 &POST &POST2 &DEPOT &DEPOT2; %macro test; %if (&COL>1000 or &COL2>5 or &POST>0 or &POST2>0 or &depot>1000 or &depot2>1 ) %then %do; %put "doesn't exist"; %end; %else %do; proc print data=sashelp.class; run; %end; %mend; %test;    ... View more