I am trying to merge 3 datasets that have independent IDs, but it only merge some observations instead of all of them  my code is as below and those datasets together should be above 4000 observations however, it only give me 2878 (as shown in the picture below from the log). does anyone knows what am I doing wrong?   DATA AUCTION.TRUCKS; MERGE AUCTION.CHEVROLET (IN=A) auction.dodge (IN=B) auction.ford (IN=C) ; BY LI_SALE_NUMBER; IF A OR B OR C; RUN;   ... View more

I am trying to export a table to excel, but I cannot get it work.  I get this error message  ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/D:\Users\Owner\Documents\Capstone Documentation\Item_Name.xlsx. My code is  ods excel file="D:\Users\Owner\Documents\Capstone Documentation\Item_Name.xlsx" ; proc FREQ data=auction.clean3 ; TABLE LI_ITEM_NAME; run; ods excel close;   ... View more

I Have data from a xls file that has a column with date as 20081113 where it is the year, month and day.  I want to change that date, but I keep getting either the wrong date, dots or stars. Following some answers in here I came out with this code, but I just get a dot   data auction.clean3; set auction.clean2; DATE= input(PUT(S_SALE_DATE, YYMMDDn8.),anydtdte8.); format DATE DATE10.; attrib C_BID_AMOUNT format=dollar14.2; DROP S_SALE_DATE; run;   could anyone help me on what could be wrong? ... View more