topic Re: sent report Location wise sales report using proc report in SAS Programming

sent report Location wise sales report using proc report

BrahmanandaRao — Thu, 25 Feb 2021 09:04:41 GMT

Hi Guys,

Suppose I have below location sales reports so I want sent sales report by respective location using proc report procedure

Area_Location:

Re: sent report Location wise sales report using proc report

Kurt_Bremser — Thu, 25 Feb 2021 08:23:31 GMT

Please post usable example data and the code you tried so far.

Re: sent report Location wise sales report using proc report

andreas_lds — Thu, 25 Feb 2021 09:52:41 GMT

What do you mean by "sent"?

Re: sent report Location wise sales report using proc report

Cynthia_sas — Thu, 25 Feb 2021 16:34:01 GMT

Hi:
I'm not sure what you've posted. This seems to be a CSV data file? You call this a location sales report? Is there some column in the data the identifies whether something was "sent"?? You have not provided any logic or examples of code you've tried to generate the "sent" report. Typically, before you could use PROC REPORT with this data, you'd have to import the CSV file into SAS. There are 2 ways to do this: PROC IMPORT or a DATA step program. Have you written the code yet to import this data file into SAS format?
Once you do that, you'll then need to understand how the "sent" report is derived from the "location" report. We don't know that logic from just looking at the data and without more direction about the logic or seeing your import code. There's a lot you can do with PROC REPORT, but without some examples of what you mean, it is hard to do more than ask for more information.
Cynthia

Re: sent report Location wise sales report using proc report

BrahmanandaRao — Fri, 26 Feb 2021 07:20:20 GMT

My question is how to sent mails report respective location wise using proc report procedure

Re: sent report Location wise sales report using proc report

andreas_lds — Fri, 26 Feb 2021 07:53:36 GMT

@BrahmanandaRao wrote:
My question is how to sent mails report respective location wise using proc report procedure

So, do you have code sending one mail? If not start with that task, the documentation of the filename-statement tells you all you need to know to send a mail. For the larger task, you need a variable in the data identifying the location.

Re: sent report Location wise sales report using proc report

Kurt_Bremser — Fri, 26 Feb 2021 08:30:00 GMT

Concur with @andreas_lds

Please post the code for a single report sent in a single mail.

Also include the code you use to read that csv into SAS.

Re: sent report Location wise sales report using proc report

BrahmanandaRao — Fri, 26 Feb 2021 10:46:45 GMT

data sales; 
length zip $ 5 cty $ 8 var $ 10;
input zip $ cty $ var $ sales; 
label zip="Zip Code"
cty="County" 
var="Variety" 
 sales="Monthly Sales"; 
 datalines; 

52423 Scott Merlot 186. 
 52423 Scott Chardonnay 156.61 
52423 Scott Zinfandel 35.5 
 52423 Scott Merlot 55.3 
 52388 Scott Merlot 122.89 
 52388 Scott Chardonnay 78.22 
 52388 Scott Zinfandel 15.4 
52200 Adams Merlot 385.51 
 52200 Adams Chardonnay 246 
 52200 Adams Zinfandel 151.1 
 52200 Adams Chardonnay 76.24
 52199 Adams Merlot 233.03
 52199 Adams Chardonnay 185.22
 52199 Adams Zinfandel 95.84
 ;
run;


proc report data=sales headline headskip;
	title 'Grouped Report';
	column cty zip var sales;
	define cty	/group width =6 'Country/Name';
	define zip /group ;
	define var/group order=freq descending ;
	define sales/analysis sum format=6.2 width=10  ;
	run;

Please give solution for this report  procedure how to send email respective cites

Re: sent report Location wise sales report using proc report

Kurt_Bremser — Fri, 26 Feb 2021 11:05:10 GMT

Where are the email addresses stored, and how do you send a single mail?

Re: sent report Location wise sales report using proc report

BrahmanandaRao — Fri, 26 Feb 2021 11:18:33 GMT

Please give syñtax using this report
How to send to adam and scott

Re: sent report Location wise sales report using proc report

Kurt_Bremser — Fri, 26 Feb 2021 11:20:07 GMT

"adam" and "scott" are positively NOT valid email addresses, so this is not possible.

Re: sent report Location wise sales report using proc report

Cynthia_sas — Fri, 26 Feb 2021 16:41:41 GMT

Hi:
To help you out, example 2 starting on page 7 in this paper https://support.sas.com/resources/papers/proceedings11/300-2011.pdf shows how to send a report as an attachment to an email. The paper shows using PROC PRINT with ODS RTF to create a file that is attached to an email. However, any SAS procedure that produces results could be inserted where the paper shows PROC PRINT -- so PROC REPORT or PROC FREQ or PROC GLM would work because they produce results. PROC SORT would not work because SORT does not produce report results.
In the paper, the email addresses are hard-coded. To send mail "automatically", you need to have a dataset of the names/emails to use. And you would likely need more advanced DATA step and SAS Macro techniques in order to send individual mails to individual people.
Note that your SAS Administrator may need to set system options related to email in order for this to work with your system's email application.
Cynthia