I am new to SAS and want to know if there is a way to do the following. Import the excel file, and import all the variables. One variable is numeric, want to prefix a text to it as below. Can the code be simplified? Proc sql; create table tt (drop = patientid) as select *, cat("patient ",patientid) as patientid1 from Temp ; create table tt2 (drop = patientid1) as select *, patientid1 as patientid from tt; quit;
... View more
