You can use the File Import node to import both .xls and .xlsx files into SAS Enterprise Miner. The latest documentation for this node is located at http://go.documentation.sas.com/?docsetId=emref&docsetTarget=p1rk96oj5sk2tyn1esay58oha0o3.htm&docsetVersion=14.3 and includes some information about common pitfalls that you might encounter. ... View more

You need to create a data set with the observation values. You can do that in multiple ways, but one would be to use a SAS code node in a data step.   data data2score; input ID $ var1-var5; cards; A 0 1 2 3 4 ; run;   ... View more