cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
PreenaKaur
‎10-26-2018
  • 11 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Receiving 2 separate emails when trying to put email body in excel...

by Calcite | Level 5 in ODS and Base Reporting
‎08-11-2016 01:27 AM
‎08-11-2016 01:27 AM
Hi Bruno,    I did the changes and now not getting previous error message but still there is no email and no error message in the log.    My code was as follows:    filename tmpxlsx temp; %let tmpxlsx = %sysfunc(pathname(work))/sample.lst; %put NOTE: &=tmpxlsx; ods tagsets.excelxp file=tmpxlsx options(sheet_name="Female"); proc print data=sashelp.class; where sex = "F"; run; ods tagsets.excelxp options(sheet_name="Male"); proc print data=sashelp.class; where sex = "M"; run; ods tagsets.excelxp close; filename outbox email to='abc@abc.com' from='def@def.com' attach=( "%sysfunc(pathname(tmpxlsx))" ct='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ext="xls" ) subject='Sample Third Program' ; DATA _null_; file outbox; PUT 'Please find attached the report'; PUT ' '; PUT 'Thankyou'; RUN; filename tmpxlsx clear; filename outbox clear;   seems file is created but not in work library: MPRINT(READSAS): filename outbox email to='abc@abc.com' from='def@def.com' attach=( "/sasworka/env5/lev1/SAS_work038300001E1E_mg5g02n01a/#LN00026" ct='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ext="xls" ) subject='Sample Third Program' ; MPRINT(READSAS): DATA _null_;   Apologies If I am doing something wrong, I am fairly new to SAS!      ... View more

Re: Receiving 2 separate emails when trying to put email body in excel...

by Calcite | Level 5 in ODS and Base Reporting
‎08-08-2016 01:01 AM
‎08-08-2016 01:01 AM
Hi Bruno,   This program works very smoothly from enterprise guide however when I schedule this (in overnight batch run) I am not getting any email . I think its related to some of my access but i am not sure which access it is? (DR_GSD_USER_BATCH referes to batch name)   ERROR: Insufficient authorization to access /opt/sas/env5/lev1/config/sascompute/Lev1/SASApp/DR_GSD_USER_BATCH.lst.   Any ideas please?       ... View more

Re: Receiving 2 separate emails when trying to put email body in excel...

by Calcite | Level 5 in ODS and Base Reporting
‎07-26-2016 03:22 AM
‎07-26-2016 03:22 AM
Thanks a lot Bruno !    Its working for me now ,hope this will work when running from DI (as a batch run) as well ! (I am checking for this)   ... View more

Re: Receiving 2 separate emails when trying to put email body in excel...

by Calcite | Level 5 in ODS and Base Reporting
‎07-25-2016 07:04 AM
‎07-25-2016 07:04 AM
seems its easier in 9.4 however i am still on 9.3 only 😞   I got the following error when trying to run the code :    ERROR: Unable to load module 'SpreadsheetML' from template store! ERROR: No body file. EXCEL output will not be created. ... View more

Re: Proc Export to Excel - Multiple tables to one xlsx file on differe...

by Calcite | Level 5 in ODS and Base Reporting
‎07-25-2016 05:51 AM
‎07-25-2016 05:51 AM
You can try from below sample, its working for me :    proc sql; CREATE TABLE t1 AS select * from abc; run;   proc sql; CREATE TABLE t2 AS select * from def; run;   proc sql; CREATE TABLE t3 AS select * from ghi; run;   proc sql; CREATE TABLE t4 AS select * from jkl; run;   ods TAGSETS.EXCELXP body=outbox rs=none style=styles.HTMLBlue; ods TAGSETS.EXCELXP text="test sample text";        ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="abc");      proc print data=t1 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="def");      proc print data=t2 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="ghi");      proc print data=t3 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="jkl");      proc print data=t4 noobs;      run; ods TAGSETS.EXCELXP close;   filename outbox email            to='abc@abc.com'            from='def@def.com'            type='application/vnd.ms-excel'           subject='Sample First Program';   Creating excel sheet with 4 different tabs   ... View more

Receiving 2 separate emails when trying to put email body in excel she...

