SAS:宏生成数据驱动的子集数据文件 [英] SAS: macro generating data driven subset data files
本文介绍了SAS:宏生成数据驱动的子集数据文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
使用 SAS 宏,我想使用数据驱动方法生成文件子集.有人可以指导我从哪里开始吗?例如,我有一个如下所示的数据集:
Using SAS macro, I would like to generate subset of files using data driven method. Can someone direct me where to start? For example, I have a data set like following:
data student;
var v1 $ v2 $ v3;
datalines ;
f j 20
f j 20
f j 22
f s 18
f s 18
m j 19
m j 19
m s 20;
我希望 SAS 宏识别变量中的每个值并生成数据子集,而不是对每个变量类别使用if"语句.我是否需要查看循环函数或符号(在制作 proc freq 之后)?谢谢你,KKK
Instead of using 'if' statement for each variable category, I want SAS macro recognize each value in variables and make subsets of data. Do I need to look into loop function or symput (after making proc freq)? thank you, KKK
推荐答案
这是一种相当直接的方法:
This is one fairly straight forward way:
data student;
input v1 $ v2 $ v3;
cards ;
f j 20
f j 20
f j 22
f s 18
f s 18
m j 19
m j 19
m s 20
;
run;
%macro make_dsns;
proc sql;
create table dsn_list as
select distinct
v1,
v2,
v3
from student
;
run;
data _null_;
retain count 0;
set dsn_list end=last;
count = count + 1;
dsn_name = trim(left(v1)) || trim(left(v2)) || trim(left(v3));
dsn_reference = "dsn" || trim(left(count));
call symput(dsn_reference , dsn_name);
if last then do;
call symput("max_count" , count);
end;
run;
data
%do count = 1 %to &max_count;
&&dsn&count
%end;
;
set student;
drop reference;
reference = trim(left(v1)) || trim(left(v2)) || trim(left(v3));
%do count = 1 %to &max_count;
if trim(left(reference)) eq trim(left("&&dsn&count")) then output &&dsn&count;
%end;
run;
%mend make_dsns;
%make_dsns;
这篇关于SAS:宏生成数据驱动的子集数据文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文