a********a
发帖数: 3176 | 1 I created multiple datasets that looks like:
var min max
wage1 XXX xxx
wage2 xxx xxx
wage3 xxx xxx
wage4 xxx xxx
wage5 . .
or
var min max
wage1 XXX xxx
wage2 xxx xxx
wage3 xxx xxx
wage4 . .
wage5 . .
The problem is that I need to create labels for each category that is min-
max, but for the top cat. it should be 'min or more'. So the final should
be:
var min max label
wage1 xxx xxx xxx - xxx
wage2 xxx xxx x |
q**j
发帖数: 10612 | 2 read proc format.
【在 a********a 的大作中提到】
: I created multiple datasets that looks like:
: var min max
: wage1 XXX xxx
: wage2 xxx xxx
: wage3 xxx xxx
: wage4 xxx xxx
: wage5 . .
: or
: var min max
: wage1 XXX xxx
|
a********a
发帖数: 3176 | 3 Thanks - but doesn't PROC FORMAT need one to specify the value? Could you
please be specific? I have a lot of files and each file may have different
number of categories, and the categries are defined differently for each file. But I'm writing a macro to process them all. So I may need something like
if MAXCAT=1 then label ='xxx or more'.
How can I get there?
Also, can label from PROC FORMAT be outputted into a dataset?
【在 q**j 的大作中提到】
: read proc format.
|
I**A
发帖数: 96 | 4 How do you define 'top category' -- is it the last row before the rows that
have missing values? |
q**j
发帖数: 10612 | 5 sort your data by wage category and the last one is what you need.
file. But I'm writing a macro to process them all. So I may need something
like
【在 a********a 的大作中提到】
: Thanks - but doesn't PROC FORMAT need one to specify the value? Could you
: please be specific? I have a lot of files and each file may have different
: number of categories, and the categries are defined differently for each file. But I'm writing a macro to process them all. So I may need something like
: if MAXCAT=1 then label ='xxx or more'.
: How can I get there?
: Also, can label from PROC FORMAT be outputted into a dataset?
|
