Hi ,   I am using   proc sql; create table pp as   select substr(cc,2,2) as yy,        code from bb order by code ,cc ; quit;   And i get below warning what should i do if i dont want to get this message . Can anyone help   NOTE: The query as specified involves ordering by an item that doesn't appear in its SELECT clause. ODBC: AUTOCOMMIT is NO for connection 6 SAS_SQL:  Unable to convert the query to a DBMS specific SQL statement due to an error. ACCESS ENGINE:  SQL statement was not passed to the DBMS, SAS will do the processing. SAS_SQL:  Unable to convert the query to a DBMS specific SQL statement due to an error. ACCESS ENGINE:  SQL statement was not passed to the DBMS, SAS will do the processing. ODBC: AUTOCOMMIT turned ON for connection id 6 ... View more

Hi , I have a dataset like which is shown below . I need to check within the same item group whether the item values differ for item number . I need to write an automated code . Can anyone help me   Itemgroup Item_number item value 5 1 1.043 5 1 0.875 5 2 0.936 5 2 0.567 6 1 1.567 6 1 1.258 6 2 1.567 6 2 1.258     Thanks ... View more

Hi , i have this dataset and i have written a macro to validate its pulling what is in excel Item Item Name Books A01 Books A22 Books A23 Books B01 Books C25 Books C03 Books C45 Books C46   %macro price; proc sql; select ('Item Name'n) into :iname separated by "*" from x quit; % put &iname;   %do y=1 to 8; %let xz=%scan(&iname,&y,*);   %put &xz;   proc sql; create table zz (  ffnam char 4 ); quit;   proc sql; insert into zz values ("&xz"); quit; %end; %mend; %price;   % put &iname resolves to  A01*A22*A23*B01*C25*C03*C45*C46;   HOW DO I TEST THIS HAS GIVEN ALL RESULTS OF TEM NAME FROM MY DATASET ?   % PUT  &XZ RESOLVES TO A01 when y=1 so i am inserting each value of &xz into zz but when i open zz dataset i see only C46 how to get all values  of  A01 TO C46 into zz dataset ?   Can anyone pls help me ?     ... View more