Hello SAS folks!   I’m looking for some help in naming html output files with by values (actually two sets of by values).  I'm only finding reference to numbers added to a base name.   I see that it can now be done in ODS graphics with imagename= and was hoping for something similar for html. Anchor= gets links in the table of contents, but only for a single bygroup.   In the example below, the body files come out as shoes-body_.htm shoes-body_1.htm --> shoes-body_46.htm   What I want is shoes-body_Africa_Addis Ababa.htm shoes-body_Africa_Algiers.htm --> shoes-body_Western Europe_Rome.htm   (No spaces or a substituted character for them would be fine, if not even better)   We are using 9.4 TS1M6 as remote login to a virtual machine with Windows Server 2016.   Thanks for any help you can give me!   Wendy T.   ods _all_ close ; ods html body = "shoes-body_.htm" contents = "shoes-contents.htm" frame = "shoes-frame.htm" anchor = "#byval(region)" newfile = bygroup ; title "SAS Dataset Shoes" ; title2 "for #byval(Region) and #byval(subsidiary) " ; data shoes ; set sashelp.shoes ; proc sort ; by region subsidiary ; run ; proc print data=shoes ; by region subsidiary ; footnote "Each region in a separate file" ; footnote2 "Can the body files be named with byvalues?" ; run; ods html close;   ... View more

Hello SAS folks!   When I use a natural join in SQL, the date format is lost, even if it's the same in both datasets.  Is there any easy way to keep or specify the date format without specifying columns?   tiny example:   proc sql noprint ; create table have as select distinct * from sashelp.pricedata (keep=date sale) natural join sashelp.prdsal3(keep=date state) where date between '01jan1998'D and '30may1998'D and state='Florida' and sale between 300 and 350 ; quit ; data want ; set have ; format date mmddyy10. ; run ;   Ideally, I would like to have date come out as mmddyy10., so that I don't have to do an additional step to create 'want'.  I'm running SAS 9.4M5 on Windows with a remote login, if that makes any difference.   Thanks so much for any help you can give me!   Wendy T   ... View more

Hello SAS folks-   I need your help again. I’m working on some daily water level data, and, of course, it has gaps. I’ve been asked to use a simple linear interpolation to fill in the gaps. No problem – we have SAS/ETS, and that’s a simple PROC EXPAND with method=join.   proc expand data=have out=want from=daily ; by station ; convert daily_stage=dly_interp / method=join ; id date ; run ;   Then it got more complex… I’ve now been asked to interpolate, but only when the gap is less than a month, so I picked 30 days for a starting point.   I think the solution may be in transformout=  but so far I can’t see it, and I’ve had no luck searching.   The only idea I have had is to do the interpolation first, then use missing() on the original data (found that on the boards here somewhere) both forwards and backwards to find the gaps, then keep the interpolation based on the gap counts.   Here’s some example code. It generates some data, then makes missing values for varying periods (have). %gapper sorts the values and does a running count of missing values in a gap. It’s run twice – once forward and again backward in time. The sql puts the forward and backward data back together, and uses a case statement to  'pick' the interpolated value based on the gap counts.   The example is written backwards, as column "original" would actually be the interpolated values, and "original_&gapsize" would be the data values, but it's the same process of finding gaps.    Could someone please help me with a better solution?    We are running SAS 9.4 TS1M3 and SAS/ETS 14.1 via remote login to a Windows virtual server.   Thanks so much for any help you can give me!   WendyT   %let gapsize=30 ; data have (drop=i); do i= 1 to 2 ; if i=1 then station='aaa' ; else station='bbb' ; date='01JAN2017'd ; original=1 ; do day=1 TO 200 ; date= date + 1 ; original= original + 0.1 ; original_&gapsize = original ; if day ge 30 and day < 40 then original_&gapsize = . ; if day ge 60 and day < 80 then original_&gapsize = . ; if day ge 90 and day < 118 then original_&gapsize = . ; if day ge 130 and day < 165 then original_&gapsize = . ; output ; end ; end ; format date yymmdd10. ; run ; %macro gapper(direction,order) ; proc sort data=have ; by station &order date ; run ; data gapsize_&direction. ; set have ; by station original_&gapsize notsorted ; if missing(original_&gapsize) then do ; if first.original_&gapsize then n_&direction. =0 ; n_&direction. +1 ; end ; else do ; n_&direction. =0 ; end ; run ; %mend ; %gapper(forward, ) ; %gapper(backward,descending) ; proc sql noprint ; create table want as select station ,date format=yymmdd10. ,day ,original ,original_&gapsize ,case when sum(n_forward,n_backward) gt &gapsize then . else original end as interp_&gapsize ,n_backward ,n_forward from gapsize_forward natural join gapsize_backward order by station, date ; quit ; ... View more

Hello SAS folks –   I will be making several series of graphics using cumulative sums at several different aggregation levels. I have been reading the SGPLOT documentation to see if there is anything I can use to generate the plots without having to actually calculate the cumulative totals beforehand, but no luck so far. If someone can point the way, I would be very grateful.   Most of the aggregations will be based on date (year, fiscal year, month, week), but we also have text categories as well, and possibly some combinations.   We are running 9.4M3 on a Windows server via remote login. We do have SAS/GRAPH, but I would prefer to use SG if possible, as I have quite a bit of existing code.   I made up a little example dataset, with date, person, and amount as variables.   The graphics must have “Date” on the X axis, and “Amount” on the Y axis. The code at the bottom gives a single graph with one line for each person. I also tried tinkering with FREQ and UNIVARIATE with no success on getting the axes correct. The closest I got was reversed axes.   Graph 1: cumulative sum by date: X= 12/01/2016    Y=170        (10 from Lisa + 100 from John + 60 from Wendy) X= 12/03/2016    Y= 390       (170 + 20 from Lisa + 200 from John) X=12/10/2016     Y= 540       (390 + 150 from Steve) etc.   Graph 2 (series): cumulative sum by date by person: X= 12/01/2016    person=Lisa   Y=10     X= 12/01/2016    person=Lisa   Y=30 (10 + 20)     etc.   Thanks for any help you can give me!   Wendy T     data sample ; input Date mmddyy10. Person $ Amount ; format date mmddyy10. ; datalines ; 12/01/2016 Lisa 10 12/01/2016 John 100 12/01/2016 Wendy 60 12/03/2016 Lisa 20 12/03/2016 John 200 12/10/2016 Steve 150 12/10/2016 Wendy 30 12/11/2016 Lisa 80 12/11/2016 John 100 12/11/2016 Steve 80 12/11/2016 Wendy 20 12/12/2016 John 50 12/15/2016 Steve 20 12/15/2016 Wendy 20 12/17/2016 Steve 100 12/17/2016 Wendy 100 12/28/2016 Steve 180 12/28/2016 Steve 50 12/29/2016 Lisa 50 12/30/2016 Wendy 20 ; run ; %let OUTDIR= YourDirectory ; ods listing close ; ods graphics on / reset=index imagename="graph" height=480px width=1280px imagemap=on ; ods html newfile=none headtext='<style>p,hr {display:none} </style>' path="&OUTDIR\" (url=none) body="body.htm" contents="contents.htm" frame="frame.html" ; proc sgplot data=sample ; series x=date y=amount / markers group=person ; run ; ods html close ; ods listing ; ... View more