For the following simple sas code,   data myfmt; retain fmtname "salegroup"; length start $20 label $20; infile datalines delimiter='/'; input start $ label $; datalines; low-<700 / need improvement 700-<900 / good 900-high / top sale ; run;   proc format cntlin=myfmt fmtlib; run;   When I run the code, SAS complains the following 70 proc format cntlin=myfmt fmtlib; ERROR: For format SALEGROUP, this range is repeated, or values overlap: .-.. I use the most conventional way to write the same functionality as the following,   proc format fmtlib; value salegroupv low-<700 = 'need improvement' 700-<900 = 'good' 900-high = 'top sale'; run;   and it seems it works fine. Why is this difference? How can I possibly use the first way to define a numeric range to format my data? ... View more

I am using the online sas studio.   The code is as follows,   %macro allcylinders; proc sql noprint; select distinct Cylinders into :val1- from sashelp.cars where Cylinders ne .; quit; %put &=SQLOBS; %do i=1 %to %SQLOBS; title "&&val%i-Cylinder Cars"; proc print data=sashelp.cars noobs; var Make Model Type Origin MSRP MPG_City MPG_Highway; where Cylinders=&&val&i; run; %end; %mend allcylinders; %allcylinders   The macro compilation passes successfully. When I run the macro, it complains the following, SQLOBS=7 WARNING: Apparent invocation of macro SQLOBS not resolved. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: %SQLOBS ERROR: The %TO value of the %DO I loop is invalid.   But as I printed on the screen, the macro variable SQLOBS=7, thus I don't understand why it issues the specific WARNING, and then give the next ERROR message. ... View more

I use sas studio and mistakenly created a weird directory by a wrong sas statement as   options dlcreatedir libname  myname "output;   and the directory created is   output;OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;ODS HTML CLOSE;GOPTIONS NOACCESSIBLE;; ;*';*   my question is, how to possibly delete this directory from within SAS? ... View more