topic Re: how to fix Missing Variables in PROC CONTENTS? in SAS Programming

how to fix Missing Variables in PROC CONTENTS?

bhr-q — Sat, 30 Nov 2024 20:50:21 GMT

Hello all,

I ran the following code to import an Excel sheet, but PROC CONTENTS only displays two variables, even though the sheet contains 12 variables. Could you please help me to fix that?

all is fine; there is no error, and I can see all the data with the proc print; the issue is only proc contents that show two variables.

PROC IMPORT 
    DATAFILE="\\FS12000\USR-SPC\by\Desktop\Bita\Scoresheet.xlsx"
    OUT=work.AI_Derm
    DBMS=xlsx
    replace;
    SHEET="AI";
	getnames=yes;
RUN;
proc contents data=AI_Derm;
run;

Thanks

Re: how to fix Missing Variables in PROC CONTENTS?

Tom — Sat, 30 Nov 2024 21:01:04 GMT

What did the log say for each of your two steps? Did you get any errors or warnings or unexpected notes?

Why did you create a dataset named work.AI_Derm and then run PROC CONTENTS on AI_Derm? Normally those mean the same dataset, but they could mean two different datasets if you have USER library assigned.

Are you sure you are looking at the same XLSX file as SAS is reading from?

Re: how to fix Missing Variables in PROC CONTENTS?

bhr-q — Sat, 30 Nov 2024 21:08:39 GMT

I am sorry, that is weird; now it works; sorry again, I was in a rush.

Thanks a lot for your answer,

Re: how to fix Missing Variables in PROC CONTENTS?

mkeintz — Sun, 01 Dec 2024 03:10:23 GMT

@bhr-q wrote:

I am sorry, that is weird; now it works; sorry again, I was in a rush.

Thanks a lot for your answer,

That's ok. But mark your comment as the "solution", so that folks looking for unsolved topics don't needlessly review this one.