01-28-2015 10:53 AM
I directly import xls files into SAS. One in particular contains three columns, two of which contain numerous results in the format or 0.000005. SAS is using scientific notation to represent 0.000005 as 5E-6 and others such as 0.000003 as 3E-6. I have tried using the following
proc print data=file;
format x 7.;
This is not working. Can anybody help me please? Thank you for your time.
01-28-2015 11:24 AM
What are the ranges of your numbers? You need to specify a format that will allow sufficient print positions for the smallest number you hope to print. E-6 means decimals so 7. doesn't do much as it says 7 positions of the integer persuasion.
I'd try format 12.8 as a start.
01-29-2015 03:44 AM
Okay so after my proc import statement;
proc import DATAFILE= 'file.xls'
DBMS = xls
Then I have;
proc print data=proborig;
format x 12.9;
and an example of some data lines as a result of this are;
The columns are observation, animal, ancestor and founder respectively.
Thanks again for the help
01-30-2015 04:29 AM
I reassigned the variables to BEST32. with the following code;
newAnimal = input(Animal, BEST32.);
The results of the proc content are;