Hi folks this is my first post in this community and it would be really appreciated if someone give some advise.
I am editing code for a one-way anova analysis but how I in put data before was all like this, for wxample:
Input Name $ value;
cards;
a 1
a 2
a 3
b 4
b 5
b 6
c 7
c 8
c 9;
However this time I got a large data set organized like this:
a 1 2 3
b 4 5 6
c 7 8 9
I am wondering how I can input to assign all values in the same row following 'a' to variable 'Name', and same for 'b', and 'c', without having to return to next row each time?
Thanks so much
data x(drop=i);
input Name $ @;
do i = 1 to 3; input value @; output; end;
datalines;
a 1 2 3
b 4 5 6
c 7 8 9
;
proc print; run;
data x(drop=i);
input Name $ @;
do i = 1 to 3; input value @; output; end;
datalines;
a 1 2 3
b 4 5 6
c 7 8 9
;
proc print; run;
Thanks so much Warren! I spent the whole day could not make it. Thanks for the timely reply. It helped a lot
Glad I could help! That method of reading data for modeling is in the documentation here and probably other places as well.
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.