topic Re: How to create mapping document? in SAS Data Management

How to create mapping document?

arv — Wed, 19 Sep 2018 17:12:57 GMT

Hello,

I am new for SAS programming. I started learning SAS two weeks before. My company uses SAS and it creates three .txt files that are being used by the Informatica ETL team as source. My work is to create mapping document, functional document with business logic after examining the SAS code. I am supposed to examine the code and look find which columns coming from which table and how they are in target file. I am wondering where should I start from.

Any help would be greatly appreciated.

Thank you

Re: How to create mapping document?

Reeza — Wed, 19 Sep 2018 17:19:04 GMT

Go through your programs/scripts and comment each step. Then use PROC SCAPROC to run it if possible. It will give you a bunch of that information in the log. Transformations are what you need to keep an eye on - how are variables created and where are they coming from. When tracing this I usually draw a flow chart for myself and include all transformations. Then I convert it into the formal docs required for the BI area.

Re: How to create mapping document?

arv — Wed, 19 Sep 2018 17:32:30 GMT

Thanks for the help! I am going to get access at the end of this week and then I will follow what you said.

Thank you again!