To calculate the number of times each light has been switched on, you can do something like this: data want;   n_switch_on=0;   do until(last.light_no);     set have;     by Light_no on_off_status notsorted;     n_switch_on+first.on_off_status and on_off_status='ON';   end;   keep light_no n_switch_on; run;   Unless, of course, you do not want to count if the light is on in the first hour, then the last line in the loop should be     n_switch_on+first.on_off_status and not first.light_no and on_off_status='ON'; ... View more

The result of CAT, and many other string functions, is 200 unless you define the variable first. But even with a defined length you would likely have the comparison for some values with the trailing blanks. So it is a good idea to STRIP values. Though you need other approaches if you want leading blanks compared... ... View more

Jagadishkatam is definitely pointing you in the right direction! To give a more complete answer, it would be useful to see your SAS code. The code to control where the output is written will vary, depending on a lot of things. Also, how you're scheduling the job to run on a SAS server (via EG, a stored process, a Unix cron job, a Windows scheduled task, etc) ... and are you using the SAS job to send the email & attachment, or is that a Unix/DOS script, etc? I would suggest doing it all in the SAS job, as Jagadishkatam has shown. Here is a SAS job similar to his, that shows how to include multi-line text in the email: http://robslink.com/SAS/democd38/iPhone_mailer.sas And, if you've got SAS 9.4, there's even a new/enhanced way to send graphs! You can use html5 to create a single html file that contains both the graph and the html overlay (with html mouse-over text, drilldowns, etc). Assuming you've got SAS 9.4, and your email recipients are using a browser that supports html5. Here's a blog post with more details: http://blogs.sas.com/content/sastraining/2013/11/06/sas-9-4-has-a-new-way-to-send-interactive-graphs-in-email/ ... View more

It generates different macro variables based on the number of choices a user makes. My understanding is that you should have MONTH and MOUNT_COUNT.  If the count is greater than one then you will also have MOUNT1, MONTH2, etc. It does not look to me like you are using the right macro variable names, but anyway you should probably add: %let month1 = &month ; To you program so that MONTH1 will be sure to have a value with COUNT=1. %let month1 = &month ; %do i=1 %to &month_count;    %if "&&month&i" = "Jan" %then %do; ..... .... %end; ... View more

Use If and else if instead of else and where ... View more

This works for me. Thank you. ... View more

Hi:   In addition to the other suggestions, instead of doing an EXPORT, using PROC EXPORT or the LIBNAME engine, you could use PROC REPORT and ODS (ODS CSVALL or ODS CSV). In the code below, I show ODS CSVALL (which would also put a SAS title into the output file).; cynthia data testdata;   infile datalines dlm=',';   input item $ price : comma.; return; datalines; AB,$50 CD,$40 ; run; title; ods listing close; ods csvall file='c:\temp\something.csv';   proc report data=testdata nowd;     column ('purchaselist' item price);     format price dollar3.;   run; ods csvall close; ... View more