topic Re: Newbie question: create temp Freq distribution table in SAS Programming

Newbie question: create

Rafa0001 — Mon, 07 Nov 2016 19:37:31 GMT

I'm trying to create

Re: Newbie question: create temp Freq distribution table

ballardw — Mon, 07 Nov 2016 18:21:05 GMT

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;

Re: Newbie question: create temp Freq distribution table

Rafa0001 — Mon, 07 Nov 2016 19:38:10 GMT

I've attached the table.

Re: Newbie question: create temp Freq distribution table

ballardw — Mon, 07 Nov 2016 18:55:06 GMT

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 1

0 1

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