topic Re: proc import in SAS Enterprise Guide

proc import

Daily1 — Wed, 08 Jun 2022 13:01:57 GMT

proc import out= df
    datafile = 'df.xlsx'
    dbms = xlsx 
	replace;
    getnames=no;
	datarow=2;
run;

Excel file

my varibles names not properly display

column name is epd year vc code

Re: proc import

PaigeMiller — Wed, 08 Jun 2022 11:37:19 GMT

Can you show us the results as seen in SAS (not Excel)?

Can you show us the PROC IMPORT code you used?

Also, can you explain in more detail what is wrong?

Re: proc import

Daily1 — Wed, 08 Jun 2022 12:11:48 GMT

SAS output

epd year vc code is my column name i want

Re: proc import

PaigeMiller — Wed, 08 Jun 2022 12:14:37 GMT

@Daily1 wrote:

SAS output

epd year vc code is my column name i want

I don't understand what the problem is. Your variable names shown are epd year vc code. Please explain further.

Re: proc import

Daily1 — Wed, 08 Jun 2022 12:22:05 GMT

brother just i want this type of output

Re: proc import

PaigeMiller — Wed, 08 Jun 2022 12:34:13 GMT

I'm not understanding. You need to EXPLAIN. Do not write one brief sentence that repeats what you have already said; you need to provide new information, explaining what you want in detail so I can understand what the issue is. At no point have you explained your problem with the variable names.

Re: proc import

Tom — Wed, 08 Jun 2022 13:06:51 GMT

Your data starts in A2 instead of A1. You need to tell PROC IMPORT to do the same.

proc import out= df replace
    datafile = 'df.xlsx' dbms = xlsx 
;
  range='$A2:';
run;

Re: proc import

Kurt_Bremser — Wed, 08 Jun 2022 13:40:34 GMT

Two issues:

Your column names are in row 2, so you must use a range (see @Tom 's post). Alernatively, you can remove row 1 from the spreadsheet before importing it.

And your GETNAMES=NO statement explicitly prevents SAS from retrieving the variable names from the spreadsheet, so don't be surprised when SAS does what it is told to do.

Re: proc import

Daily1 — Thu, 09 Jun 2022 12:24:47 GMT

%macro pim(sheet);
proc import out= df.&sheet replace
datafile = 'df.xlsx' dbms = xlsx ;
range='&sheet$A2:';
run;
%mend pim;
%pim(A);

A is a sheet1 name

SAS log error

Couldn't find sheet in spreadsheet
Requested Input File Is Invalid
ERROR: Import unsuccessful. See SAS Log for details.

how to import multiple sheets using Proc Import.

Re: proc import

Kurt_Bremser — Thu, 09 Jun 2022 09:56:22 GMT

Single quotes prevent macro variables from being resolved.

And this can not work:

out= df_'&sheet'

Dataset names must not contain quotes.