topic Re: branch wise excel file using macro in ODS and Base Reporting

branch wise excel file using macro

TarunKumar — Fri, 07 Jun 2013 05:03:19 GMT

I have huge data of mulitiple location, I want to create branch code wise data set with same name as branch code and excel file using marco.Below attcahed is sample data.

Branch_code	cust_name	Revenue
100	a	25000
100	s	35000
100	d	45000
200	f	6000
200	f	5000
100	b	6000
300	a	6000
200	d	5000
200	f	6000
300	g	6000

Re: branch wise excel file using macro

manojinpec — Fri, 07 Jun 2013 10:07:18 GMT

%macro abc;

data test;

branch_code=100;

cust_name='a';

revenue=25000;

output;

branch_code=200;

cust_name='b';

revenue=2500;

output;

branch_code=200;

cust_name='c';

revenue=25000;

output;

branch_code=300;

cust_name='d';

revenue=5000;

output;

run;

proc sql;

select count(distinct(branch_code)) into :n from test;quit;

%let n= %trim(&n);

proc sql;

select distinct(branch_code) into :branch_code1-:branch_code&n from test;

quit;

%do i=1 %to &n;

data branch_&&branch_code&i. ;

set test;

if branch_code="&&branch_code&i." ;

run;

%end;

%mend;

%abc

Since dataset name cannot start with number i have prefixed with brnach

Re: branch wise excel file using macro

TarunKumar — Fri, 07 Jun 2013 11:23:28 GMT

Thanx Manoj

it worked perfectly. request you t pls explain the same code

Re: branch wise excel file using macro

manojinpec — Fri, 07 Jun 2013 11:30:33 GMT

I see you are in gurgaon. You can reach me @9560771148 and i would be happy to explain further.

I have created a macro variable abc which uses the dataset test having the information of brnach_code etc.

Now i have created a macro variable n which contains total number of distinct brnach code.

Now the do loop runs the code for n number of times for each brnanch code.

Re: branch wise excel file using macro

BrahmanandaRao — Sat, 13 Mar 2021 05:56:33 GMT

Hi manoj
how to send email for branch wise managers using proc report procedure

Re: branch wise excel file using macro

Kurt_Bremser — Sat, 13 Mar 2021 09:22:14 GMT

@BrahmanandaRao wrote:
Hi manoj
how to send email for branch wise managers using proc report procedure

You posted your question as a reply to a thread that is 7+ years old, and you addressed a member who has not visited the communities for 3+ years.

Please post your question in a new thread, supply usable example data, and include your proc report code and the code you use to send one email to one manager. From there we can assist in sending multiple mails.

Re: branch wise excel file using macro

BrahmanandaRao — Sat, 13 Mar 2021 10:58:43 GMT

Please give solution if any documentation for email reporting after prepare proc report