Hello,          I used following code for appending multiple datasets in macro code %Do loop. Proc Append base= DataJoin data= ABC_join&i force; run;   where i = 1 to n  but I'm getting warnings like "Variable XYZ has different lengths on BASE and DATA files (BASE 16 DATA 15)."   I used force option. also used option varlenchk=nowarn; in code but still it is showing same warnings any other way is there to avoid these warnings?   Thanks. ... View more

Hi,     I want to connect with the MYSQL database from SAS Studio. I got the following Libname option:    libname mysqllib mysql user=myusr1 password=mypwd1 database=mysqldb server=mysrv1 port=9876;     at the SAS documentation but I need some other way to connect so I can avoid these passwords and other credentials to show in SAS code. Let me know if there is a way to do this in Base SAS Studio. ... View more