Why am I getting this error? INPUT function requires a character argument Doesn't input function create numerical variables? Why is it saying that it needs a character argument? Here is my code: proc sql;
create table hk_dados1 as
select subject_id as id,
MRN,
BASELINE_DOC,
COLLECTION_CENTER as site_ca,
BASELINE_DOB,
BASELINE_AGE,
BASELINE_SEX,
BASELINE_MARITALSTATUS,
BASELINE_EDUCATION,
BASELINE_COUNTRYORIGIN,
BASELINE_IMMIGRATIONDATE,
BASELINE_LANGUAGES,
BASELINE_ENGLISH,
BASELINE_DOA,
BASELINE_TIMEOFINJURYSTATUS,
BASELINE_ATTEMPTEDRETURN,
BASELINE_CURRENTWORKING,
BASELINE_HTN,
BASELINE_DIABETES,
BASELINE_MENTAL,
BASELINE_SCORE as BASELINE_PHQ_SCORE,
BASELINE_SMOKER,
BASELINE_ANNOY,
BASELINE_GUILTY,
BASELINE_EYEOPENER,
BASELINE_NPRSHIP,
BASELINE_NPRSKNEE,
BASELINE_SF1,
BASELINE_TOTAL as BASELINE_PCS_TOTAL,
BASELINE_WTOTALSCORE,
DISCHARGE_DOC,
input(DISCHARGE_DC_SITE,1.) as discharge_site,
input(DISCHARGE_STREAM,1.) as discharge_stm,
input(DISCHARGE_HR_RECOVERING,1.) as discharge_hr_recover,
input(DISCHARGE_HR_HELPFUL,1.) as discharge_hr_help,
input(DISCHARGE_HR_SATISFACTION,1.) as discharge_hr_sat,
input(DISCHARGE_HR_GENHEALTH,1.) as discharge_hr_genhel,
input(DISCHARGE_WTOTALSCORE, 2.) as discharge_womac_score,
input(DISCHARGE_SCORE,2.) as discharge_phq,
input (DISCHARGE_NPRSHIP, 2.) as discharge_npr_bn,
input (DISCHARGE_NPRSKNEE, 2.) as discharge_npr_kn,
input (DISCHARGE_TOTAL, 3.) as discharge_pcs,
DISCHARGE_RTW_STATUS
from temp.'All$'n;
quit;
... View more
