topic Re: PROC import in SAS Programming

PROC import

Bhargav_Movva — Thu, 09 Mar 2017 17:43:09 GMT

Please post any example code for impoting XLSX type of file using Proc import syntax.

Re: PROC import

Reeza — Thu, 09 Mar 2017 18:00:08 GMT

proc import out=want datafile='/folders/myfolders/myfile.xlsx' dbms=xlsx replace; run;

Re: PROC import

Bhargav_Movva — Thu, 09 Mar 2017 18:04:59 GMT

Thanks for your reply...

Code i submitted--->

proc import
datafile="E:\SAS\SAS_Total\practice programs\proc_import.xlsx"
out=importingxl dbms=xlsx replace;
run;

log---->

proc import
datafile="E:\SAS\SAS_Total\practice programs\proc_import.xlsx"

out=importingxl dbms=xlsx replace;
ERROR: DBMS type XLSX not valid for import.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Can you please spot what's wrong

Re: PROC import

Reeza — Thu, 09 Mar 2017 18:07:16 GMT

What version of SAS do you have?

You may not have a license to import/export SAS files either, it requires SAS ACCESS to PCFILES I believe.

Try running the following to see if it lists SAS Access in the listing. If you post the output to here, make sure to remove your Site number.

proc setinit; run;

proc product_status; run;

Re: PROC import

Bhargav_Movva — Thu, 09 Mar 2017 18:11:57 GMT

Thanks!!!!

Re: PROC import

manish_1 — Sun, 02 Jul 2017 07:53:29 GMT

Hi,

I want to know that if i have data in excel file and i want to get only selected data out of it to make a dataset so can we use where statement in proc import. ?

if not then how can i import selected data out of excel file ?