SAS-如何编码以前一组变量的数组

发布于 2025-01-29 01:17:57 字数 945 浏览 3 评论 0原文

我需要创建一个新变量，其中由数据集中的其他变量列表组成。

HAD1 (1=yes 2=no 9=unknown),
HAF10 (1=yes 2=no 9=unknown), 
HAC1C (1=yes 2=no 9=unknown), 
and HAC1D (1=yes 2=no 9=unknown)

增加个人有健康状况的数量。我还想将所有9个设置为“等于”。我的新变量将被命名为cc4，

CC4 = 

(0=no conditions, 
1=one condition, 
2=two conditions, 
3=three conditions, 
4=four conditions, 
.=any condition appears missing)

如何以正确的方式对其进行编码并将其添加到我的数据集中？

我只写了：

data dataset;
set dataset;

*use arrays to create clean, re-coded versions of variables;
array code1 [4] HAD1 HAF10 HAC1C HAC1D;
array code2 [4] diabetes hattack hfailure stroke;
do new= 1 to 4;

if code1 [new] = 1 then code2 [new] = 1;
*keep all 1's as 1's;

else if code1 [new] = 2 then code2 [new] = 2;
*keep all 2's as 2's;

else if code1 [new] = 9 then code2 [new] = .;
*make all 9's into .'s;

end;
drop new;

*create summation variable;
cc4=HAD1+HAF10+HAC1C+HAC1D;

原文

I need to create a new variable in which is comprised of a list of other variables found in my dataset.

HAD1 (1=yes 2=no 9=unknown),
HAF10 (1=yes 2=no 9=unknown), 
HAC1C (1=yes 2=no 9=unknown), 
and HAC1D (1=yes 2=no 9=unknown)

to add up the number of health conditions an individual has. I also want to set all 9 to equal "."
My new variable will be named CC4

CC4 = 

(0=no conditions, 
1=one condition, 
2=two conditions, 
3=three conditions, 
4=four conditions, 
.=any condition appears missing)

How do I code it in the correct way and add it to my dataset?

I only wrote this:

data dataset;
set dataset;

*use arrays to create clean, re-coded versions of variables;
array code1 [4] HAD1 HAF10 HAC1C HAC1D;
array code2 [4] diabetes hattack hfailure stroke;
do new= 1 to 4;

if code1 [new] = 1 then code2 [new] = 1;
*keep all 1's as 1's;

else if code1 [new] = 2 then code2 [new] = 2;
*keep all 2's as 2's;

else if code1 [new] = 9 then code2 [new] = .;
*make all 9's into .'s;

end;
drop new;

*create summation variable;
cc4=HAD1+HAF10+HAC1C+HAC1D;

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

你好，陌生人 2025-02-05 01:17:57

您无需重新计数。

您可以利用SAS评估boolean表达式为true 1，为false 0。

data want;
  set have;
  cc4 = (HAD1=1)+(HAF10=1)+(HAC1C=1)+(HAC1D=1);
run;

PS不要通过在数据和设置语句中使用相同的数据集名称来覆盖输入数据。这将使很难纠正编码错误。

You don't need to recode to count.

You can take advantage of SAS evaluating boolean expressions to 1 for TRUE and 0 for FALSE.

data want;
  set have;
  cc4 = (HAD1=1)+(HAF10=1)+(HAC1C=1)+(HAC1D=1);
run;

PS Do not overwrite your input data by using the same dataset name in the DATA and SET statements. It will make it hard to correct coding mistakes.

回复收藏 0 原文

山色无中 2025-02-05 01:17:57

如果您想要原始代码变量的新名称，请使用Rename
如果您想要新名称和原始代码变量，则可能不应该

在只需CC4结果时就不应该使用单个数字代码的事实来计算您的状况计数。

示例：

data have;
  do code1 = 1,2,9;
  do code2 = 1,2,9;
  do code3 = 1,2,9;
  do code4 = 1,2,9;
    output;
  end;end;end;end;
run;

data want;
  set have;
  codes = cats(code1,code2,code3,code4);
  drop codes;

  cc4 = ifn(index(codes,'9'),.,count(codes,'1'));
run;

在您的情况下

If you want new names for the original code variables, use RENAME
If you want new names and the original code variables, probably shouldn't

If you only want the cc4 result, you can use the fact of a single digit code for meaning to compute your condition count when all conditions assert a yes/no state.

Example:

data have;
  do code1 = 1,2,9;
  do code2 = 1,2,9;
  do code3 = 1,2,9;
  do code4 = 1,2,9;
    output;
  end;end;end;end;
run;

data want;
  set have;
  codes = cats(code1,code2,code3,code4);
  drop codes;

  cc4 = ifn(index(codes,'9'),.,count(codes,'1'));
run;

In your case replace code1,code2,code3,code4 with HAD1,HAF10,HAC1C,HAC1D

回复收藏 0 原文

~没有更多了~