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
... View more