Hi, I think it quite eassy by using %DO Loop within proc sql...But i am able to understand the Select caluse in your Proc Sql...However, if you want perform repeated action on so many variables in SAS than use %DO Loop within Macro Definition... %macro test;         proc sql feedback;                create table outfile as                select                         %do i = 1 %to 20;                                sum((cstatus_&i. = 0)*VarF) format=comma25. as A_&i.,                                sum((cstatus_&i. = 0)*VarN) format=comma25. as B_&i.,                                sum((cstatus_&i. = 0)*m_&i.) format=comma25. as C_&i.,                                sum(calculated C_&i. *VarN) as D_&i.,                                sum(status_&i. = 1) as E_&i.,                                sum((status_&i. = 1)*VarN) as F_&i.                         %end;                from infile;          quit; %mend; %test; Hope it works.... Thanks, Urvish ... View more

Hi, In your SAS Code, if you bother about selecting DATA or VIEW, then take it in a Macro Variable and note that these values are always in upparcase... See the modified code as foolow... %macro t (dataset=, varname=, type =); %if %INDEX(&dataset,.) eq 0 %then %do; %let libname = WORK ; %let setname = &dataset ; %end; %else %do; %let libname = %SUBSTR(&dataset,1,%INDEX(&dataset,.)-1); %let setname = %SUBSTR(&dataset,%INDEX(&dataset,.)+1) ; %end; proc sql noprint; select type into :vartype from sashelp.vcolumn where libname = %upcase("&libname") and memname = %upcase("&setname") and memtype = %upcase("&type.") and upcase(name) = %upcase("&varname") ; quit; %mend; %t(dataset=sashelp.class, varname=age, type =data); Thanks, Urvish ... View more

I think it very simple... proc sql;      select a.id,a.port,             b.inst      from t as a,           b as b      where a.id EQ b.id; quit; ... View more

Hello, Try by using ARRAY statement... data test;       retain bank year assets libilities;       array asset (3) assets1 assets2 assets3;       array lib (3) liabilities1 liabilities2 liabilities3;       do i = 1 to 3;           assets = asset(i);           liabilities = lib(i);           _temp = vname(asset(i));           year = input(substr(_temp,7),4.);           output;       end; run; Thanks, Urvish ... View more

Hi, Try the following SAS Code as per your requirement...Wish it matches with what you want... You wrote, you want to perform multiple action for each unique value of particular variable say color... %macro loop;            proc sql;                   select distinct color into color_loop separated by ' '                   from b.cards;                   select count (distinct color) as tot_distinct_color                   from b.cards;            quit;             %do i = 1 %to &tot_distinct_color.;                                      PROC PLOT DATA=B.CARS;                            WHERE COLOR="%scan(&color_loop.,&i.)";                            TITLE ="%scan(&color_loop.,&i.). CARS";                            VBAR YEAR / RESPONSE=PRICE;                    RUN;                   PROC TABULATE DATA=B.CARS;                             WHERE COLOR="%scan(&color_loop.,&i.)";                                           CLASS YEAR;                             VAR PRICE;                             TABLE PRICE / HOUR;                   RUN;          %end; %mend loop; %loop; Hope it works... Thanks, Urvish ... View more