Importing Excel into SAS and the MIXED= option
in [SAS]
|
From: Lou on 27 Jan 2010 21:04 Just want to point out that, if you change the guessing rows by changing a registry entry, the program may run on your machine, but if anyone else tries to run it, they'll have the same problem unless they've edited their registry as well. Also, the registry value will affect all software that accesses Excel data, so if you change it for this one program, it's probably a good idea to change it back when you're done. no new material below, included for reference only "Joe Matise" <snoopy369(a)GMAIL.COM> wrote in message news:b7a7fa631001271211u142a06c6k124cf548c2298658(a)mail.gmail.com... > MIXED just says if in the first X lines you see both, choose text. > > There is a registry setting you can change in your windows install that will > tell it to scan down further. Which setting depends on which version of SAS > you're running. You could also force the specific column to be CHAR (again > depending on which version of sas you're running, there are slightly > different answers here). > > -Joe > > On Wed, Jan 27, 2010 at 1:58 PM, Fowler, Ann < > Ann.Fowler(a)seattlechildrens.org> wrote: > > > Hi All, > > > > > > > > I have a very simple proc import program that reads in an Excel > > spreadsheet. The spreadsheet has 5 columns, 2 of which are lab values. > > Some of the lab values have a '>' symbol. However, when I use the > > MIXED=Yes option, the lab values were not saved as character variables > > in the SAS dataset and values with the '>' symbol were set to missing. > > The first record displaying the symbol is in line 15 and I assume that > > these 2 variables were created as numeric variables because SAS only > > scans the first 8 (?) lines before determining the format of the > > variable. Shouldn't the MIXED= option take care of this? > > > > > > > > Does anyone have any solution to this problem without 'touching' the > > Excel spreadsheet? I need to read in the spreadsheet as is. > > > > > > > > Any help will be much appreciated. > > > > > > > > Thanks. > > > > > > > > Ann > > > > > > > > Ann Fowler > > > > Clinical Data Coordinator III > > > > Cystic Fibrosis Therapeutics Development Network > > > > Coordinating Center > > > > Seattle Children's Research Institute > > > > 1100 Olive Way, Suite 500 > > > > Seattle, WA 98101 > > > > Ph: 206-884-7526 Fax: 206-987-7504 > > > > email:ann.fowler(a)seattlechildrens.org<email%3Aann.fowler(a)seattlechildrens.or g> > > > > > > > > > > > > CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is > > for the sole use of the intended recipient(s) and may contain confidential > > and privileged information protected by law. Any unauthorized review, use, > > disclosure or distribution is prohibited. If you are not the intended > > recipient, please contact the sender by reply e-mail and destroy all copies > > of the original message. > > |