@Tejaswini3 wrote:
When I open those individual dataset, am able to see the variable.
May be because of format issue, its not able to recognise
Your explanations are too brief to really understand what your issue is. You posted code that could successfully convert two XPT files into datasets. And convert the FORMATS dataset into a format catalog in the WORK directory. But then you also show code that is trying to reference some potentially unrelated datasets.
If you can see the variable then tells us how it is defined. What is the NAME of the variable? The TYPE? The storage LENGTH? Does it have a FORMAT attached? If so what format? Does it have a LABEL attached? If so what is the label?
The DMG dataset you created from the dmg.xpt file only has 14 variables. Just run PROC CONTENTS and show us the output from that. It should list each variable with its position number, name, type , length and if attached any format or label. It might also show if it has an informat attached, but for an existing dataset an informat does not really play much of a role.
Remember when pasting text like code or lines from the SAS log to paste them into the pop-up boxes that the forum editor will open when you click on the Insert Code or Insert SAS code button. That will prevent the forum from re-flowing the text as if it were paragraphs.
So here is basic code to convert DMG and FORMATS into a dataset and a catalog in that 04utility folder in your code.
options nofmterr;
%let path=D:\SAS\Project\Project 3- Interating Data for PKAnalysis\Project 3- Interating Data for PKAnalysis\Work;
libname utility "&path\04utility";
libname xptlib1 xport "&path\02data_raw\dmg.xpt";
libname xptlib2 xport "&path\02data_raw\formats.xpt";
proc format fmtlib cntlin=xptlib2.formats lib=utility ;
run;
proc copy inlib=xptlib1 outlib=utility;
run;
To tell SAS to use that formats catalog you can add it to the search path used by using the APPEND option like this:
options append=(fmtsearch=(utility.formats));
Now you can run code to look at the DMG dataset. Since it is small I would would just print the whole thing. I would print it twice, once using the formats and once without the formats.
proc print data=utility.dmg;
title 'formatted values';
run;
proc print data=utility.dmg;
format _all_ ;
title 'unformatted values';
run;
title;
