Can't get %include to work.

[LauriB]

I don't understand why it will not recognize this macro. It is in the folder. Any suggestions? Thanks.

%let home = H:\HardDrive5\Laptop Backup 7-13-14\HEI\;

filename Totals '&home\ Data for HEI calc each day.csv';

filename res '&home\Results';

%include 'H:/HardDrive5/Laptop Backup 7-13-14/HEI /hei2015.score.macro.sas';

WARNING: Physical file does not exist, H:\HardDrive5\Laptop Backup 7-13-14\HEI \hei2015.score.macro.sas.

ERROR: Cannot open %INCLUDE file H:/HardDrive5/Laptop Backup 7-13-14/HEI /hei2015.score.macro.sas.

[Tom]

Your first two FILENAME statement cannot work because you are trying to use macro code inside of a quoted string that is bounded by single quote characters.  The macro processor will ignore those strings.  You need to use double quote characters instead to make those string literals.

But the %INCLUDE statement looks ok other than that you are using the wrong delimiter for a WIndow filename.  Windows uses \ and not / between the directory levels.

Are you sure the H drive is mounted on the machine where SAS is running?

[SASKiwi]

If your SAS session is running on a remote SAS server then it won't be able to read your PC's H drive. You need to move the sas program file to a folder accessible by your SAS server.

[LauriB]

Thanks for the response. It is not running on a remote server.

[SASKiwi]

Try this. Are you really using multiple dots in your SAS macro filename?

%let home = H:\HardDrive5\Laptop Backup 7-13-14\HEI;
filename Totals "&home\Data for HEI calc each day.csv";
filename res "&home\Results";
%include "&home\hei2015.score.macro.sas";

[AliceCheng]

Have you try to rename hei2015.score.macro.sas to hei2015_score_macro.sas and update the program with the new name?  Will that work?

Regards,

Alice Cheng

[Kurt_Bremser]

Remove the blank between HEI and the following slash.