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

proc print data=orion.order_fact;
where total_retail_price GE 500;
sum total_retail_price;

run;

 

I can see 40 result in the result window. But I had to count number of oberervation. I know I can check that in log window. but I want to know if there is a way to get/assign seq in result window to whatever result comes. in this case I am expecting to see the entire data set in the result window where total_retail_price GE 500. data set has total 100 obersvation. becuase I am using where condition, it gives me 40 obeservation. again I can see that in log windown. but I want to see like SEQ in the result window so that when I go to the bottom of the result page, I can see total observation. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
binitp18
Calcite | Level 5

nevermind. I can see that in obs. 

View solution in original post

2 REPLIES 2
binitp18
Calcite | Level 5

nevermind. I can see that in obs. 

mkeintz
PROC Star

Then mark your topic as solved.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

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