Losing Labels and Formats when Connecting to Database (DB2)

craig159753 — Wed, 09 Sep 2020 10:26:01 GMT

I am connecting a database using the LIBNAME statement, everything is working however it seems I am losing the labels and formats.

libname mylib db2 schema=myschema user=myusername using=mypassword;

Any idea?

Re: Losing Labels and Formats when Connecting to Database (DB2)

Tom — Wed, 09 Sep 2020 11:52:47 GMT

Are you reading from the remote DB2 database? Or writing to it?

LABELS and FORMATS are SAS concepts so there is no place in the remote database for SAS to store that information. If they are important to you then add them back. Perhaps by creating a view?

libname mylib db2 .... ;
proc sql;
  create myview as 
     select a.myvar label='My Label' format=myfmt. 
     from mylib.mytable a
  ;
quit;

topic Losing Labels and Formats when Connecting to Database (DB2) in SAS Programming

Losing Labels and Formats when Connecting to Database (DB2)

Re: Losing Labels and Formats when Connecting to Database (DB2)