Thanks very much, Ballardw and Paige. ... View more

Thanks very much! ... View more

Okay, never mind any more. I figured it out. I don't need any more responses. ... View more

Thanks for explaining, nicely. ... View more

Please keep in mind, as I mentioned in my original post, there are about 30 columns, and so it seems not very efficient to list each column and what I want in each column. If the data had fewer columns that might work, but for data with many columns, listing the desired value in each column doesn't seem very useful. ... View more

Usually if i put data into text, the columns get all messed up and people can't read the data set in a post using text. But here goes.   Original data set         RowNum Geography Group Sub-Group Measure Footnote1 Parents PeerGroup 1 NK Hair Long 18 Inches Same Different 2 NK Hair Short 1 Inches Different Same 3 NK Eyes Brown 1 1=Brown, 2=Blue,3=Green,4=Combo Same Same 4 NK Eyes Blue 2 1=Brown, 2=Blue,3=Green,4=Combo Same Different 5 NK Eyes Green 3 1=Brown, 2=Blue,3=Green,4=Combo Different Different 6 NK Height Above 6.2 Feet Different Same 7 NK Height Below 5.7 Feet Same Different 8 NK Height Average 5.8 Feet NA Same                 I want to add these rows         9 NK Hair None 0 Inches Different Same 10 NK Eyes BlueGreen 4 1=Brown, 2=Blue,3=Green Same Different   ... View more

Interesting that two people say they won't open excel files. On the community support website for tableau, most people say they won't help you unless you include a tableau file they can download, along with data. ... View more

Hi  I was getting 0 rows of output until i put in the var line, so that looks right. Thanks ... View more

I usually don't include in my posts because they often don't show up the way I have them, but here goes. This is the wide version   County group indicator city burbs rural Total Albany capital wijits 87 45 23 40 Da Bronx NYC wijits 23 54 32 47 Albany Capital thingies 12 18 13 15 Da Bronx NYC thingies 15 10 15 12     I want to change it to this long version   County group indicator location value Albany capital wijits city 87 Albany capital wijits burbs 45 Albany capital wijits rural 23 Albany capital wijits total 40 Da Bronx NYC wijits city 23 Da Bronx NYC wijits burbs 54 Da Bronx NYC wijits rural 32 Da Bronx NYC wijits total 47 Albany Capital thingies city 12 Albany Capital thingies burbs 18 Albany Capital thingies rural 13 Albany Capital thingies total 15 Da Bronx NYC thingies city 15 Da Bronx NYC thingies burbs 10 Da Bronx NYC thingies rural 15 Da Bronx NYC thingies total 12 ... View more

Hi Reeza. Thanks for responding. What would I do, in SAS, to change the wide data set into the long data set. You mean something like this?   proc transpose data=testwide out=testlong; by county group indicator; run;   thanks   ... View more

Hi Tom again. Yes, I attached an excel instead of csv. Oops. Sorry. ... View more

Hi Tom. Thanks for your response. I think that does it. ... View more