|
> From: P. Cristian Gugiu
> Thanks to one members running SAS in a Vista OS environment,
> I was able to
> examine the log from his run. According to the log, there were 56
> temporary datasets created with 1 record and 8 variables. Search
> for: "NOTE: The data set WORK.LAMBDAS has 1 observations and
> 8 variables."
> However, the final dataset located in the Loc folder is
> empty. Therefore,
> for some reason, either the following code does not appear to
> work in a
> Vista environment or something is preventing the temp dataset
> from being
> appended. Anyone have any ideas what might be going on?
>
> %MACRO AppendData;
> %if %sysfunc(exist(work.Lambdas))=1 %then %do ;
> /* Appends results of each run to _Data. */
> Proc Append Base=Loc.Lambdas Data = Lambdas ;
> run ;
>
> proc datasets ;
> delete Lambdas;
> run;
> %end;
> %else %put Temporary file Lambdas does not exist in the Work
> folder.;
> %Mend;
I am just guessing that this may be perhaps a casing issue:
> %if %sysfunc(exist(work.lambdas))=1 %then %do;
> %if %sysfunc(exist(Work.Lambdas))=1 %then %do;
> %if %sysfunc(exist(WORK.LAMBDAS))=1 %then %do;
check this option:
proc options define value option = validvarname;
proc options group = SASFILES;
run;
you'll have to RTFM to see what values are acceptable for this option
iirc:
options ValidVarName = UPCASE;
note that SAS UPCASES ITS DATA SET NAMES
but Windows saves the files lowercased.
pretty strange but I run into this all the time when I am typesetting
Ron Fehd the PropCase
or macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
p.s.: this casing issue was a major headache when I was upgrading from
v6 to v8
|