Importing Excel into SAS and the MIXED= option
in [SAS]
|
Prev: Extended staggered (ESN) designs for variance components
Next: Importing Excel into SAS and the MIXED= option
From: "Fowler, Ann" on 27 Jan 2010 14:58 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=3DYes 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=3D 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 = 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 re= cipient, please contact the sender by reply e-mail and destroy all copies o= f the original message. |