Databases
StackOverflow2013
Postsdbo
POSAS-Create Dynamic Tables Based On ID With Only Top 3 Showing
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSAS-Create Dynamic Tables Based On ID With Only Top 3 Showing
    primarykey
    data
    text
    <p>Hi I would really like to create dynamic tables based on the following sample data, create 4 new data sets based upon PAYEE_ID: 522,622,743,and 888. I want all all of the fields to be in the new 4 data sets, but only have the top 3 AMT_BILLED in the 4 tables for each type of PAYEE_ID</p> <pre><code>PAYEE_ID PAYEENAME MSG_CODE MSG_DESCRIPTION AMT_BILLED percentbilled claimscounts PercentLines TotalAmount TotNumofClaims 522 MakeBelieve Center 1 AA text field 1 10000 4% 50 16% 275000 305 522 MakeBelieve Center 1 BB text field 2 20000 7% 40 13% 275000 305 522 MakeBelieve Center 1 6N text field 3 30000 11% 30 10% 275000 305 522 MakeBelieve Center 1 5U text field 4 25000 9% 20 7% 275000 305 522 MakeBelieve Center 1 1F text field 5 90000 33% 100 33% 275000 305 522 MakeBelieve Center 1 2E text field 6 100000 36% 65 21% 275000 305 622 Invisible Center 2 A4 text field 1 600 2% 9 7% 34300 134 622 Invisible Center 2 D2 text field 2 700 2% 31 23% 34300 134 622 Invisible Center 2 D4 text field 3 8000 23% 11 8% 34300 134 622 Invisible Center 2 DS text field 4 10000 29% 62 46% 34300 134 622 Invisible Center 2 F8 text field 5 15000 44% 21 16% 34300 134 743 Pretend Center 1 1K text field 1 440 1% 2 1% 41040 246 743 Pretend Center 1 1N text field 2 3000 7% 7 3% 41040 246 743 Pretend Center 1 1V text field 3 400 1% 4 2% 41040 246 743 Pretend Center 1 2W text field 4 15000 37% 63 26% 41040 246 743 Pretend Center 1 3B text field 5 500 1% 2 1% 41040 246 743 Pretend Center 1 3H text field 6 7700 19% 41 17% 41040 246 743 Pretend Center 1 3Z text field 7 14000 34% 127 52% 41040 246 888 It's A MakeBelieve One B7 text field 1 68000 38% 257 29% 178449 886 888 It's A MakeBelieve One B8 text field 2 5000 3% 47 5% 178449 886 888 It's A MakeBelieve One B9 text field 3 200 0% 138 16% 178449 886 888 It's A MakeBelieve One BB text field 4 1562 1% 18 2% 178449 886 888 It's A MakeBelieve One BO text field 5 39999 22% 3 0% 178449 886 888 It's A MakeBelieve One BZ text field 6 40000 22% 2 0% 178449 886 888 It's A MakeBelieve One C2 text field 7 500 0% 5 1% 178449 886 888 It's A MakeBelieve One C5 text field 8 7865 4% 395 45% 178449 886 888 It's A MakeBelieve One C7 text field 9 8649 5% 14 2% 178449 886 888 It's A MakeBelieve One CR text field 10 5674 3% 1 0% 178449 886 888 It's A MakeBelieve One CX text field 11 1000 1% 6 1% 178449 886 </code></pre> <p>to</p> <p>I'm new to SAS, and this would really help me out. Thank you so much!</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTeja
    1. USYen Ching
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSAS-Create Dynamic Tables Based On ID With Only Top 3 Showing
      1. This table or related slice is empty.
      1. VTDownMod
    1. COcheck sas user guide.
      singulars
      1. POSAS-Create Dynamic Tables Based On ID With Only Top 3 Showing
      1. USTeja
    2. COwhen you're checking the SAS user guide, maybe start by looking at PROC SORT and the `obs` dataset option.
      singulars
      1. POSAS-Create Dynamic Tables Based On ID With Only Top 3 Showing
      1. USJeff
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload