Hi all, I was sent an SPSS dataset which I converted to SAS dataset. Most of the SPSS variables had value labels; for example, for the Sex variable, it was coded as 1='Male" and 2='Female'. I was able to use the proc format to define all the value labels in SAS. My goal (i.e., my question) is to make the value labels become the value in the dataset. For example, instead of 1 and 2 (and the associated format) for Sex, I want the Sex (or a new variable based on Sex) to be Male and Female. The motivation of doing this is because some of the variables have a few thousand value labels and it's so much easier to just read what the true label of each value. Plus, I've to merge other variables from another dataset and that dataset only has the labels (not value). In other words, in the dataset that was imported from SPSS, Sex is 1='Male' and 2='Male'. The other dataset has Sex has 'Male' and 'Female'. Even though I used Sex as an example, I'll be merging the two dataset using variables that have thousands of value labels. Thanks for your assistance.
... View more