I want my continuous variable to be centered for cox regression model.  ... View more

I am trying to create a dummy variable for my categorical variable(ethnic) using if else command. But the output only displays 0.   if ethnic="black" then dublack= 1; else dublack= 0; if ethnic="cauca" then ducauca=1;else ducauca=0; run;     ... View more

%MACRO excel (OUTPUT=,INFILE=,WSHEET=); PROC import OUT= &OUTPUT DATAFILE="P:\FALL COURSES 2020\SAS\final project\&INFILE" DBMS=xls; SHEET="&WSHEET"; PROC CONTENTS DATA=&OUTPUT; PROC SORT DATA=&OUTPUT; BY ID; RUN; %MEND excel; %excel(OUTPUT=Site1,INFILE=Site1.XLS,WSHEET=SHEET1); %excel(OUTPUT=Site2,INFILE=Site2.XLS,WSHEET=SHEET1);   ERROR: File WORK.SITE2.DATA does not exist. ... View more

RROR 22-322: Syntax error, expecting one of the following: ;, (, COMPRESS, DATA, FC, FORMCHAR, NLEVELS, NOPRINT, ORDER, PAGE. ERROR 202-322: The option or parameter is not recognized and will be ignored     *unadjusted association; proc freq data=gene env; table hstatus*cannabis/nopercent nocol cmh; run; ... View more

rescale time variable from days to years; years=LENFOL/365.25; run; it showed an error after running this command, is there any mistake in the command? ... View more