SUPPORT / SAMPLES & SAS NOTES
Problem Note 66644: The DBSASLABEL=DBMS data set option does not generate column labels from column names when you use it with SAP HANA tables
 |  |  |  |  |
The DBSASLABEL=DBMS data set option does not generate column labels from the column names when you use it with SAP HANA tables.
For example, you encounter the issue if you run code similar to the following:
libname hanalib saphana dsn=hnatest user=myusr1 password=mypwd1;
proc sql;
create table work.hasLabels as
select * from hanalib.hasHanaLabels(dbsaslabel=DBMS);
quit;
proc sql;
create table work.hasLabels as
select * from hanalib.hasHanaLabels(dbsaslabel=DBMS);
quit;
proc contents data=work.hasLabels;
run;
run;
If you run this code and your SAP HANA table has labels, the hasLabels SAS data set should have labels. Instead, the hasLabels data set returns the column name as a label, not as an actual database label.
To obtain a fix for this issue, contact SAS Technical Support.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to SAP HANA | Linux for x64 | V.03.04 | 2020.1.1 | Viya | Viya |
| Microsoft® Windows® for x64 | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
| 64-bit Enabled AIX | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
| 64-bit Enabled Solaris | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
| HP-UX IPF | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
| Solaris for x64 | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||