topic Re: Proc dataset option? in SAS Programming

Proc dataset option?

ybz12003 — Mon, 15 Oct 2018 13:19:00 GMT

Hello,

I use proc dataset to format my SAS dataset. I would like to save my new SAS dataset into a new file, please advise how to do it. Thanks.

proc datasets library=work; 
				 modify test;
				format  ID   $9.   
.
.
.
.
.
.
run;

Re: Proc dataset option?

andreas_lds — Mon, 15 Oct 2018 13:22:51 GMT

You will have to copy the dataset before adding the formats. The modify-statement has no option to store the dataset with a new name.

Re: Proc dataset option?

Kurt_Bremser — Mon, 15 Oct 2018 13:24:52 GMT

Do both (creation of a new dataset and assigning the format) in a simple data step.

Re: Proc dataset option?

ybz12003 — Tue, 16 Oct 2018 12:54:54 GMT

Of course using DATA step could approach this format purpose. However, I have hundreds of statement (format, rename and label) to modify this dataset. I read use proc dataset could reduce the processing time, comparing with simple data step. That is why I use Proc Dataset. Correct me if I am wrong.

Re: Proc dataset option?

andreas_lds — Tue, 16 Oct 2018 13:03:29 GMT

@ybz12003 wrote:

Of course using DATA step could approach this format purpose. However, I have hundreds of statement (format, rename and label) to modify this dataset. I read use proc dataset could reduce the processing time, comparing with simple data step. That is why I use Proc Dataset. Correct me if I am wrong.

That is correct as long as you don't need the modifications applied to a clone of the dataset.

Re: Proc dataset option?

Kurt_Bremser — Tue, 16 Oct 2018 13:06:06 GMT

@ybz12003 wrote:

Of course using DATA step could approach this format purpose. However, I have hundreds of statement (format, rename and label) to modify this dataset. I read use proc dataset could reduce the processing time, comparing with simple data step. That is why I use Proc Dataset. Correct me if I am wrong.

Quote from your otriginal post:

"I would like to save my new SAS dataset into a new file"

Since you read and write the dataset anyway, the advantages of using proc datasets won't come into play.