topic Split data from one table to two tables in New SAS User

Split data from one table to two tables

dassuz — Wed, 12 Dec 2018 11:22:44 GMT

Hi I was hoping someone can help me,

I have 1 table with multiple columns, one of the columns is called read_type which is either a 1,2,3 or a 4.

I would like to put all the 1 and 2 in one table and the 3 and 4 in another table. What is the best way to do this?

Re: Split data from one table to two tables

RW9 — Wed, 12 Dec 2018 11:27:02 GMT

data want1 want2;
  set have;
  if read_type in (1,2) output want1;
  else output want2;
run;

Re: Split data from one table to two tables

MRB3855 — Wed, 12 Dec 2018 11:32:51 GMT

This should do the trick.

data want12;
 set have;
 where read_type<3;
run;
data want34;
 set have;
 where read_type>2;
run;

Re: Split data from one table to two tables

Kurt_Bremser — Wed, 12 Dec 2018 11:54:39 GMT

In such cases I very much prefer to use a select statement:

data
  want1
  want2
;
set have;
select (read_type);
  when (1,2) output want1;
  when (3,4) output want2;
end;
run;

If a value outside the given range 1-4 is encountered, the step will fail, alerting you to the unexpected value.

Split 1 table to 2 Outputs

dassuz — Wed, 12 Dec 2018 12:10:25 GMT

Hi I was hoping someone can help me, I have a table with many columns, One of the columns is called Read_Type, This column has millions of lines of data which consists of either a 01, 02, 03 or a zero 4. I would like to transfer all the data with a read type of 01 and 02 into Table_A and the remainder into Table_B, what is the best way to do this

Re: Split 1 table to 2 Outputs

PeterClemmensen — Wed, 12 Dec 2018 12:13:30 GMT

Do like this

data Table_A Table_B;
   set have;
   if Read_Type in ('01', '02') then output Table_A;
   else output Table_B;
run;

Re: Split 1 table to 2 Outputs

RW9 — Wed, 12 Dec 2018 12:23:29 GMT

Why not start by following the guidance on posting a question. Post test data in the form of a datastep:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Show what you want the output to be.

You say in the first post you have 1,2,3,4. In this you say you have 01, 02, 03, 04 or 0, so is that a character variable?

Second, what is wrong with the code examples you have been given so far?

Re: Split 1 table to 2 Outputs

dassuz — Wed, 12 Dec 2018 12:28:33 GMT

Thanks

Re: Split 1 table to 2 Outputs

Kurt_Bremser — Wed, 12 Dec 2018 12:34:47 GMT

Just replace the values in my when-branches with the correct character values.

@dassuz wrote:

Hi I was hoping someone can help me, I have a table with many columns, One of the columns is called Read_Type, This column has millions of lines of data which consists of either a 01, 02, 03 or a zero 4. I would like to transfer all the data with a read type of 01 and 02 into Table_A and the remainder into Table_B, what is the best way to do this