在SAS里面用loop进行data input，但运行出来结果很奇怪

data如下：
78 70 79 78 77 78 69 72 73 75
79 76 66 80 76 78 68 77 71 77 83
78 76 70 72 75 72 76 73 72
66 66 74 64 69 67 70 75 70 68 69
64 72 65 66 70 75 81 70 66 76 71 70 75 73 72
74 81 79 76 71 81 70 75 77 75 72 73 90 65
83 80 84 84 84 82 82 84 82 81 79 81 76 81
85 85 87 85 96 85 86 85 85 95 84 85 84


每一行应该是15个数字，一共八行，每一行代表不同的含义：

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应该怎么改？？

请懂的大神指教一下~~

谢谢~~

1. do carrier="delta airlines","southwest airlines","american airlines","united airlines";
   
2. do sex="males","females";
   
3. do subj=1 to 15;
   
4. input rating @;
   
5. If rating~=. then output;
   
6. end;
   
7. input rating;
   
8. end;
   
9. end;

复制代码

In your code, try @@ (you had one @); also I think you have duplicates in output. Do you have missing values?

Did you try?

johnpark1 发表于 2015-11-8 12:07
In your code, try @@ (you had one @); also I think you have duplicates in output. Do you have missin ...

thank you for you reply.
I tried @@ but didn't work.
Maybe sth wrong with missing variable

teqel 发表于 2015-11-8 09:30

谢谢，现在电脑上没有sas明天早上运行试试看！！

teqel 发表于 2015-11-8 04:15

Just run the code, perfect!
thanks a lot!

priis 发表于 2015-11-10 01:46
Just run the code, perfect!
thanks a lot!

你知道为什么行的通吗