Associate data.xpt and formats.xpf from Stata into SAS

Miracle — Tue, 17 May 2016 02:24:27 GMT

Hi there.

May I please ask how can I associate the format.xpf with the SAS data. I have two files generated from Stata fdasave command i.e. data.xpt and formats.xpf.

In order to browse the SAS data after the first proc copy, I needed to supress the formats in the datastep.

The second 'proc copy' only creates a SAS dataset with variable FMNTNAME, START and LABEL.

Your help is much appreciated.

libname sasfile "\\Desktop\Attempt";

libname xptfile xport "\\Attempt\data.xpt";
proc copy in=xptfile out=sasfile memtype=data; run;
data temp; set sasfile2.data; format _all_; run;


libname xptfile xport "\\Attemp\formats.xpf";
proc copy in=xptfile out=sasfile; run;

Re: Associate data.xpt and formats.xpf from Stata into SAS

LinusH — Tue, 17 May 2016 02:43:54 GMT

Import formats data set first.
Use that as input to a proc format using the cntlin option. Store the output formats in Sasfile.
Point the fmtsearch option there.
Then import your data. Now your formats should work, given the they match.

topic Re: Associate data.xpt and formats.xpf from Stata into SAS in SAS Data Management

Associate data.xpt and formats.xpf from Stata into SAS

Re: Associate data.xpt and formats.xpf from Stata into SAS