I have input data that includes the variable name, an equal sign, and a value in the data. How can I input that data?
My input data is as follows:
name=Linda english=95 math=94 science=90
name=Susan math=88 english=91 science=90
name=Mary Louise math=90 english=84 science=81
What I've tried so far:
data one;
input name $ subject $;
cards;
My desired output data:
Obs name math
1 Linda 94
2 Susan 88
3 Mary Louise 90