Hi @EinarRoed   Are you using the DATASETS procedure with the APPEND statement?   BASE and DATA are both referencing data sets. The difference is that BASE is about the one "you want to add observations" to, where DATA references the "SAS data set containing observations that you want to append to the end of the SAS data set specified in the BASE= argument". You'll find further details about the APPEND statement from http://go.documentation.sas.com/?docsetId=proc&docsetTarget=n19kwc3onglzh2n1l2k4e39edv3x.htm&docsetVersion=9.4&locale=fr#n006mhcqbxpogvn1qrm9hjz77cf6   Hope that helps.   Cheers, Damo ... View more

Hi @fankaiqing   This is a known issue with the XLSX engine, reported to R&D. If you can't use @Reeza 's solution for now, a couple of other workarounds are:   - Use the EXCELCS engine. You may have to install SAS PC Files Server.   - Use the XLS engine (after you save your file to LOBOR_Map_samples.xls).   Hope that helps.   Cheers, Damo ... View more

Hi @rodrigo_pereira   Sorry but there isn't a way to change the 1,000 limit. But using an advanced filter might help you.   Below you'll find instructions I have stolen from a colleague (so I'm not taking credit for it). This example uses city names.   1.  From Explorer, click the error next to the filter heading and select new advanced filter:   2.  Use an IN filter.  When you select the items to include in the list, scroll all the way to the bottom and select "More Values...   3. You will notice here that again you are limited to 1,000 values:   Set conditions for the "Create search conditions to find and select values" to see values that are not listed.    For example in my case, maybe I want to add some cities that start with Z (and are thus not listed by default here).  I would do this:   It is more work on the user to create the filter but it will allow them to see all items.     Hope that helps.   Cheers, Damo ... View more