DATA Step, Macro, Functions and more

SAS Base Certification

Occasional Contributor
Posts: 7

SAS Base Certification

Hi all,


Hope you had a lovely festive season.

I am studying for the Base programming certification exam and was wondering if 

we need to know all the differences between the SAS / Access engines?


  • EXCEL engine
  • XLSX


Are all the differences and nuances between them examinable?


Thank you very much, appreciate the help!



Super User
Posts: 23,224

Re: SAS Base Certification

Posted in reply to Bhagya_raj

It’s not listed in the topics covered at all.


Basically, they are older to newer developments, as Excel changed, SAS had to modify how to read and write Excel files. 


Excel is is used for older Excel files, xls. 

PCFILES is for when your version of SAS and Excel differ, ie 64 bit SAS and 32 bit Excel 

XLSX is the newest option to create and read XLSX files. It’s designed to work on Unix SAS well. 

Occasional Contributor
Posts: 7

Re: SAS Base Certification

Thank you for replying Reeza, that's really helpful!


Appreciate the help Smiley Happy

Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation