请各位大虾帮我看看这个问题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

小弟是sas的初学者,现在碰倒了一个问题,如下

Data Census2001;
infile 'indiv-ver2-050824.dat' lrecl=266;
input PROVP 1-2
AGEP 39-40

MOB5P 134
MOB1P 135
PROV5P 136-137
PROV1P 138-139;

Data Woman_2001_5year;
set Census2001;

if MOB5P=5 then migrant=1; else migrant=0;

if 18<=AGEP<=64;
if 18<=AGEP<=24 then AGEP=entry;
else if 25<=AGEP<=34 then AGEP=younger;
else if 35<=AGEP<=44 then AGEP=prime-younger;
else if 45<=AGEP<=54 then AGEP=prime-older;
else if 55<=AGEP<=64 then AGEP=older;

proc means; var AGEP ; by migrant;

结果在log里面显示

NOTE: Variable entry is uninitialized.
NOTE: Variable younger is uninitialized.
NOTE: Variable prime is uninitialized.
NOTE: Variable older is uninitialized.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
66850 at 192:32 59135 at 193:32
请问各位大虾,我的问题出在哪里,感谢了

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Migrant Census infile Grant lrecl 大虾

你是不是想对新的变量AGEP根据年龄情况依次赋值entry之类的，这是你要加上引号，表示是字符类型的值。if 18<=AGEP<=24 then AGEP='entry';其它都要加上引号，不然SAS会把entry等做为一个变量来处理，在你的数据集中没定义这几个变量，因此会出现变量没初始化的提示。这是个人看法

二楼找对了问题所在之处，但是方法不可行。即便是加上引号也没有用的，因为你把一个字符常值赋给一个数值变量，系统会自动把字符值转换为数值值，而‘entry’之类无法正常转换，故还是会出现错误

谢谢各位热心指教啊.小弟我学习sas才几天,所以比较基本问题都没搞好,现在已经解决了.除了对entry加引号外,还需要对AGEP这个变量名称进行改变,改变为AGEP1或者其他什么的，因为AGEP前面已经定义了数字,后面又定义成字符串sas就无法识别了.

另外一个比较奇怪的问题是，sas似乎无法识别比较长的字符串，除非你在后面用lable进行定义，否则它好象把我的prime-younger和prime-older合并为一个prime了，我只好从新定义为a１和a2它才能正确处理．

好像都没加上$这个符号啊！

Data Census2001;
infile 'indiv-ver2-050824.dat' lrecl=266;
input PROVP 1-2
AGEP 39-40

MOB5P 134
MOB1P 135
PROV5P 136-137
PROV1P 138-139;

run;

Data Woman_2001_5year;
set Census2001;

length agep_CLASS $ 13;

if MOB5P=5 then migrant=1; else migrant=0;

if 18<=AGEP<=24 then AGEP_CLASS='entry';
else if 25<=AGEP<=34 then AGEP_CLASS='younger';
else if 35<=AGEP<=44 then AGEP_CLASS='prime-younger';
else if 45<=AGEP<=54 then AGEP_CLASS='prime-older';
else if 55<=AGEP<=64 then AGEP_CALSS='older';

if 18<=AGEP<=64;

run;

proc means data=Woman_2001_5year;

class migrant;
var AGEP ;

run;

proc means data=Woman_2001_5year;

class AGEP_CLASS;
var AGEP ;

run;

***Note: stonetj is right. Use ' ' to assign character values to your new variable AGEP_CLASS. Use the maximum length for your AGEP_CLASS, length AGEP_CLASS $13;

One more thing, if you want to calculate the mean of AGEP, use class statement instead of by statement. If you want to use by statement, you have to sort your data by migrant first before you are using proc means.;

[此贴子已经被作者于2007-4-24 5:28:06编辑过]

在这个步骤中系统无法正常转换字符，会出现错误,另外变量名称也要改变