Hello, I have two questions here. One is how to make the table like following 'want' from data try. Another question is how to input the string with blank. For example, input the words 'the number/of/ those words ' instead of 'number/of/word'. Thanks a lot want ID city word1 word2 1 steelcity word/ assign/ in/ values/ character/ to/ string another 6 greenhills word/ assign/ in/ values/ a/ to/ string other 17 hills Searching/ number/ Character/ of/ String word One is how to make the table like 'want'. data try;
length city word1 word2 $100.;
input id city$ word1$ word2$;
datalines;
1 steelcity word/in/character/string assign/values/to/another
6 greenhills word/in/a/string assign/values/to/other
17 hills Searching/Character/String number/of/word
;
run;
want
ID city word1 word2
1 steelcity word/ assign/
in/ values/
character/ to/
string another
6 greenhills word/ assign/
in/ values/
a/ to/
string other
17 hills Searching/ number/
Character/ of/
String word
... View more
