Newbie question: create

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Newbie question: create

[ Edited ]

I'm trying to create


Accepted Solutions
Solution
‎11-07-2016 02:38 PM
Super User
Posts: 11,110

Re: Newbie question: create temp Freq distribution table

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?

 

View solution in original post


All Replies
Super User
Posts: 11,110

Re: Newbie question: create temp Freq distribution table

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;

   
   
New Contributor
Posts: 2

Re: Newbie question: create temp Freq distribution table

[ Edited ]

Hi

 

I've attached the table.

Solution
‎11-07-2016 02:38 PM
Super User
Posts: 11,110

Re: Newbie question: create temp Freq distribution table

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?

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 226 views
  • 0 likes
  • 2 in conversation