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

Hi SAS Forum,

This code was written by another programmer.

I am trying to understand two symbols highlighted in yellow color in it.

%if &income = 0 %then %do;

       data wave_2;

         set wave_1;

         by transit_branch acctnumber;

         if ~(first.acctnum and last.acctnum) then do;

           if currbal ~= (acctbal * -1) then delete;

         end;

         run;

%end;

%else %do;

    proc sort data=wave_1 out=wave_2 nodupkey;

         by transit_branch acctnumber;

         run;

%end;

Q:

Could you please let me know if the way I understand it correct.

if ~(first.acctnum and last.acctnum) then do;

This means,

if not (first.acctnum and last.acctnum) then do;

if currbal ~= (acctbal * -1) then delete;

This would mean:

if currbal ne (acctbal * -1) then delete;

Thanks

Mirisage

1 ACCEPTED SOLUTION

Accepted Solutions
ArtC
Rhodochrosite | Level 12

Yes the ~ is another symbol for not.  In addition to the word 'not' you can also use the ^ symbol.  On the mainframe this symbol looks different but is still the shift-6 key.  Some languages use <> or >< for variations of not equal.  These two combinations have different meanings in SAS and IMO should be avoided.

View solution in original post

1 REPLY 1
ArtC
Rhodochrosite | Level 12

Yes the ~ is another symbol for not.  In addition to the word 'not' you can also use the ^ symbol.  On the mainframe this symbol looks different but is still the shift-6 key.  Some languages use <> or >< for variations of not equal.  These two combinations have different meanings in SAS and IMO should be avoided.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 580 views
  • 0 likes
  • 2 in conversation