StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19568419
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-10-24T14:13:11.497
FavoriteCount
0
LastActivityDate
2013-10-24T18:43:53.007
LastEditDate
2013-10-24T18:43:53.007
LastEditorUserId
2550114
OwnerUserId
2550114
ParentId
19549945
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<pre><code>proc sort data=sampleData out=sampleData_s; by payee_id amt_billed; run; </code></pre> You can use descending if by 'top' you mean largest e.g. <code>by payee_id descending amt_billed;</code> Once the data are sorted you are able to read into a data step and use <code>first</code> and <code>last</code> e.g. <pre><code>data partial_solution(drop=count); retain count 0; set sampleData_s; by payee_id descending amt_billed; if first.payee_id then count=0; count+1; if count le 3 then output; run; </code></pre> To output to different dataset names: <pre><code>proc sort data=sampleData(keep=payee_id) out=all_payee_ids nodupkey; by payee_id; run; data _null_; length id_list $10000; * needs to be long enough to contain all ids; * if you do not state this, sas will default; * length to first value; retain id_list; set all_payee_ids end=eof; id_list = catx('|', id_list, payee_id); if eof then call symputx('macroVarIdList', id_list); run; </code></pre> You've now got a pipe separated list of all your id's. You can loop through these using them to create names for you datasets. You need to do this as SAS needs to know the names of the datasets you want to output to up front e.g. <pre><code>data ds1 ds2 ds3 ds4; set some_guff; if blah then output ds1; else if blahblah then output ds2; else output d3; output d4; run; </code></pre> So with the macro var loop: <pre><code>%let nrVars=%sysfunc(countw(&macroVarIdList)); data %do i = 1 %to &nrVars; dataset_%scan(&macroVarIdList,&i,|) %end; ; set partial_solution; count+1; %do j = 1 %to &nrVars; %let thisPayeeId=%scan(&macroVarIdList,&j,|); if payee_id = "&thisPayeeId" then output dataset_&thisPayeeId.; %end; run; </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSAS-Create Dynamic Tables Based On ID With Only Top 3 Showing
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USkungfujam
UserOwnerUserId
1. USkungfujam
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.