topic Datasets Labels gets missing after converted .XPT to SAS in SAS Procedures

Datasets Labels gets missing after converted .XPT to SAS

rohit_prajapati — Wed, 10 Jul 2013 07:53:23 GMT

When i am converting .XPT files to SAS datasets files datasets Labels gets missing. Kindly provide the resolution.

Note - Converting bunch of XPT files to SAS datasets through macro.

sandyming — Wed, 10 Jul 2013 13:13:31 GMT

if you used PROC COPY/CIMPORT, the label should still here.

If you used SET statement in the macro, then the label would be lost.

rohit_prajapati — Wed, 10 Jul 2013 14:04:37 GMT

Label was lost during PROC COPY also.... You can try

Tom — Wed, 10 Jul 2013 14:24:31 GMT

Check your macro. SAS is not doing it. Try this test to see for yourself.

filename out temp;

libname out xport ;

data out.class(label='My label'); set sashelp.class; run;

proc copy inlib=out outlib=work; run;

proc contents data=class;

run;

rohit_prajapati — Thu, 11 Jul 2013 13:16:32 GMT

Below is the macro code..........

/****** Macro to convert .XPT files to sas datasets *****************/

options mprint symbolgen mlogic;

/******************* Import domain sheet **************/

%MACRO DSAT(DOMAIN=);

proc import datafile = "...................../domains.xls" out=&DOMAIN
Replace
DBMS=xls;
getnames=yes;
run;

/********* Domains sheet contain list of the datasets i.e. ae, dm, ds, eg...... ***********/

PROC SQL;
SELECT COUNT(*) INTO :CNT FROM &DOMAIN;
QUIT;

%PUT &CNT.;

%let CNT = %EVAL(&CNT.);

PROC SQL;
SELECT DISTINCT DATASETS INTO: DATASETS1-:DATASETS&CNT FROM &DOMAIN;
QUIT;

%DO I=1 %TO &CNT;

LIBNAME DT XPORT "............./&&DATASETS&I...xpt"; /**** Path contain .XPT files which we mapped with Domains excel sheet ****/

PROC COPY IN = DT OUT=WORK;
RUN;

%END;

%MEND;
%DSAT(DOMAIN=domains);

/******** Excel data contains *******/

datasets
ae
cm
dm
ds
eg
ex

/************/

while generating the output.... For Some of the datasets the LABEL was lost in output.

Can you please let me know the resolution or any other ways to retain the LABEL.