Date:         Mon, 1 Apr 1996 22:08:20 GMT
Reply-To:     Mike Harris <mikeh@AMGEN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Mike Harris <mikeh@AMGEN.COM>
Organization: Amgen Inc.
Subject:      Re: data from Excel to SAS

In article <199603290450.WAA05973@bella.biostat.wisc.edu>, Shu-Tien Chen
<shu@BIOSTAT.WISC.EDU> writes:
|> Hello,
|>
|> I tried to import a data from Excel to SAS by using "cut and paste" mathod.
|>  However, the editor of SAS only allow a limited number of letters in one
line.
|>  Therefore, the data after I pasted into SAS, it looks like :
|>
|> 1110 1289 987 988 1000 1287 1345 1121 1332 1212 1111 1112 1090 1009 1030
1023
|>  1223
|> 1221 1234 1234 ......
|>
|> I go the out put observation value like :
|>
|> VAR16  VAR17 VAR18 VAR19
|> 1023    12    23    1221
|>
|> All my observation value have at least 3 digital numbers.  I have no idea
how to
|>  solve this problem.  Hope someone can give me a hint.  Thanks.
 
Consider using Dynamic Data Exchange (DDE) instead of cut-and-paste.
*** Disclaimer: These are the opinions of the poster not Amgen Inc.***