I'm copy/pasting a large dataset into Excel so I can use Tableau to make pretty graphics (boss's desire so no option here). For categorical ("string" or "abc" in Tableau parlance) variables, Tableau likes to work with the "labels" not the numeric values (unless you do some contorted "aliasing" stuff). I have some variables in the SAS data that are numeric but I've assigned labels via Proc format. But they don't show as labels in the data - they still show as just the original numerics. Again, I want the actual data to show the labels, not numbers, so I can cut/paste it that way. Is there an easy way to get the SAS data to show (I work in the Enterpise thingee) the labels instead of the original numeric values? That way I can just cut/paste into Excel. I suppose I could do a data step and force the same proc format statements through the "attrib" statement in the data step and create a new variable, but was hoping for an easier way since that entails cleaning up that "attrib if/then forest" code for 100's of lines. (p.s. To show values or value labels is a simple click of the mouse in SPSS. Why does SAS have to overcomplicate everything?!) Another thing I can't get SAS to do is output (in basic stuff like summary stats (proc means proc freq etc) both the variable values and their labels! Again, in SPSS that is a simple click in general defaults. I cannot find out how to do that simple thing in SAS - it wants to either spit out the values or if you throw in a format statement then it spits out the labels....BUT it won't do both values and labels (that I can tell). Any ideas? Ugh... I used to be an expert in SAS (I thought) - my dang dissertation was an IML program that ran for hours on end!! Now 20 years later after using SPSS, I'm being forced to use SAS again .... and guess what? I'm not liking SAS too much.... The simplest of things get so overcomplicated....frustrating. Oh well. Thanks, Frank
... View more