by Calcite | Level 5 in ODS and Base Reporting
‎07-25-2016 05:42 AM
‎07-25-2016 05:42 AM
Hi All,    I am trying to :    Create an excel sheet using output of my 4 proc sql statements  then email it  add email body    First 2 are working fine however when I am trying to put email body I am getting two different emails , my code is as follows:    proc sql; CREATE TABLE t1 AS select * from abc; run;   proc sql; CREATE TABLE t2 AS select * from def; run;   proc sql; CREATE TABLE t3 AS select * from ghi; run;   proc sql; CREATE TABLE t4 AS select * from jkl; run;   ods TAGSETS.EXCELXP body=outbox rs=none style=styles.HTMLBlue; ods TAGSETS.EXCELXP text="test sample text";        ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="abc");      proc print data=t1 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="def");      proc print data=t2 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="ghi");      proc print data=t3 noobs;      run;      ods TAGSETS.EXCELXP rs=none OPTIONS(SHEET_NAME="jkl");      proc print data=t4 noobs;      run; ods TAGSETS.EXCELXP close;   filename outbox email            to='abc@abc.com'            from='def@def.com'            type='application/vnd.ms-excel'           subject='Sample First Program';   DATA _null_;      PUT 'Please find attached the report';      PUT ' ';      PUT 'Thankyou'; RUN;     I have seen so many similar threads but none of them are working for me. I tried ODS text , separate Data _null_ option, tried putting all into one filename option.   Can you please help in identifying the issue in this ?   ... View more

Re: Date filter in Proc Sql

by Calcite | Level 5 in SAS Procedures
‎07-17-2015 02:25 AM
‎07-17-2015 02:25 AM
Hey All, Following did worked: %LET DATE=%SYSFUNC(DATETIME()); %LET MONTH_END_DT = %SYSFUNC(INTNX(DTMONTH, &DATE.,-1,E)); %LET MONTH_START_DT = %SYSFUNC(INTNX(DTMONTH, &DATE.,-1,B)); %PUT MONTH_END_DT = %SYSFUNC(PUTN(&MONTH_END_DT, DATETIME19.));   %PUT MONTH_START_DT = %SYSFUNC(PUTN(&MONTH_START_DT, DATETIME19.)); PROC SQL; CREATE TABLE WORK.TEST AS SELECT ID , OPEN_TIME, &MONTH_START_DT AS Y FORMAT DATETIME19., &MONTH_END_DT AS X FORMAT DATETIME19. FROM DETAIL.ABC WHERE &MONTH_START_DT. LE OPEN_TIME LE  &MONTH_END_DT.; QUIT; ... View more

Re: Date filter in Proc Sql

by Calcite | Level 5 in SAS Procedures
‎07-14-2015 12:08 AM
‎07-14-2015 12:08 AM
I tried with datepart as well but no luck Its not returning any rows with or without using datepart .. log shows : 0 records and 94 columns I have checked the records in table, there are rows for same timeperiod ... View more

Date filter in Proc Sql

by Calcite | Level 5 in SAS Procedures
‎07-13-2015 01:14 AM
‎07-13-2015 01:14 AM
hello I am struggling with filtering records from table on date criteria. Format in which Dates are stored in my table are : 01JUN2015:08:45:29 I am able to extract records when i am using below query : PROC SQL; CREATE TABLE WORK.TEST AS SELECT * FROM DETAIL.ABC where open_time between '01Jun15'd and '01Jul15'd; quit; But when i change the dates to generic one ( first date of previous month and first date of current month ) then its not working , I am getting all the records instead of filtered one PROC SQL; CREATE TABLE WORK.TEST AS SELECT * FROM DETAIL.ABC where open_time between INTNX('MONTH',TODAY(),-1,'B') and INTNX('MONTH',TODAY(),0,'B'); quit; Do anyone have an idea where I am wrong !! ... View more

Re: Schedule SAS 9.3 WRS output in excel format

by Calcite | Level 5 in SAS Web Report Studio
‎06-06-2015 01:08 PM
‎06-06-2015 01:08 PM
Thanks! i will try to workout with ODS option ... View more

Schedule SAS 9.3 WRS output in excel format

by Calcite | Level 5 in SAS Web Report Studio
‎05-30-2015 06:42 AM
‎05-30-2015 06:42 AM
Hi All, New to SAS, I am struggling to find out a way to schedule reports output which should be in excel for sure to various users in our organisation. Detailed requirement is: Set of reports need to go out on daily , weekly, monthly basis Data will be extracted from SAS libraries using Stored process Charts will also be included in these reports along with plain data sets. I have successfully created a report in SAS web report studio using stored process and scheduled it to myself. But scheduler gives me only 2 output methods : .pdf or .html Is their a way we can schedule our excel output from web report studio? Or there is some another way possible (not from web report studio) where in I can pass stored process name and create charts and schedule the output to excel? :smileyconfused: ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-26-2018 12:49 PM
Likes given to
View All
Quick links