We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Import Excel Cross Tab table into SAS

SASEPI
SASEPI asked
on
Medium Priority
445 Views
Last Modified: 2014-05-05
Is there a way to import an Excel Cross tab table into SAS without having to reformat it to the SAS format first
                                  Race
Excel                        White   Hispanic   Asian
Age Cat  00-01y    524       845        123
               01-04y    1000     2501       456
               05-14y     895      2512       561

Procedure to manually enter into SAS-I want to avoid this        
input Age $ Race $  Pop $;
datalines;
00-01y  White       524  
00-01y  Hispanic   845
00-01y  Asian       123
....etc.
Comment
Watch Question

Database Marketing Consultant
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks d507201,

I was able to import it, however, I actually want to merge this dataset with another dataset by age category and race.  I need to do this so I can use the population variable in a calculation. Therefore, I need to assign a race  to each value, (as below) right? or is there a way to do this from the cross tab table;or is there an easy way to convert the cross tab table to the format below.  Thank you.
age cat   race        population
00-01y  White       524  
00-01y  Hispanic   845
00-01y  Asian       123
d507201Database Marketing Consultant
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.