topic Re: How to save a revised dataset on SAS server in New SAS User

How to save a revised dataset on SAS server

varatt90 — Wed, 22 Jun 2022 20:04:36 GMT

Hi,

I'm using SAS studio.

Using the original dataset, I've created a new dataset with no missing variables. Instead of running the code each time to create that new dataset, is there a way I can save the new dataset onto the server? So the new dataset would be my new default.

Any help would be appreciated.

Thanks!

Re: How to save a revised dataset on SAS server

Reeza — Wed, 22 Jun 2022 20:18:20 GMT

What I do, import my raw data, call it raw.

Then do a bunch of cleaning step. Save it to the server with a new name, ie 'proj4.data4analysis' I'm not that creative.

Then all the following steps are built off the data4analysis dataset.

I do not replace the raw import data but do not save intermediary steps between the raw and data4analysis typically either. That could be reproduced by running the program if someone wants.

Re: How to save a revised dataset on SAS server

varatt90 — Wed, 22 Jun 2022 20:27:33 GMT

Thanks so much! What code do you use to save it as a new file?

Re: How to save a revised dataset on SAS server

Reeza — Wed, 22 Jun 2022 20:38:40 GMT

library proj4 '/home/fkhurshed/Demo1/Project4/data';

*import file;
proc import out=raw..... run;

data clean1;
set raw;
...
run;

data clean4;
set clean3;
....
run;

data proj4.data4analysis;
set clean4;
run;

See the last step.

You create the library where you want to save the project work first.

That's usually how my process would work to some degree. To be honest, I'd actually usually separate out the import step as well into a separate program but that's when you get to really streamlining a process. I set it up as minimum 4 programs:

data import
data cleaning (creates data for analysis)
analysis
reporting/results creation

Reason being, that sometimes data sources change over time. For example when I start a proof of concept it may be CSV files I work with and then when moving later on, it becomes a DB table that I'm working with instead so then I can just change it easily in a single program.

Re: How to save a revised dataset on SAS server

varatt90 — Wed, 22 Jun 2022 20:45:56 GMT

Thank you for sharing your code.

I see what you did there. Is there way to save the dataset proj4.data4analysis without actually running proc import of the old data again and datasets clean 1 to 4?

Re: How to save a revised dataset on SAS server

Reeza — Wed, 22 Jun 2022 20:52:20 GMT

Assuming it's in work or somewhere you just run the last step. Then the remainder of your code must reference that saved data set, not the original imported data.

Re: How to save a revised dataset on SAS server

varatt90 — Wed, 22 Jun 2022 20:56:04 GMT

Got it! Thank you for your help!