Desktop productivity for business analysts and programmers

I made temp data sets perm, but I'm getting errors?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 78
Accepted Solution

I made temp data sets perm, but I'm getting errors?

Should the MMSP3K be perm as well as MMSP3D?

 

 

278 DATA &NAME..MMSP3K &NAME..MMSP3D (KEEP=AUTHRZTN_RFRNC_NUM); /*MAKE PERM*/

279 SET &NAME..MMSP3B; /*MAKE PERM*/

280 BY DUPKEY FIRST_CLOSED_DT;

281 IF FIRST.DUPKEY THEN OUTPUT MMSP3K;

______

455

282 ELSE OUTPUT MMSP3D;

______

455

ERROR 455-185: Data set was not specified on the DATA statement.

283 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set M290.MMSP3K may be incomplete. When this step was stopped there were 0 observations and 3 variables.

WARNING: The data set M290.MMSP3D may be incomplete. When this step was stopped there were 0 observations and 1 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

284

8 The SAS System 20:23 Thursday, March 1, 2018

285 PROC SORT DATA=&NAME..MMSP3D; /*MAKE PERM*/

286 BY AUTHRZTN_RFRNC_NUM;

287 RUN;

NOTE: Input data set is empty.

NOTE: The data set M290.MMSP3D has 0 observations and 1 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

288

289 DATA &NAME..MMSP3DA; /*MAKE PERM*/

290 SET &NAME..MMSP3D; /*MAKE PERM*/

291 BY AUTHRZTN_RFRNC_NUM;

292 IF FIRST.AUTHRZTN_RFRNC_NUM THEN OUTPUT;

293 RUN;

NOTE: There were 0 observations read from the data set M290.MMSP3D.

NOTE: The data set M290.MMSP3DA has 0 observations and 1 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds


Accepted Solutions
Solution
‎03-02-2018 04:32 PM
Respected Advisor
Posts: 2,647

Re: I made temp data sets perm, but I'm getting errors?

IF FIRST.DUPKEY THEN OUTPUT &NAME..MMSP3K;
ELSE OUTPUT &NAME..MMSP3D;
--
Paige Miller

View solution in original post


All Replies
Solution
‎03-02-2018 04:32 PM
Respected Advisor
Posts: 2,647

Re: I made temp data sets perm, but I'm getting errors?

IF FIRST.DUPKEY THEN OUTPUT &NAME..MMSP3K;
ELSE OUTPUT &NAME..MMSP3D;
--
Paige Miller
Frequent Contributor
Posts: 78

Re: I made temp data sets perm, but I'm getting errors?

[ Edited ]
Posted in reply to PaigeMiller

I'm trying this now.  If I run starting from that step, will my other data steps save? Or should I run from the beginning of the program? I forgot to choose the option that I didn't want to overwrite the previous log when kicking it off Smiley Sad

Respected Advisor
Posts: 2,647

Re: I made temp data sets perm, but I'm getting errors?


essdee wrote:

I'm trying this now.  If I run starting from that step, will my other data steps save? Or should I run from the beginning of the program? I forgot to choose the option that I didn't want to overwrite the previous log when kicking it off Smiley Sad


This is way too vague for me to understand. Please be specific. Show us the code.

--
Paige Miller
☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 90 views
  • 1 like
  • 2 in conversation