Row 1 is the satisfaction of males flying Delta airlines

Row 2 isthe satisfaction of females flying Delta airlines      

Row 3 is the satisfaction of males flyingSouthwest airlines

Row 4 is the satisfaction offemales flying Southwest airlines

Row 5 is the satisfaction of males flyingAmerican airlines

Row 6 isthe satisfaction of females flying American airlines

Row 7 is the satisfaction of malesflying United airlines

Row 8 isthe satisfaction of females flying United airlines

然后要用loop进行整理把数据变成univariate,理想情况应该是

航空公司名字，性别，满意度

楼主写的code是这样的：

Data airline;

Infile 'C:\Users\Downloads\airline.txt' DLM='' missover;

do carrier="delta airlines","southwest airlines","american airlines","united airlines";

do sex="males","females";

do subj=1 to 15;

input rating @;

If rating=. then delete else output;

output;

end;

end;

end;

run;

proc print data=airline;

run;

但是运行出来全部变成了一个航空公司一个性别。。。

不知道code应该怎么改？？

请懂的大神指教一下~~

谢谢~~