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.
Hi,
Please provide information such as:
These might help someone have a clearer idea of how to provide guidance.
Regards,
Amir.
Edit: Added input.
@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.
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.
Thank you,
I will send email and contact Tech Support.
Thank you once again for your support.
Regards
Raj.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.