Weighted average should be fine but what about weighted median in Visual Analytics? I'm comparing this to the "weight" option in proc means.  Example below shows the weighted average which can be done in multiple steps in Visual Analytics using Aggregated Measure (Sum(ByGroup,var*wgt)/Sum(ByGroup,wgt)). What about the weighted median? var wgt var*wgt   1 1 1   2 2 4   3 3 9   4 3 12   5 3 15     12 41 3.416667 ... View more

Please check if the variable grouping exists in the data set. ... View more

thanks. ... View more

Is the notsorted option in the by variable a good idea to filter them out if the data is already sorted prior by id, date and status? data check; by id status notsorted; if first.status=1; run;       ... View more

I should have mentioned that oops.... To obtain the date of the first occurrence between the status change by ID. For example ID-1 has two OK status before the DEL status, so we keep the first one with date 02-May-2009. For ID's with no status changes, it is output as is (ID-2).   ... View more

  HI,   Say I created this file test.html in a location as follows.... ods tagsets.Tableeditor file='/xxxx/xxx/xx/test.html'   How do I call this created file (test.html) to download using the filename filesrvc statements?   Thanks for your patience! ... View more

HI Allan, I can set that up later with an example but had a question if the following can be streamed if i am using tagset.tableeditor? (i've set _output_type as none in parameter) %if &outputtp=HTML %then %do; * Create the Excel XML output and associate with the job; filename htmlfile filesrvc parenturi="&SYS_JES_JOB_URI" name='_webout.json' contenttype='text/html' contentdisp="attachment; filename=ok.html"; *ods html file=htmlfile; ods tagsets.tableeditor file='htmlfile' style=styles.MyStyle /*options(autofilter="YES" autofilter_table="1" autofilter_width="6em" autofilter_endcol= "7" frozen_headers="YES" frozen_rowheaders="YES" )*/ ; proc print data=sashelp.class noobs; title 'Test ODS HTML'; run; ods tagsets.tableeditor close; ods listing; %end;      ... View more

HI Allan,   I migrated the stored process from 9.4 to Viya 3.5. I've the options of either creating html, xlsx and pdf as a drop down. Unable to figure out as to how to set the options for the automatic download for each of the reports based on selection. If I select _output_type='none' then I get the following error: ERROR: No logical assign for filename _WEBOUT.    if I set _output_type='ods_html5' or html, then I get the links of _webout.html and _webout.xls instead of automatic download for the selected report type. Any thoughts on this? ... View more

The parameter _output_type =none seems to suppress the creation of those links. Do you concur on this? ... View more

deploying as a job and opening the URL using the JES Web App. What should be the _PROGRAM parameter in this case? It was a bit confusing in SAS docs... ... View more

Good suggestion and i did that now. thanks again! ... View more