如果通过proc sql 得到grp format前的值

sample.rar (820 Bytes) 本附件包括：

• sample.sas7bdat

2013-12-15 05:58:04 上传

不对数据集进行修改，如果通过proc sql 得到grp format前的值？ sql中是否有选项？
proc sql noprint;
   select distinct grp into:colvalues separated by ' '
   from sample;
quit;

/*for your reference*/
proc format;
        value sex  1='f'
                   2='m';
run;

data a;
        format grp sex.;
        do grp=1 to 2;
                output;
        end;
run;

proc sql noprint;
   select distinct ogrp into:colvalues separated by ' '
   from(select distinct grp as ogrp format=1. from a);
quit;

%put &colvalues.;

Eternal0601 发表于 2013-12-15 06:17
/*for your reference*/
proc format;
        value sex  1='f'

如果是这样呢？
proc format;
        value $sex  "1"='f'
                       "2"='m';
run;

dxystata 发表于 2013-12-18 05:31
如果是这样呢？
proc format;
        value $sex  "1"='f'

把sql中相应的fomat=1改为format $1.就好的，匹配下

Eternal0601 发表于 2013-12-15 06:17
/*for your reference*/
proc format;
        value sex  1='f'

This is a wrong way to get complete list values from a format.

data a;
        format grp sex.;
        do grp=1 to 2;
                output;
        end;
run;

The right way is to use proc format with the cntlout option. See example below.

proc format;
        value sex  1='f'
                   2='m';
run;

proc format cntlout=sex;
run;

proc print data=sex;
run;

bobguy 发表于 2013-12-20 11:04
This is a wrong way to get complete list values from a format.

data a;

I get your point, and your method is to get complete list values from a format. And my method is just get the original value list for the variable in the dataset using the format. Thanks.