cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
PSP_1
‎05-14-2019
  • 3 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Number of observations in each percentile

by Fluorite | Level 6 in SAS Programming
‎05-14-2019 11:48 AM
‎05-14-2019 11:48 AM
Yes, sure. The only change I made to the code was in the below section: data calcs; merge stocks myNewData; by stock; array pct(*) perc:; do i=2 to dim(pct); if pct(i-1) <=open <=pct(i) then * on the line below I changed from index = i-1 to index = i-2 otherwise the percentiles were shifted by 1;; index=i-2; end; drop perc:; run; Apart of one line, everything else I used as is. ... View more

Re: Number of observations in each percentile

by Fluorite | Level 6 in SAS Programming
‎05-10-2019 11:26 AM
‎05-10-2019 11:26 AM
Thank you so, so much! The code worked perfectly well and it solved my problem! Thanks again for your time! ... View more

Number of observations in each percentile

by Fluorite | Level 6 in SAS Programming
‎05-09-2019 06:38 PM
‎05-09-2019 06:38 PM
Hi, I am new to SAS and I struggle to find a way for my problem.   I have a data set having variables: va1 var2  age   I calculated the percentiles using the code below and this worked well:   proc univatiate data=mydataset;         by age;         weight var1;         var var2; output out = mynew_data            PctlPre=PERC_            PctPts=0 to 100 by 1; run;   I now would like to determine how many observations there are within each percentile and I am really struggling. I need to have the output to be                p1               p2       etc... age1       n obs         n obs   age2 etc..   Your help would be much appreciated. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-14-2019 03:09 PM
Likes given to
View All
Quick links