BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mhollifi
Obsidian | Level 7

I just copied proc rank from SAS site but I got this basic error message.  I'm scratching my head now.  Please help

538  *  calculate accumulative totals for each year;
539  libname in "e:\Users\mhollifi\Documents\Profs\MCox1-28-14\Net 2018";
NOTE: Libref IN was successfully assigned as follows:
      Engine:        V9
      Physical Name: e:\Users\mhollifi\Documents\Profs\MCox1-28-14\Net 2018
540
541  data in1;
542       merge in.akron1 in.akron2 in.akron3 in.akron4;
543       by metro;
544       array exmpt {*} exmpt_net93 - exmpt_net99 exmpt_net00 - exmpt_net15;
545       array total {*} total_net93 - total_net99 total_net00 - total_net15;
546       do i = 1 to 23;
547          if exmpt(i) = . then exmpt(i) = 0;
548       end;
549
550       do i = 1 to 23;
551          if i = 1 then total (i) =  exmpt(i);
552          else     total(i) = sum(total(i-1) , exmpt(i));
553       end;
554  run;

NOTE: There were 62 observations read from the data set IN.AKRON1.
NOTE: There were 45 observations read from the data set IN.AKRON2.
NOTE: There were 56 observations read from the data set IN.AKRON3.
NOTE: There were 60 observations read from the data set IN.AKRON4.
NOTE: The data set WORK.IN1 has 66 observations and 49 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds


555  proc rank data=in1 out=order descending ties=low;
556   
     -
     180
ERROR 180-322: Statement is not valid or it is used out of proper order.
557     var total_net15;
558     ranks total_Rank;
559  run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.ORDER may be incomplete.  When this step was stopped there were 0
         observations and 0 variables.
WARNING: Data set WORK.ORDER was not replaced because this step was stopped.
NOTE: PROCEDURE RANK used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

 

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

You most likely imported a non-printing character. Try retyping the code (don't cut and paste!)

 

 

PG

View solution in original post

1 REPLY 1
PGStats
Opal | Level 21

You most likely imported a non-printing character. Try retyping the code (don't cut and paste!)

 

 

PG

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 726 views
  • 3 likes
  • 2 in conversation