i want to display all values in macro.its taking only 1st value   proc sql; select mem ,name into:ds,:var  from dictionary.columns where libname="RAW" and (name like '%AT' ') ; quit; proc sql; select count(name)into:N from demo; quit; %macro loop(N,ds,var);  %do i= 1 %to &N;   %put "&ds" -"&var";   %end; %mend; ... View more

data have; aestdtc="02mar2010"; aeendtc="03jul2010"; end; how to convert these dates like 02-03-2010 and 03-07-2010? thanks ... View more

data demo; length dt $9; dt='mar2010';output; dt='2007';output; dt='1feb2010';output; dt='';output; dt='32010';output; dt='142010';output; run; i have to separate month,date,year from above dataset,i tried year= SUBSTR(TRIM(dt),LENGTH(TRIM(dt))-3); month=SUBSTR(TRIM(dt),LENGTH(TRIM(dt))-6,3); to get year and month values but i m not getting date value with this logic. any other way to separate it? thanks   ... View more