What is an efficient way to save and access the clean data set at the end of the data cleaning proce

Emma_at_SAS — Wed, 03 Mar 2021 16:34:16 GMT

Hello,

I cleaned a data set and at the end of the cleaning, I saved the clean SAS data set, as permanent data.

Because during my data cleaning I created some format values (using PROC FORMAT; ), now I must read the format file before reading the permanent SAS file. otherwise, For each missing format, I get an error and the following warning

ERROR: The format VARIBLE_1 was not found or could not be loaded.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.temp_clean_SAS_data may be incomplete. When this step was stopped there were 0 observations and 42 variables.

What is an efficient way to save and access the clean data set at the end of the data cleaning process?

Thanks

*saving the clean data set;

libname clean "&path";
data clean.permanent_clean_SAS_data;
set temp_clean_SAS_data;
run;

*reading the permanent clean data set;

libname import "&path";
data temp _data;
set import.permanent _clean_SAS_data;
run;

Re: What is an efficient way to save and access the clean data set at the end of the data cleaning p

ballardw — Wed, 03 Mar 2021 17:23:15 GMT

@Emma_at_SAS wrote:

Hello,

I cleaned a data set and at the end of the cleaning, I saved the clean SAS data set, as permanent data.

Because during my data cleaning I created some format values (using PROC FORMAT; ), now I must read the format file before reading the permanent SAS file. otherwise, For each missing format, I get an error and the following warning

ERROR: The format VARIBLE_1 was not found or could not be loaded.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.temp_clean_SAS_data may be incomplete. When this step was stopped there were 0 observations and 42 variables.

What is an efficient way to save and access the clean data set at the end of the data cleaning process?

Thanks

*saving the clean data set;

libname clean "&path";
data clean.permanent_clean_SAS_data;
set temp_clean_SAS_data;
run;

*reading the permanent clean data set;

libname import "&path";
data temp _data;
set import.permanent _clean_SAS_data;
run;

There is nothing wrong with accessing the data.

Set

OPTIONS NOFMTERR;

You apparently have the option set for FMTERR, which treats a missing format as an error.

OR make sure the format is available.

Are you attempting to redefine the library?!?

Once a library is assigned in a current session just use that library name is the typical approach.

topic Re: What is an efficient way to save and access the clean data set at the end of the data cleaning p in SAS Programming

What is an efficient way to save and access the clean data set at the end of the data cleaning proce

Re: What is an efficient way to save and access the clean data set at the end of the data cleaning p