topic Re: PDB gets loaded only at detail level. I need them to be loaded in all day/week/month/year level in SAS Programming

PDB gets loaded only at detail level. I need them to be loaded in all day/week/month/year level

Pon1 — Wed, 02 Jan 2019 09:59:55 GMT

Hi,

I created one PDB and tried to load it . while loading it is loaded only at Detail level. It is not accumulated to DAY/WEEK/MONTH/Year level. Can you please guide me to find the issue?

Thank you,

Raj.

Re: PDB gets loaded only at detail level. I need them to be loaded in all day/week/month/year level

Amir — Wed, 02 Jan 2019 11:01:25 GMT

Hi,

Please provide information such as:

Which SAS product you are using, for example, BASE, EG, VA, etc.
The version number of the software.
The code you are using.
Sample input data.
What output data you see.
What output data you want.
Log messages.
Anything else that would be useful to help you.

These might help someone have a clearer idea of how to provide guidance.

Regards,

Amir.

Edit: Added input.

Re: PDB gets loaded only at detail level. I need them to be loaded in all day/week/month/year level

ballardw — Thu, 03 Jan 2019 17:29:34 GMT

@Pon1 wrote:

Hi,

I created one PDB and tried to load it . while loading it is loaded only at Detail level. It is not accumulated to DAY/WEEK/MONTH/Year level. Can you please guide me to find the issue?

Thank you,

Raj.

And a PDB is what exactly? Acronyms you use that are not part of SAS may mean something else to others on this forum.

AS @Amir mentioned we are missing some details.

Re: PDB gets loaded only at detail level. I need them to be loaded in all day/week/month/year level

Cynthia_sas — Thu, 03 Jan 2019 17:49:31 GMT

Hi:
I think that the PDB might be something associated with the MXG product? Performance Data Base? You really have not provided enough information here. If you are using a SAS product then you might want to open a track with Tech Support. However, MXG is not a SAS product, so if you are asking about MXG and their PDB, then you might want to find an MXG group.
Cynthia

Re: PDB gets loaded only at detail level. I need them to be loaded in all day/week/month/year level

Pon1 — Mon, 21 Jan 2019 17:52:15 GMT

Sorry for not providing more information.

Hope this will help to get some solution.

I am trying to load mainframe SMF data, it contains the information about VSAM data set access. So I have created one PDB to load all SMF type 62 data. For that I have included XTY62 ITRM table (Interactive resource management).

You can find more information on

https://support.sas.com/documentation/onlinedoc/itsv/zipfiles/HTMLDoc_3.3_H33002/MXGtoITRM_MXG.html, in IBM SMF folder, open Sub folder VSAM and you can find the table defenitions of ITRM and MXG.

IT has all computed columns as well as summarization of DAY, WEEK, Month and Year. I can able to load the data at detail level. Where as it is not summarizing for day, week, month and year.

I have attached the job log file of the job that I ran.

Note: I have added both XTY62 and XTY64 tables. while loading, it summarizes XTY64 at all levels. Could you please guide me to find a solution on the same?

Thank you,

Raj.

Re: PDB gets loaded only at detail level. I need them to be loaded in all day/week/month/year level

Cynthia_sas — Mon, 21 Jan 2019 18:05:07 GMT

Hi:
This really sounds like an issue that you need to work on with Tech Support. Especially if you have ITRM and are having issues. You can contact Tech Support by sending mail to support@sas.com or by filling out this form: http://support.sas.com/ctx/supportform/createForm

Cynthia

Re: PDB gets loaded only at detail level. I need them to be loaded in all day/week/month/year level

Pon1 — Mon, 21 Jan 2019 18:36:11 GMT

Thank you,

I will send email and contact Tech Support.

Thank you once again for your support.

Regards

Raj.