Hi guys, I know that when we use "proc append", the base always prevails. What if I want to suppress it? How can I do it? What I'm trying to do is: 1. read in hundreds of 'tsv' files  2. rename some columns  3. append those files to create a master file. I succeeded to read in all files but I ran into "type mismatch" error, specifically only for the numerical variables, when I tried to append those files.  I tried 1. FORCE option, 2. change the 'FORMAT',INFORMAT' to 'best 32.' in the 'DATA INFILE' step (my thinking for this is formatting the variables the same before appending them). The second helped some variables but I still have this error for other variables. Can anyone help?   I also have a super simple question. When we read in data to SAS, how does SAS decide the datatype for the variable if we use proc import? Does it depend on the first few observations(SAS will make a guess)? I know we can specify the data type using the data step. Another related question would be if the first few observations are numeric, what would happen if there's a character in the column? Would SAS still read it in as what it is or as '.' or sth else?   %macro import(dt); data work.test (where=(CUSIP ne '') ) ; %let _EFIERR_ = 0; infile "C:\Users\abc_&dt..tsv" delimiter='09'x MISSOVER DSD lrecl=32767 firstobs=2 ; informat DXL_Identifier best32. ; informat ISIN $12. ; informat SEDOL $7. ; informat CUSIP $9. ; informat Quick best32. ; informat Stock_Description $62. ; informat Market_Area__Country_level_ $14. ; informat Dvd_Req best32. ; informat Record_Type best32. ; informat Total_Demand_Value best32. ; informat Total_Demand_Quantity best32. ; format DXL_Identifier best12. ; format ISIN $12. ; format SEDOL $7. ; format CUSIP $9. ; format Quick best12. ; format Stock_Description $62. ; format Market_Area__Country_level_ $14. ; format Dvd_Req best12. ; format Record_Type best12. ; format Total_Demand_Value best12. ; format Total_Demand_Quantity best12. ; input DXL_Identifier ISIN $ SEDOL $ CUSIP $ Quick Stock_Description $ Market_Area__Country_level_ $ Dvd_Req Record_Type Total_Demand_Value Total_Demand_Quantity ; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ run; proc contents data=test; run; data test2( rename=(ISIN = ISIN)); attrib CUSIP format=$8. Date format=YYMMDDn8.; set test(where=(Record_Type eq 1)); CUSIP=substr(CUSIP,1,8); Year=substr("&dt",1,4); Month=substr("&dt",5,2); Day=substr("&dt",7,2); Year2=input(Year,4.); Month2=input(Month,2.); Day2=input(Day,2.); Date=mdy(Month2, Day2, Year2); drop Year Month Day Year2 Month2 Day2 Record_Type; run; proc contents data=test2; run; proc append data=test2 base=test3 force; run; %mend; ... View more

%macro clean(); %do i =1 %to 8; data d_clean&i; set dsn&i; %if _n_ = 1 %then %delete; %run; %end; %mend clean; %clean() I have a bunch of CSV files with similar names. After I read them in, I want to get rid of the second observations from those files. I wrote the macro (pasted above, which was hoped to do the loop work pasted below) to do it. However, I didn't get my result. Can anybody help? data clean_1; set dsn1; if _n_ = 1 then delete;run; data clean_2; set dsn2; if _n_ = 1 then delete;run; data clean_3; set dsn3; if _n_ = 1 then delete;run; .....   Thanks, ... View more

PROC IMPORT DATAFILE= "C:\Users\x\Proj\Data\A Information Resource.xlsb" OUT= WORK.ALLTRACTS DBMS=Excel REPLACE; /*GETNAMES=YES;*/ SHEET = "1)LICs"; RUN; Hi there,    I'm trying to import an XLSB file using SAS 9.4. My code is posted above but the system gave the error:   ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ERROR: Connection Failed. See log for details.   Can anyone help?   Thanks! ... View more

Hi there,  I have 9 datasets which are quite big and I just want to keep some variables from those datasets. At last, I want to append/merge those 9 files to create a master file. What I have done so far is:   DATA TEST1; SET DSN1; KEEP &outcome_vars ;RUN; DATA TEST2; SET DSN2; KEEP &outcome_vars ;RUN; DATA TEST3; SET DSN3; KEEP &outcome_vars ;RUN; DATA TEST4; SET DSN4; KEEP &outcome_vars ;RUN; .....   As you can tell, it's very tedious. Is there a more efficient way?   Regarding append/merge, I'm thinking using: PROC APPEND BASE = TEST1 DATA = TEST2 OUT = TEST; RUN; PROC APPEND BASE = TEST1 DATA = TEST3 OUT = TEST; RUN; ...   OR data master; merge test1 test2 test3 test4; run; (I'm not sure if I can merge >2 files at once.)     Thanks, ... View more