topic Can't get %include to work. in SAS Programming

Can't get %include to work.

LauriB — Wed, 28 Jun 2023 23:58:31 GMT

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.

Re: Can't get %include to work.

Tom — Thu, 29 Jun 2023 01:16:36 GMT

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?

Re: Can't get %include to work.

SASKiwi — Thu, 29 Jun 2023 01:17:45 GMT

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.

Re: Can't get %include to work.

LauriB — Thu, 29 Jun 2023 01:53:24 GMT

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

Re: Can't get %include to work.

SASKiwi — Thu, 29 Jun 2023 02:52:04 GMT

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";

Re: Can't get %include to work.

AliceCheng — Thu, 29 Jun 2023 03:12:05 GMT

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

Re: Can't get %include to work.

Kurt_Bremser — Thu, 29 Jun 2023 05:14:27 GMT

Remove the blank between HEI and the following slash.