SAS VA 8.5.2 - I would like to create a hierarchy(?) where the user can click on a categorical value in a bar chart (<24 hrs, 24-48 hrs, ..) and have it drill down to the numeric values behind the category (e.g. click on '<24 hrs' and it opens another bar chart showing the distribution of hours for this group). Trying to create a hierarchy does not let me use the numeric hours variable. Any ideas?   Thanks in advance! ... View more

Good day, SAS VA guru's.   I want to provide the option for users to view trends at either the fiscal, quarterly, or monthly level ((noting that SAS does not recognize our fiscal year (Apr 01 - Mar 31) and associated quarters)). Based on the user selection, the graph would display annual, quarterly,, or monthly trends. Please help! ... View more

Hello!  I created a custom character in SAS VA (8.3.1) based on another character variable. I applied it to a bunch of graphs and then realized I grouped one of the values in the wrong group. When I try to edit it, it lets me go to the edit screen and move the value to the correct group but then when I press 'OK' it doesn't do anything (the 'OK' box is blue suggesting it should work but nothing happens). I really don't want to create another variable and then reassign all my graphics! ... View more

Have the following in SAS VA *8.3 I believe*: date population gender 04Jan2015 395 F 04Jan2015 3052 M 05Jan2015 3143 M 05Jan2015 397 F 06Jan2015 405 F 06Jan2015 3120 M 07Jan2015 3022 M 07Jan2015 378 F 08Jan2015 3193 M 08Jan2015 390 F 09Jan2015 390 F 09Jan2015 3144 M 10Jan2015 3114 M 10Jan2015 370 F 11Jan2015 402 F 11Jan2015 3455 M 12Jan2015 386 F Want: a) average population per month b) average population per fiscal year (April 01-March 31) ... View more

*Update: I am dealing with bad data and trying to clean it up. The have data represents scenarios where there were multiple admits/releases within an hour. It is assumed these were errors (e.g. released the wrong person so then readmitted them (red) or used the wrong release reason so readmitted and then re-released them with the correct reason (purple).    Hello, I am using the following program to combine records that overlap allowing 1 hour between them. I am not getting the expected results. I suspect it has to do with the datetime format. Is 3600 not the number I should be using to represent 1 hour?   data a4; do until (last.id); set a3; by id; retain _start _end; format _start _end datetime20.; if first.id then do; _start=move_datetime; _end=next_datetime; end; if move_datetime > _end+3600 then do; *cases with only one hour (3600 seconds); output; _start=move_datetime; _end=next_datetime; end; else _end=max(_end, next_datetime); end; output; *drop move_datetime next_move_datetime; rename _start=admit_date _end=release_date; run;   Have1:       ID Move move_datetime   1 Admit 01JAN2019:12:00:00   1 Release 01JAN2019:12:01:00   1 Admit 15JAN2019:12:00:00   1 Release 17JAN2019:21:56:00   1 Admit 17JAN2019:21:57:00   1 Release 20JAN2019:08:05:00   1 Admit 01FEB2019:01:20:00   1 Release 15FEB2019:21:50:00   1 Admit 15FEB2019:21:50:00   1 Release 15FEB2019:21:50:00           I created the next_datetime  variable by lagging the move_datetime. Have2:       ID Move move_datetime next_datetime 1 Admit 01JAN2019:12:00:00 01JAN2019:12:01:00 1 Release 01JAN2019:12:01:00 15JAN2019:12:00:00 1 Admit 15JAN2019:12:00:00 17JAN2019:21:56:00 1 Release 17JAN2019:21:56:00 17JAN2019:21:57:00 1 Admit 17JAN2019:21:57:00 20JAN2019:08:05:00 1 Release 20JAN2019:08:05:00 01FEB2019:01:20:00 1 Admit 01FEB2019:01:20:00 15FEB2019:21:50:00 1 Release 15FEB2019:21:50:00 15FEB2019:21:50:00 1 Admit 15FEB2019:21:50:00 15FEB2019:21:50:00 1 Release 15FEB2019:21:50:00 . *There is no next move for the last record so I replace the missing with the dummy 01JAN3000:00:00:00         Want:       ID admit_date release_date   1 01JAN2019:12:00:00 01JAN2019:12:01:00   1 15JAN2019:12:00:00 20JAN2019:08:05:00   1 01FEB2019:01:20:00 15FEB2019:21:50:00   Thanks in advance! ... View more