x**********0 发帖数: 163 | 1 请教大家一个SAS combine data set 的问题
两个data set
first data set
state year v1 v2 v3
Alabama 2000
Alabama 2001
Alabama 2002
Alabama 2003
Alaska 2000
Alaska 2001
Alaska 2002
Alaska 2003
second data set
Alabama Alaska
2000 v4 v4
2001
2002
2003
我想把第二个data set 合到第一个里面去,SAS 应该怎么做呢?
谢谢大家 |
g****8 发帖数: 2828 | |
x**********0 发帖数: 163 | 3 second data set
the first row is state,first column is year
Alabama Alaska
2000 1 2
2001
2002
2003
inside numbers are the values for variable 4.
like Alabama 2000 1
Alaska 2000 2 |
g****8 发帖数: 2828 | 4 Alabama 跟Alaska在第二个set里面是variable name?
第一列 year 没有variable name?
你能把第二个写成sas格式的data吗? |
x**********0 发帖数: 163 | 5 yes. it is my fault
Alabama and Alaska are variable names in the second data set
and year is the variable name for the first column.
I am sorry |
s**u 发帖数: 1279 | 6 重新建立一个数据集,然后加上一些条件就可以了吧
【在 x**********0 的大作中提到】 : yes. it is my fault : Alabama and Alaska are variable names in the second data set : and year is the variable name for the first column. : I am sorry
|
t********m 发帖数: 939 | 7 先将第二个data set换一个结构,然后再用merge语句何合并两个data set.
data dataset2;
input year @;
input v4 @;
state='Alabama';
output;
input v4 @;
state='Alaska';
output;
cards;
2000 10 100
2001 20 200
2002 30 300
2003 40 400
;
run;
proc sort data=dataset2 out=dataset2a;
by state;
run;
data combine;
merge dataset1 dataset2a;
run; |
x**********0 发帖数: 163 | 8 thanks a lot
I figured it out in the end with a different way. PROC TRANSPOSE |