Having problem with proc import

SAS_Beginner — Fri, 22 May 2009 15:37:15 GMT

Hi,

I am a beginner with SAS and my knowledge is limited.

I have got a fairly simple data in excel file. It has got quite a few missing values and blank cells.

There are 5 variables. Each variable has 5 reading. In excel, it is in a format of 5X5 table.
One of the variable starts with a blank cell(no text in the cell) and the other with missing value (by missing value, I mean a '.')

I have used proc import to read in this data from excel to sas.

The problem I faced was that SAS didn't read 1st and last values of Variable B. Varible B was like this:

B

1
.
.
.
6

Then I tried 'Mixed=Yes' option in proc import, it read in all the values for Variable B, but when I looked it in the viewtable, the values for B, C , D and E are left-aligned i.e. SAS has read it as a text variable, but it was a number variable.

I am sheerly confused now!

Can anyone help me out please?

Thanks in advance
SAS_Beginner

Re: Having problem with proc import

sbb — Mon, 25 May 2009 16:01:42 GMT

For assistance, you will need to reply to your post providing SAS log output with the SAS-generated DATA step code from the PROC IMPORT (pasted in your reply from your SAS session log). Adding a simple PROC CONTENTS; RUN; after the import code would also help, and activating the SAS OPTIONS setting SOURCE is important to generate as much SAS log diagnostics as possible.

Scott Barry
SBBWorks, Inc.

topic Having problem with proc import in SAS Programming

Having problem with proc import

Re: Having problem with proc import