About new_sas_user_4

new_sas_user_4 · ‎05-31-2019

Thanks a lot 🙂

new_sas_user_4 · ‎05-30-2019

I just have the proc report portion ready...nothing before or after it....like odstext/ods pdf/ods proclabel I want to send it from my email address with subject and body of the mail etc.. This is my first time trying to do this...sorry if my questions sound lame..

new_sas_user_4 · ‎05-30-2019

Hello everyone, I am able to create a proc report in SAS. I want to be able to send this report as a pdf in outlook. What are the steps to achieve this? Any documentation available would also be a great help! Thanks!

new_sas_user_4 · ‎02-01-2019

Thanks a ton 🙂 Finallyyyyy able to do it !!! Thanks again!!!!!!

new_sas_user_4 · ‎02-01-2019

Thanks Suryakiran!! I am now able to send the file to my BIApp_User folder under servers. Using the below code: FILENAME Mailbox EMAIL 'myemail@xxxx.ca' Subject='Test Mail message' ATTACH="/users/mypath/my_filename.xlsx" ; /*I am using the same folder location I used to export the file*/ run; /*subject line of the mail*/ DATA _NULL_; FILE Mailbox; PUT "Hello"; /*mail body*/ PUT "This is a message from the DATA step"; RUN; I am receiving a message in my outlook mailbox (Hello This is a message from the DATA step.) There is an excel attachment name my_filename but when I open it it says "" "We found a problem with some content in 'myfilename.xlsx' . Do you want to try to recover as much as we can? If you trust the source of this workbook, click Yes " How can I resolve this?

new_sas_user_4 · ‎01-30-2019

I see files under my WORK library (but they are sas formatted). I want to send the file as an excel.

new_sas_user_4 · ‎01-30-2019

SAS is installed on my local machine but I am not running on the LOCAL server I am running on Selected server: BIApp_User My extracts are produced under the work library. I want to send the excel version of the extract If I specify /sas94apps/prod94config/Lev1/BIApp_USER/Work.my_extract_file_name.xlsx I get the error: Physical file does not exist, /sas94apps/prod94config/Lev1/BIApp_USER/Work.my_extract_file_name.xlsx" content_type="application\xlsx. Any thoughts on how can I resolve this?

new_sas_user_4 · ‎01-25-2019

yes, I am using SAS Enterprise Guide.

new_sas_user_4 · ‎01-25-2019

I am running SAS on a windows laptop.

new_sas_user_4 · ‎01-25-2019

Below is the code I am using and getting the erros mentioned in my question filename outmail email to=("new_Sas_user@xx.ca") cc=("new_Sas_user@xx.ca") replyto=("new_Sas_user@xx.ca") subject=("Data") attach=("C:/Folder Name/File_Name.xlsx" content_type="application/xlsx"); run; DATA _NULL_; FILE outmail; PUT "Hello"; PUT "Plesae find Report as an attachment"; PUT "Thank you"; RUN;

new_sas_user_4 · ‎01-25-2019

Hi, I have a SAS extract that I would like to send as an excel file. I want to send this to outlook. My trail: I exported the file to my local c: drive and then write the below code so SAS picks the file and attaches it as an excel and sends it. I am getting the error : ERROR: Error opening attachment file C:/Name of folder/Name of excelfile.xlsx. ERROR: Physical file does not exist, /sas94apps/prod94config/Lev1/user/C:/Folder name/Excel name.xlsx. Is there a way I can send this?

new_sas_user_4 · ‎01-04-2019

Thanks a lot 🙂 🙂

new_sas_user_4 · ‎01-04-2019

Hi, I am writing a when clause saying: case when put(AB,1.)='1' then XY='0' else XY end as XY AB is numeric and so to put it in the case statement I converted it to char but it is still saying the error "Result of when clause 2 is not the same data type as the preceding results". XY is character. How can I put the case statement here ! Thanks in advance:)

new_sas_user_4 · ‎12-13-2018

Thanks a lot 🙂

new_sas_user_4 · ‎12-13-2018

Thanks everyone!! I am sorry for the confusion with the table names.. The first table I create named A is just for creating the date and I want to use this date to filter from another table (lets call it X).

Online Status	Offline
Date Last Visited	‎05-09-2025 10:06 AM

Re: Sort and label data in Groups

Re: Sort and label data in Groups

Sort and label data in Groups

Re: proc contents in teradata

proc contents in teradata

Re: Teradata Passthrough Help

Teradata Passthrough Help

Re: Managing the layout of tabs in SAS EG

Managing the layout of tabs in SAS EG

Re: Creating a Data Model based on prior month

Re: Grouping?

Re: Grouping?

Sum and Case Statement Help

Re: sending excel file to outlook email through sas

Re: sending excel file to outlook email through sas

Managing the layout of tabs in SAS EG

Re: Unable to load image- ods pdf

Re: Changing Data Output from Columns to Rows

Re: Emailing results of proc report in pdf format to outlook

Re: Emailing results of proc report in pdf format to outlook

Emailing results of proc report in pdf format to outlook

Re: sending excel file to outlook email through sas

Re: sending excel file to outlook email through sas

Re: sending excel file to outlook email through sas

Re: sending excel file to outlook email through sas

Re: sending excel file to outlook email through sas

Re: sending excel file to outlook email through sas

Re: sending excel file to outlook email through sas

sending excel file to outlook email through sas

Re: Result of when clause 2 is not the same data type

Result of when clause 2 is not the same data type

Re: Using a if and intnx date in another dataset

Re: Using a if and intnx date in another dataset