Newbie question: create

[Rafa0001]

I'm trying to create

[ballardw]

Are you saying that currently you have a text document that you need to create data from?

I would expect 'Good' and 'Bad' to be LEVELS of the Variables Old and New (or OldClaim and NewClaim) or such.

Can you provide a few rows of what you might want this to actually look like.

Here's a guess of one way:

data want;
  do i=1 to 243;
    old= 0;
    new= 0;
    output;
  end;
  do i=1 to 49;
    old= 0;
    new= 1;
    output;
  end;
  do i=1 to 71;
    old= 1;
    new= 0;
    output;
  end;
  do i=1 to 40;
    old= 1;
    new= 1;
    output;
  end;
  drop i;
run;

   
   

[Rafa0001]

Hi

I've attached the table.

[ballardw · Accepted solution]

That is not what dataset would generally look like. A data set consists of variables and values,

So it might be:

Old   New

1      0

1      0

1      1

1      1

0      1

 What type of operation are you going to do with the resulting data set?