topic Excel workbook patient profile in ODS and Base Reporting

Excel workbook patient profile

k26_23 — Fri, 16 Jun 2023 15:16:13 GMT

Hi I am trying to create excel work book for patient profile, there are around 25 sheets each sheets has common variable subject in the first column and first sheet contains list of all subject. what I am trying to achieve is, if I filter for subject (one or many) in first sheet the filter should be auto applied to all the sheets on the subject Variable.

Is it possible to Achieve in SAS? I tried my best searching everywhere but not able get answers. Please help.

Re: Excel workbook patient profile

Reeza — Fri, 16 Jun 2023 15:35:43 GMT

Is this possible in Excel? If so, how do you accomplish this in Excel?

Re: Excel workbook patient profile

k26_23 — Fri, 16 Jun 2023 15:50:08 GMT

Hi Reeza,

In excel we could accomplish this using VBA and each time we have to enter the Subject(s) manually in the VBA code and it filters all the the sheet, If you need I can share the VBA code.

Re: Excel workbook patient profile

Reeza — Fri, 16 Jun 2023 15:55:54 GMT

I would create a template Excel workbook, with tables and slicers that link to the tables. Click on a slicer and the tables & pivots should filter.

Then have SAS copy the Excel file and export to the tables which will autosize.

Haven't done this in a while so not sure it works but it used to...

Re: Excel workbook patient profile

Sajid01 — Tue, 12 Sep 2023 18:14:10 GMT

Hello @k26_23
Your question is very interesting.
Posting in appropriate Excel/Microsoft forums may be more helpful.

Re: Excel workbook patient profile

Reeza — Tue, 12 Sep 2023 19:19:20 GMT

Even in Excel, enabling Slicers that point at Tables could be another option. VBA seems a touch outdated, but it depends on the complexity of the reports.