Prev: data step
Next: How to display grid?
From: SAS Swamy on 22 Dec 2009 18:08
Hello everyone ,
This is a data load question , please help.

I have a .xls spread sheet with several tabs , each sheet with data to be
loaded for different data sets.

Step 1 : I converted each sheet to a tab delimited text file.

When I tired to use the Import , it works fine , but the Issue is for some
of the Character fields ,by default it makes as Number , for e-g , an
code field have data like 12334 , 12312 , 54543 …etc , but originally it
is a character (6) data type ($6.)
Do I need to use INPUT ? , In that case I need to go with the actual
position of each field , In that case can I be able to use the Tab
delimited file ? , there is a possibility for some of the fields coming as
blank/null.
I hope I explained it well � Please let me know If I have to more clear.
Sample data set from the spread sheet :

ID EDATE CODE FLAG SET LOCATION
TEST1 10/02/2009 37732 Y AC FACILITY00139
TEST2 10/03/2009 37731 Y JM FACILITY00140
TEST3 10/04/2009 37732 Y FACILITY00141
TEST4 09/21/2008 5191 Y ED ACILITY00002

Thanks,
- Swamy
 | 
Pages: 1
Prev: data step
Next: How to display grid?