I am trying to import data using proc import and having trouble with a date format. In Excel the date appears as MM/DD/YYYY but when I run the import, I get a 5-character string that does *not* correspond to the SAS date (e.g. the date is 10/08/2019, and after the import the cell shows "43745", which, even if I convert it to a date, is equivalent to 10/08/2079).   Is there a way I can specify in the proc import how I want to import this particular column?   proc import out=data_collected datafile="SchoolList.xlsx" DBMS=XLSX replace ; range="'School_Data'$A:K"; run;   ... View more

I'm trying to produce a slicefit type plot and want to specify values for the sliceby variable.   Outcome is a binary outcome (0/1). Variable1 and Variable2 are both continuous variables.   The code below produces exactly what I want except for one small issue: I'd like to set the values for sliceby=variable2 to be like 20, 40, 60, etc., not the 15.66, 36.36, 57.06, etc. that are being chosen automatically.   I have tried to use AT to specify values but can't get the result I want. The sliceby values are still the ones chosen automatically.   proc logistic data=my_dataset PLOTS(ONLY) = EFFECT(showobs); model outcome = variable1 variable2 variable1*variable2 / rsquare; effectplot slicefit (x=variable1 sliceby=variable2) / noobs ; run; ... View more