topic Re: when the source dataset name contains dashes in SAS Programming

when the source dataset name contains dashes

Dennis_K — Thu, 14 Mar 2019 05:17:19 GMT

154 data myprint.conractInformations-Sites; set disctool.conractInformations_Sites; run;
-
22
200
ERROR: File DISCTOOL.conractInformations_Sites.DATA does not exist.

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;,
_DATA_, _LAST_, _NULL_.

ERROR 200-322: The symbol is not recognized and will be ignored.

Re: when the source dataset name contains dashes

Kurt_Bremser — Thu, 14 Mar 2019 05:22:56 GMT

SAS names can only contain letters, digits or underlines, and must not start with a digit.

Re: when the source dataset name contains dashes

SASKiwi — Thu, 14 Mar 2019 05:30:46 GMT

This is likely to work but why change to non-standard names? You'll end up with a lot of extra typing in your programs:

data myprint.'conractInformations-Sites'n; set disctool.conractInformations_Sites; run;

Re: when the source dataset name contains dashes

ScottBass — Thu, 14 Mar 2019 06:04:59 GMT

154 data myprint.conractInformations-Sites; set disctool.conractInformations_Sites; run;

Your source dataset is disctool.conractInformations_Sites, and does not contain a dash. Does it in fact exist?

Because the error message is:

ERROR: File DISCTOOL.conractInformations_Sites.DATA does not exist.

That name does not contain a dash, it contains an underscore.

Your target dataset is myprint.conractInformations-Sites. You should have control over that name, since your code is creating the dataset. Don't use dashes. Problem solved.

Re: when the source dataset name contains dashes

Ksharp — Thu, 14 Mar 2019 12:19:17 GMT

options validmemname=extend ;

data myprint.'conractInformations-Sites'n;
 set .........

Re: when the source dataset name contains dashes

Dennis_K — Thu, 14 Mar 2019 15:17:22 GMT

I'm writing a macro to copy the datasets from the source library. The source dataset name contains dashes.

Re: when the source dataset name contains dashes

ScottBass — Thu, 14 Mar 2019 20:34:15 GMT

@Dennis_K wrote:
I'm writing a macro to copy the datasets from the source library. The source dataset name contains dashes.

Not in the code/log excerpt you posted.