@anirudhs wrote:
yes i want new work book for each city.
but the code and condition is to be written 126 times... is that fisible ????
to write the proc export code 126 times by just changing the city name in each occurrence of export code
No one suggested you do that. We asked what you were trying to do, so we can provide a better response.
You can make the code be generated automatically, see @Toms answer. A macro would work but it's more code.
1. First get a list of all citys
2. Write a macro to export
3. Call macro for each city using call execute.
Untested below:
proc sql;
create table distinct_city as
select distinct city from have;
quit;
%macro export_sheet(city=);
proc export data=&have (where=(city="&city"))
outfile="C:\_localdata\&City..xlsx" dbms=xlsx replace; run;
%mend;
data _null_;
set distinct_city;
str = catt('%export_sheet(city=', city, ');');
call execute (str);
run;
Personally, I'd use Tom's solution instead.
