I'm trying to create
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?
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;
Hi
I've attached the 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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.