topic Re: creating data set in SAS Programming

creating data set

Aexor — Sat, 08 May 2021 19:36:41 GMT

Need inputs in below query:

We want a smaller dateset from a huge dateset(having 10000 variable) based on a condition , and also creating a new variable.

What are options and statements you are going to prefer ?

and out of 10000 variables we need few only.

Please suggest

Aexor — Sat, 08 May 2021 19:39:19 GMT

How can we create 4 to 5 datasets , based on different condition in single code ?

PaigeMiller — Sat, 08 May 2021 20:08:58 GMT

Generally best not to do this, turning one large data set into 4 or 5 smaller ones is not a good thing to do, unless you have a very good reason.

Using SASHELP.CLASS as an example, you can use portions of the data set as needed, without creating separate data sets.

proc print data=sashelp.class(where=(sex='M'));
run;

proc print data=sashelp.class(where=(sex='F'));
run;

PaigeMiller — Sat, 08 May 2021 20:15:27 GMT

Please be more specific about the condition regarding how to choose the records that wind up in the output data set.

Please provide a portion of the large data set following these instructions, and not via any other method.

Reeza — Sun, 09 May 2021 01:48:13 GMT

HW or test for a job?

Reeza — Sun, 09 May 2021 01:48:38 GMT

The general recommendation in SAS is to not split data sets. The BY group processing typically makes this very unnecessary and it also requires a lot more work/effort if you do.

https://blogs.sas.com/content/sgf/2020/07/23/splitting-a-data-set-into-smaller-data-sets/

andreas_lds — Mon, 10 May 2021 04:59:40 GMT

I have merged both posts.

What does "huge" mean? Give some numbers!

And having 10k variables is a design-fault, so fix that problem during creation of the dataset, not afterwards.