BookmarkSubscribeRSS Feed
noda6003
Quartz | Level 8

I have a dataset which has grades and variable named chk. what i want it from is to get grades which are more than the one initially i.e chk gt 0

 


DATA work.check;
    LENGTH
        ID                 8
        grade              8
        chk                8 ;
    FORMAT
        ID               BEST12.
        grade            BEST12.
        chk              BEST12. ;
    INFORMAT
        ID               BEST12.
        grade            BEST12.
        chk              BEST12. ;
    INFILE DATALINES4
        DLM='7F'x
        MISSOVER
        DSD ;
    INPUT
        ID               : BEST32.
        grade            : BEST32.
        chk              : BEST32. ;
DATALINES4;
110
110
121
220
221
211
211
320
310
331
;;;;



something like this since ID 1 has more grade than it has in chk=0 and ID=3 has grade=3 which is more than in chk=0.

ID grade chk
1 2 1
3 3 1

Not sure how to do it programmatically. Any help

1 REPLY 1

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1095 views
  • 0 likes
  • 2 in conversation