如果变量没有变量标签，如何得到空呢？

data aaa;
label x="xx";
input x y;
cards;
1 2
1 2
;
run;

data _null_;
        if 0 then set aaa;
        call symput ('label1', Vlabel(x));
        call symput ('label2', Vlabel(y));
run;

%put &label1;
%put &label2;

y变量标签为空，但label2解析出来为y，如何得到label2为空呢？谢谢！

Instead of using vlabel() function, you can use the output dataset from proc contents. JingJu

Or get information from sashelp.vcolumn:
proc sql noprint;
   select label into :label1 from sashelp.vcolumn where libname='WORK' & memname='AAA' & upcase(name)='X';
   select label into :label2 from sashelp.vcolumn where libname='WORK' & memname='AAA' & upcase(name)='Y';
quit;

Please try the following code:

%let dsid=%sysfunc(open(aaa,i));
%let label1 = %sysfunc(varlabel(&dsid.,1));
%let label2 = %sysfunc(varlabel(&dsid.,2));

%put +++&label1++;
%put +++&label2++;

wpfwxn 发表于 2015-2-28 10:03
Please try the following code:

%let dsid=%sysfunc(open(aaa,i));

thanks. Good point. 京剧