topic Re: MIXED='YES' option works fine in SAS93 BUT not in SAS94 Environment in SAS Programming

MIXED='YES' option works fine in SAS93 BUT not in SAS94 Environment

JJP1 — Fri, 30 Jul 2021 09:03:42 GMT

Hi,

Iam trying to run the below code in SAS 94 region but getting falied. but successfully executing in SAS93 environmnet. please help for any options/suggestions ?

PROC IMPORT datafile="/fff/cccv/cc/Cdfffd.xlsx"  
dbms=xlsx out=temp REPLACE;
	sheet=excel;
GETNAMES=YES;
MIXED=YES;

RUN;

NOTE: The previous statement has been deleted.
30 sheet=excel;
31 GETNAMES=YES;
32 MIXED=YES;
_____
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: MIXED='YES' option works fine in SAS93 BUT not in SAS94 Environment

Ksharp — Fri, 30 Jul 2021 12:20:41 GMT

MIXED=YES; is obsolete for XLSX enginge.
Just remove it if you are using dbms=xlsx .

Re: MIXED='YES' option works fine in SAS93 BUT not in SAS94 Environment

JJP1 — Mon, 02 Aug 2021 12:08:47 GMT

Thanks @Ksharp , Yes i am using xlsx engine only.