topic Re: set only once in SAS Programming

set only once

SASPhile — Tue, 03 Nov 2009 20:58:03 GMT

data hhs.hhs_combine_all(compress=yes);
set hhs.hhs_combine_all HHS_all;
description=upcase(description);
physician_name=upcase(physician_name);
ADDRESS_1=upcase(ADDRESS_1);
run;

How to load the above program to hhs.hhs_combine_all only one time.
I.e to avoid loading multiple times.

Re: set only once

Peter_C — Tue, 03 Nov 2009 22:33:08 GMT

run it once and it is run.
What runs it more than once?

Re: set only once

sbb — Tue, 03 Nov 2009 22:47:04 GMT

From my perspective, the question is unclear, however from the SET statement, it appears that there is a file to be replaced by adding new observations to that same file. But of course, the first time the file that is named in both the DATA and SET statement will not exist. Maybe this is the question?

If true, the SAS OPTIONS NODSNFERR; can be set. And if you have a BY statement to order the observations, you will also need to set NOVNFERR and NOBYERR, as well.

Scott Barry
SBBWorks, Inc.

Re: set only once

Peter_C — Tue, 03 Nov 2009 23:10:42 GMT

should it be proc append?

Re: set only once

Flip — Wed, 04 Nov 2009 14:20:43 GMT

No he is just UPCASING 3 variables. I have no idea what he is asking.

Re: set only once

SASPhile — Wed, 04 Nov 2009 15:11:18 GMT

This part of the code is the middle portion of a macro.There are situations,when I had to make changes to the code above or below this data step and so had to run the whole code again.in those situations hhs_all gets appended again resulting in duplicate values.

Re: set only once

abdullala — Wed, 04 Nov 2009 16:18:47 GMT

I dont know there is any way your code will work for that purpose. you will need to control when to append the other dataset.
approach 1: do all you need to do to the base dataset, and only append at the very end after all the repeating work are completed.
approach 2: use different dataset name after appending so the original does not get overwritten by appending.

Re: set only once

sbb — Wed, 04 Nov 2009 16:55:37 GMT

Also, you might receive more useful replies and assistance when you share the entire code piece and not just a convenient snippet.

Scott Barry
SBBWorks, Inc.