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
|> 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
|> 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
|> 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
|> 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.***