Dataset names with numbers

Accepted Solution Solved
Reply
Contributor
Posts: 49
Accepted Solution

Dataset names with numbers

Hi,

I have datasets using number designations as names.. e.g. Dataset 1 = 01_19, Dataset 2 = 100_199 etc.

When doing undergoing a proc sort / merge the code does not like numeric dataset names. I tried enclosing in single quotes with "n" at the end but to no avail.

Here is some sample code:

PROC SORT DATA='01_19'n; BY ACCTNO;RUN;

PROC SORT DATA='20_39'n; BY ACCTNO;RUN;

PROC SORT DATA='40_59'n; BY ACCTNO;RUN;

PROC SORT DATA='60_79'n; BY ACCTNO;RUN;

DATA  Sample_Table;

MERGE  '01_19'n

              '20_39'n

              '40_59'n

              '60_79'n;

RUN;

Any input on how to work with dataset names using numeric aliases would be most helpful.

TS


Accepted Solutions
Solution
‎08-21-2015 02:39 PM
Contributor
Posts: 49

Re: Dataset names with numbers

I'm an idiot, found my mistake, never mind.

View solution in original post


All Replies
Solution
‎08-21-2015 02:39 PM
Contributor
Posts: 49

Re: Dataset names with numbers

I'm an idiot, found my mistake, never mind.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 1 in conversation