I want to create a dummy row using proc SQL.   In the below example we can get male and female count.   And for that GENDER we usually create a dummy data set and set back. So is it possible do the same using proc SQL.   For Example :   Gender           Male        2           Female    3 ... View more

Hi All,   I am currently working on a project for that I have to transfer the data from one folder to another in this process I have to achieve the golas mentioned below.   1. Transfering files (Goal Reached) 2. Zip all the data and transfer (Not reached) 3. Get email notificiation for the above transfer via email (outlook) (Not reached)   I am using SAS Enterprise Guide 9.2. Please let me know how can we achieve. And I tried using the below code.   filename outlook email; data _null_; file mailbox to="XXX.XXX@XXX.com" subject='test mail message'; put "hello"; put "this is a message from the data step"; run;   Reards, Jaswanth Neelisetty ... View more