Date: Tue, 11 Jul 2000 16:12:07 PDT
Reply-To: Toni Zhang <thesis8@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Toni Zhang <thesis8@HOTMAIL.COM>
Subject: Three questions
Content-Type: text/plain; format=flowed
Only three questions:
1. If ACCESS reads Excel file/data? If it reads SAS data?
2. If yes to 1, if ACCESS can transpose data when it inports Excel/SAS data
3. I need to change the data shape in SAS from the data1 to data2 below:
Data1:
Person QNumber Var1 Var2 Var3...Var345 Recode1 Recode2...Recode8
0001 00081 430 453 124 786 883 306 577
0001 00081 410 467 208 689 799 254 579
0001 00082 399 454 199 745 802 278 564
0002 00074 403 452 121 787 803 307 597
0002 00074 414 460 201 678 778 257 598
0002 00077 382 451 196 765 810 279 563
...
Data2: (Basicly is a transposed data of data1 except for variables 'person'
and 'QNumber')
Person QNumber Variable
0001 00081 453 (Var2)
0001 00081 124 (Var3)
0001 00081 ...
0001 00081 786 (Var345)
0001 00081 886 (Recode1)
0001 00081 306 (Recode2)
0001 00081 ...
0001 00081 577 (Recode8)
0001 00081 410 (Var2)
0001 00081 467 (Var2)
0001 00081 208 (Var3)
0001 00081 ...
0001 00081 689 (Var345)
0001 00081 799 (Recode1)
0001 00081 254 (Recode2)
0001 00081 ...
0001 00081 579 (Recode8)
0001 00082 399 (Var1)
0001 00082 454 (Var2)
0001 00082 199 (Var3)
0001 00082 ...
0001 00082 745 (Var345)
0001 00082 802 (Recode1)
0001 00082 278 (Recode2)
0001 00082 ...
0001 00082 564 (Recode8)
0002 00074
0002 00074
0002 00074
....
Please advise how to do this. Tonnie
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
