Analyze .log files

Question

Dear All,

I have a month long .log files generated from SAS 9.4 studio. I downloaded these .log files and would like to use Alteryx to analyze them.

on type of analysis which I would like to do, for example, compare them to track similarities and differences as well as time stamp tracking.

will you be able to direct me to a good way to do that in Alteryx?

thank you so much!

qais

Yoshiro_Fujimori · Answer

Hi @qais1975 , understood. C'est la vie...

My suggestion is to get SAS document which describe the metadata of log file.

Then you can consider how to parse each component.

Depending on the format, you may want to choose from the selection of parsing tools.

DateTime

RegEx

Text to Columns

XML Parse

JSON Parse

I'm afraid this is all I can say. Good luck.

qais1975 · Answer

Dear @Yoshiro_Fujimori ,

The log generated from SAS log about system performance and it is private data that I can not shared.

best regards

Qais

Yoshiro_Fujimori · Answer

Hi @qais1975 ,

Could you attach a sample .log file?