BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

I am a novice in SAS. Pardon me if I sound silly.

I have a large data in excel. I tried to import the data from excel to SAS using import wizard. In my import wizard under 'select a data source from the list below' I see only three options-CSV, txt and delimited. Why I am not seeing an option for excel data?

How can I convert the data into CSV? When I googled, I got some option to download a software tool for this conversion. Is it recommended?

I even tried to save the data in CSV by chaging the file extn from .xls to CSV. But SAS says 'import cancelled ....No data values in the first five lines'.

What should I do to successfully get the data into SAS?

Thank you very much in advance.

Cathy
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi:
If you only see those 3 options in the IMPORT Wizard, it means that you do NOT have SAS/Access for PC File Formats (PCFF) licensed.

The choice in the IMPORT Wizard needs to correspond to the type of data file you want to import. First, you should check with your company SAS representative to find out whether they have a license for SAS/Access PCFF and they just need to install it.

If they do NOT have PCFF, then you will need to
1) close the IMPORT wizard
2) switch over to Excel and SAVE the Excel file as a CSV, by choosing CSV in the Save AS Type in the Excel File--> Save As window.
3) Once you have saved the file as a CSV file (using Excel), then go back to the IMPORT wizard and select CSV from the drop-down choices. You should not need to download any software to convert the XLS file to CSV -- Excel has that capability built in.
4) point your wizard to the CSV version of the data (NOT the XLS version of the data)
5) The import should work for you -- the key is using Excel to save the data in the spreadsheet as a CSV file -- and then importing the CSV file into SAS.

If you need more help with this, your best bet is to contact Tech Support.

cynthia
deleted_user
Not applicable
Thank you very much for your response. Saving the excel file in CSV format worked well for me.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 2 replies
  • 927 views
  • 0 likes
  • 2 in conversation