About NathanOch

arpi · ‎12-09-2017

data input_extract; set input; len = length(str); do i =1 to len; len1 = len -2; sub_str = substr(str,1,len1); end; run;

Cynthia_sas · ‎12-05-2017

Hi: Here are two examples that I use as Sharepoint examples. Note that I used a UNC location for my Sharepoint site and I did have to go to my Sharepoint admin to get the correct UNC name and get the "cztest" folder added to that location with write access permissions. cynthia ods _all_ close; title; footnote; options topmargin=.25in bottommargin=.25in leftmargin=.25in rightmargin=.25in; ** make pdf file; filename pdf_out '\\xxx.yyy.sas.com\zzz\Shared Documents\Examples\cztest\report1.pdf'; ods pdf(id=p) file=pdf_out ; proc report data=sashelp.class; title 'This PDF file is on SharePoint'; column age height,(min mean max); define age / group; define height / analysis; run; ods pdf(id=p) close; filename pdf_out clear; ** make html file; filename htm_out '\\xxx.yyy.sas.com\zzz\Shared Documents\Examples\cztest\report2.html'; ods html(id=h) body=htm_out encoding=UTF8 dev=gif ; proc report data=sashelp.class; title 'This HTML file is on SharePoint'; column age height,(min mean max); define age / group; define height / analysis; run; ods html(id=h) close; filename htm_out clear;

rogerjdeangelis · ‎11-28-2016

Reading a Directory Correctly in a Filename Statement If you double the double quotes instead of using single quotes it should work. At least it worked on my power workstation. see working code HAVE THIS TREE STRUCTURE ======================== Folder PATH listing for volume backup Volume serial number is 5EA1-ABB0 D:\TXT \---wheredeyat foo1st.log foo1st.txt foo2nd.log foo2nd.txt WANT ==== FNAME=foo1st.log FNAME=foo2nd.log WORKING CODE ( note the dubling of quotes) ========================================== FILENAME dirlist PIPE "dir /B ""&wheredeyat\*.log"""; FULL SOLUTION ============= * create a directory and some file; data _null_; newdir=dcreate('wheredeyat',"d:/txt/"); rc=dosubl(resolve(' data _null_; file "d:/txt/wheredeyat/foo1st.log"; put "foo1st"; file "d:/txt/wheredeyat/foo2nd.log"; put "foo2nd"; ')); stop; run;quit; * layout the tree; filename pipetree pipe "tree ""d:/txt"" /F /A" lrecl=5000; data _null_; infile pipetree truncover; input dirlist $char1000.; *if index(dirlist,'.') =0; put dirlist; run; SOLUTION WITH MINOR MODIFICATION OF YOUR CODE %LET wheredeyat=d:\txt\wheredeyat; *List all the files in the current directory; FILENAME dirlist PIPE "dir /B ""&wheredeyat\*.log"""; DATA dirlist; LENGTH fname $256; INFILE dirlist LENGTH=reclen TRUNCOVER; INPUT fname $varying256. reclen; put fname=; RUN; FNAME=foo1st.log FNAME=foo2nd.log

NathanOch · ‎11-07-2016

Ksharp, Thank you for the help, I could not quite get the code right to work. Regards, Nate

NathanOch · ‎10-25-2016

I actually received this solution from SAS support as well. Changed the zero values to 0.00001 allowed everything to display from the annotation dataset. Thanks so much for your help! Nate

NathanOch · ‎06-03-2016

SAS tech support created this macro code to help inject a date prompt into my SQL code: %let new_min=%str(%')%sysfunc(inputn(&Date_Range_min,date9.),yymmdd10.)%str(%'); %let new_max=%str(%')%sysfunc(inputn(&Date_Range_max,date9.),yymmdd10.)%str(%'); I use the new_min value for the start date, and the new_max value for the end date.

Vince_SAS · ‎04-29-2016

Try this simplified code: *ProcessBody; %let RV=%sysfunc(appsrv_header(Content-type,application/vnd.ms-excel)); %let RV=%sysfunc(appsrv_header(Content-disposition,attachment; filename="Open_Inventory_List.xml")); ods _all_ close; ods tagsets.ExcelXP file=_webout style=analysis; ods tagsets.ExcelXP options(sheet_name="&NEW_CLIENT-&NEW_SUB_CLIENT" sheet_interval='none' embedded_titles='yes'); * Your proc print statement here; ods tagsets.ExcelXP close; Adapted from page 18 of this paper: http://support.sas.com/resources/papers/proceedings15/SAS1700-2015.pdf Vince DelGobbo SAS R&D

NathanOch · ‎04-28-2016

Thanks Timmy, I have not used that method in the past. I will remember those functions for future issues. I love the information SAS logs provide so any information I can get is very helpful. Nate

Vince_SAS · ‎11-06-2015

The code that I posted works with a SAS Stored Process created using SAS 9.4 M3. Vince DelGobbo SAS R&D

Cynthia_sas · ‎08-27-2015

Hi: This is a question for SAS Tech Support. When you run a stored process, depending on whether or how you are overriding the values for &_ODSDEST reserved macro variable, you may or may not be generating code that respects the ODS style PRETEXT that you are coding. This will depend on the version of SAS and the version of the Platform and other things about your stored process setup (not just &_ODSDEST, but &_ODSSTYLE). cynthia

Haikuo · ‎01-30-2015

Glad you found a way!

Online Status	Offline
Date Last Visited	‎12-06-2017 12:38 PM

SAS Report PDF to Sharepoint Folder

Reading a Directory Correctly in a Filename Statement

Re: PROC REPORT and Moving a Value From a Numeric Field to a Character...

PROC REPORT and Moving a Value From a Numeric Field to a Character Fie...

Re: Missing Annotation Data

Missing Annotation Data

Re: Extracting substring using scan or any function

Re: SAS Date Prompt in Proc SQL Statement

Re: Using Prompt Values in ODS Tagsets Excel Sheet Names

Re: Using Prompt Values in ODS Tagsets Excel Sheet Names

Re: Extracting substring using scan or any function

Re: Using Prompt Values in ODS Tagsets Excel Sheet Names

Re: Extracting substring using scan or any function

Re: SAS Report PDF to Sharepoint Folder

Re: Reading a Directory Correctly in a Filename Statement

Re: PROC REPORT and Moving a Value From a Numeric Field to a Character...

Re: Missing Annotation Data

Re: SAS Date Prompt in Proc SQL Statement

Re: Using Prompt Values in ODS Tagsets Excel Sheet Names

Re: Stored Process Works Only in EG

Re: How to include graphics in excel via Stored Process

Re: SAS ODS output from ID portal does not show proc report summary li...

Re: SAS EG PDF Report Issue