It worked! Thanks so much. ... View more

Hi, here's the complete code and log. What I meant by "wiped" was that the dataset goes from 23274 observations and 14 variables to 1 observation and 1 variable. To further clarify, I'm trying to convert all the observations of the ETHNICIT variable from numeric to character (ex. 1s to 1., 2s to 2., 3s to 3. etc).     %include "T:\...\exvar.sas"; libname in XPORT "T:\...\exvar.xpt"; proc contents data=in.exvar; run; data "T:\...\exvar"; set in.exvar; run;   Log: 1 %include "T:\...\exvar.sas"; NOTE: Libref DATAPATH was successfully assigned as follows: Engine: V9 Physical Name: T:\...\ NOTE: Libref XPTFILE was successfully assigned as follows: Engine: XPORT Physical Name: T:\...\exvar.xpt NOTE: Writing HTML Body file: sashtml.htm NOTE: Input library XPTFILE is sequential. NOTE: Copying XPTFILE.EXVAR to DATAPATH.EXVAR (memtype=DATA). NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. NOTE: There were 23274 observations read from the data set XPTFILE.EXVAR. NOTE: The data set DATAPATH.EXVAR has 23274 observations and 14 variables. NOTE: PROCEDURE COPY used (Total process time): real time 1.94 seconds cpu time 0.64 seconds NOTE: Format GRADUATE has been output. NOTE: Format ETHNICIT has been output. NOTE: Format EMPLOYME has been output. NOTE: Format RELATION has been output. NOTE: Format HELP has been output. NOTE: Format RNQ47A has been output. NOTE: Format NQ has been output. NOTE: Format NQA has been output. NOTE: Format NQB has been output. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.09 seconds cpu time 0.07 seconds 57 libname in XPORT "T:\...\exvar.xpt"; NOTE: Libref IN was successfully assigned as follows: Engine: XPORT Physical Name: T:\...\exvar.xpt 58 59 proc contents data=in.exvar; 60 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.08 seconds cpu time 0.03 seconds 61 62 data "T:\...\exvar"; 63 set in.exvar; 64 run; NOTE: There were 23274 observations read from the data set IN.EXVAR. NOTE: The data set T:\...\exvar has 23274 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.55 seconds cpu time 0.14 seconds 65 data datapath.exvar; 66 ETHNICIT = 1; 67 NEW = put(ETHNICIT,1.); 68 ETHNICIT = 2; 69 NEW = put(ETHNICIT,2.); 70 ETHNICIT = 3; 71 NEW = put(ETHNICIT,3.); 72 ETHNICIT = 4; 73 NEW = put(ETHNICIT,4.); 74 ETHNICIT = 5; 75 NEW = put(ETHNICIT,5.); 76 ETHNICIT = 6; 77 NEW = put(ETHNICIT,6.); 78 ETHNICIT = 7; 79 NEW = put(ETHNICIT,7.); 80 ETHNICIT = 8; 81 NEW = put(ETHNICIT,8.); 82 drop ETHNICIT; 83 rename NEW = ETHNICIT; 84 run; NOTE: The data set DATAPATH.EXVAR has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.54 seconds cpu time 0.03 seconds ... View more

Hi. Maybe I'm approaching this the wrong way. I'm trying to convert all the observations of ETHNICIT from numeric to character in the exvar dataset (ex. all 1s to 1., all 2s to 2., 3s to 3. etc). Is the simplified code the right way to do that?   Also, how would I read the dataset to do this then?   I appreciate the help! ... View more