@iressa131 wrote:
I just realized the quotation marks are incorrect because Im using university. so now when I run it I don't get any errors however my output only shows 1 observation with no entry.
PROC CONTENTS DATA=WORK.IMPORT; RUN;
data WORK.IMPORT;
PhoneNum = compress(agent_details, ,'kd');
run;
You didn't include an input data set, in fact you overwrote your data. You'll need to import it again.
data Step1; *output data set name is STEP1;
set IMPORT; *input data set name is IMPORT;
PhoneNum = compress(agent_details, ,'kd');
run;
... View more