DATA Step, Macro, Functions and more

SAS input format for one way ANOVA

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

SAS input format for one way ANOVA

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


Accepted Solutions
Solution
‎10-08-2017 07:45 PM
SAS Super FREQ
Posts: 305

Re: SAS input format for one way ANOVA

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;

View solution in original post


All Replies
Solution
‎10-08-2017 07:45 PM
SAS Super FREQ
Posts: 305

Re: SAS input format for one way ANOVA

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;
New Contributor
Posts: 4

Re: SAS input format for one way ANOVA

Posted in reply to WarrenKuhfeld

Thanks so much Warren! I spent the whole day could not make it. Thanks for the timely reply. It helped a lot

SAS Super FREQ
Posts: 305

Re: SAS input format for one way ANOVA

http://support.sas.com/documentation/cdl/en/statug/68162/HTML/default/viewer.htm#statug_glm_examples...

 

Glad I could help!  That method of reading data for modeling is in the documentation here and probably other places as well.

☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 103 views
  • 1 like
  • 2 in conversation