topic Re: When is ods path .... (write)? in ODS and Base Reporting

When is ods path .... (write)?

xxformat_com — Tue, 29 Jun 2021 13:46:19 GMT

Hi,

Can you think of an example where ods path ....(write) is used ? ods path ....(read/update) usually do what I need.

Regards,

Re: When is ods path .... (write)?

Athenkosi — Tue, 29 Jun 2021 13:57:13 GMT

The ODS PATH statement is used to manage the template stores, for reading and saving templates.

Template store can have one of three access modes: read, write and update.

READ: You can only read templates to a template store

UPDATE: You can read or write templates to a template, if the template store does not exist a new one is created.

WRITE: You can read or write templates to a template, a new template store is always created

Re: When is ods path .... (write)?

xxformat_com — Tue, 29 Jun 2021 14:14:50 GMT

I was not looking for a copy of the sas online documentation.

Re: When is ods path .... (write)?

data_null__ — Tue, 29 Jun 2021 14:52:41 GMT

@xxformat_com wrote:

I was not looking for a copy of the sas online documentation.

Interesting comment. Not here to make friends?

WRITE

provides Write access (always creating a new template store) as well as Read access.

Re: When is ods path .... (write)?

Kurt_Bremser — Tue, 29 Jun 2021 16:13:26 GMT

You use WRITE when you want to make sure that the template store is re-initialized, e.g. when a lot of cruft has accumulated in it

Re: When is ods path .... (write)?

xxformat_com — Tue, 29 Jun 2021 17:24:47 GMT

Thank you Kurt

Re: When is ods path .... (write)?

Cynthia_sas — Tue, 29 Jun 2021 18:24:02 GMT

Hi:
And to add more info to @Kurt_Bremser's response: You should NEVER attempt to define SASHELP.TMPLMST as WRITE or UPDATE in an ODS PATH statement, since that is the item store delivered with each SAS install depot. If you're lucky, you won't ruin the template store because your administrators made it read only. If you're unlucky, you can accidentally render SASHELP.TMPLMST unusable.
Cynthia