topic Re: templates modele to document a sas code in SAS Programming

templates modele to document a sas code

LineMoon — Sat, 13 Feb 2016 12:21:40 GMT

Hello,

I am looking for a templates modele to document a sas code.

I want to have by table :

I want to put a specifications like this :

Table Variable rules sources ...

Any modele are welcomed

Thank you

Re: templates modele to document a sas code

mohamed_zaki — Sat, 13 Feb 2016 23:35:15 GMT

I can not follow you. What do you want or mean exactly??

Re: templates modele to document a sas code

LinusH — Sun, 14 Feb 2016 12:55:05 GMT

It sounds like an excel sheet I use to build in new projects. I'm using that based on requirements and design to msp on detail level what source date should go to which target table/column.

But since we usually use DI Studio this document is used only during the project. The actual implementation is defined in the metadata.

So, you just create a excel sheet with the columnsame you need, that's not much more to it.

Perhaps you need an overview document to go with it that describes more complex rules/relationships, especially when theh are on table level (like describing transposing, complex joins, job dependencies etc).

Re: templates modele to document a sas code

LineMoon — Sun, 14 Feb 2016 13:20:25 GMT

an excel sheet with the variables name

Re: templates modele to document a sas code

LineMoon — Sun, 14 Feb 2016 13:28:21 GMT

Thank you for your answer.

That's exactly what i want to do.

But as you say "Perhaps you need an overview document to go with it that describes more complex rules/relationships, especially when theh are on table level (like describing transposing, complex joins, job dependencies"

Yes, I need that. is there any modeles for that ?

I do not have a DI studio, but any documenntation are welcomed .

Thank you so much

Re: templates modele to document a sas code

LinusH — Mon, 15 Feb 2016 07:45:03 GMT

I think that every consultancy/sw provide/implementor have document templates for this.

I'm often uses templates from SAS Intelligence Platform Implementation methodology. But it's proprietary, and can be retrieved either by attending at training, or hiring SAS or SAS partner for an implementation.

If you can't find any material on the web or internally, just get started by putting all the subjects/titles you think you need to document your environment. Then you just update along the road.

You also use the word "model" which is great. Using information/Data/process models is a perfect way to document your system, sources and business processes.

Re: templates modele to document a sas code

LineMoon — Wed, 17 Feb 2016 21:16:06 GMT

Thank you so much for your answer.

You have said " templates from SAS Intelligence Platform Implementation methodology. But it's proprietary, and can be retrieved either by attending at training, or hiring SAS or SAS partner for an implementation."

Any training or documentations are welcomed

Re: templates modele to document a sas code

LineMoon — Wed, 11 May 2016 22:52:55 GMT

@LinusH

I want to use "templates from SAS Intelligence Platform Implementation methodology."

Please, is there any name for that ? which sas services can give me more informations or documentation.

exist for sas 9.2 ?

Thank you

Re: templates modele to document a sas code

LinusH — Thu, 12 May 2016 06:01:13 GMT

IPI is quite version independent.
Contact your SAS representative (sales person, TAM or whatever person you feel comfortable to contact at SAS) and they should be able to help you.

Re: templates modele to document a sas code

LineMoon — Sat, 14 May 2016 13:18:10 GMT

@LinusH

Thank you

I am waiting thier answers.

So for the IPI, I find this link : http://support.sas.com/training/px/psmeth.html who indicate to visit this link Global PSD Methodology Web site.

but it does not work.

So, what is the avantage of the IPI templates for implementation on SAS DI studio ?

Re: templates modele to document a sas code

LinusH — Sat, 14 May 2016 15:46:13 GMT

Well it has it sections where you can define the design for your ETL jobs. But it's merely titles and sample tables and pictures in there.

Re: templates modele to document a sas code

LineMoon — Sat, 14 May 2016 16:00:18 GMT

@LinusH

Thank you

you mean by "Well it has it sections where you can define the design for your ETL jobs. But it's merely titles and sample tables and pictures in there." the IPI templates ? "the task" is it autmatic ?

Re: templates modele to document a sas code

LinusH — Sat, 14 May 2016 17:18:50 GMT

Yes.
And oh no, definitely not the IPI templates.
The design document describes what should be done.
The maintenance doc describes what has been done, where you usually can reuse parts of the design doc.
In my mind try not to document either one too detailed otherwise they will be outdated quite soon.
Given that you have built your DI Studio jobs in good way, they should be near to self explanatory, hence little need for detailed documentation.

Re: templates modele to document a sas code

LineMoon — Sat, 14 May 2016 17:59:57 GMT

So, If I have a dataset tab (in projet 0 )contains a variable X0

X0=X1+X2+X3+X4

X1 in tab1(in projet 1), X1=X11+X12,.....

X2 in tab2(in projet 2),,.................

X3 in tab3(in projet 3),...................

X4 in tab4(in projet 4), .....................

So, there is a dependance beween the variables and tables, it can be more complex in my exemple.

As an exemple, If i want to study X0, What is the sas product can show this dependence in reprting tables ( sas table or excel with graph) ?

even also to identify the variables called the X0 likes M=X0+3, N=P*X0, .....

Thank you

Re: templates modele to document a sas code

LinusH — Sun, 15 May 2016 20:00:13 GMT

When you say "project", are referring to Enterprise Guide projects? If that's the case, I'm not aware of any automatic tool for that.
Life becomes easier if you have ETL jobs in DI Studio where you have som possibilities to extract metadata information. Perhaps not exactly how you describe it.
Is this a current requirement or are trying to prepare for some future development?

Re: templates modele to document a sas code

LineMoon — Sun, 15 May 2016 22:23:32 GMT

Thank you for your answer

"When you say "project", are referring to Enterprise Guide projects? "

It is not non necessary a EG project, it can be a sas program generating a tables for activity A, but the activity A depend on the activity B ...

Is this a current requirement or are trying to prepare for some future development?

it is for prepare for some future development and anticipating the furure evolution..

I am very intersted by a tool can do that job easily

Thank you