extracting labels from older version of DATASET to add to new version. 1

[raleighlinda]

Help! I need to export the labels from one SAS data set and import them into another SAS data set with the same data structure and column names. Our DBMS is Oracle but we ship it out in SAS datasets.

This seems like it might be a common chore. My apologies. I'm new to SAS and working under a tight deadline

 

[ChrisW75]

Try this for starters:-

proc sql;
  create table labels as
  select *
  from dictionary.columns
  where memname = "YOURDATASETNAME"
   ;
quit;

One of the columns will be the label of the fields, there's also a column for the library to narrow down your selection if necessary. You can then use this programmatically to create label statements, then %include them to run them...
Let me know if you need further help, I'm in a training course at the moment so can't research further today.


Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.