BookmarkSubscribeRSS Feed
Cruise
Ammonite | Level 13

I'd like to keep 'age_in_days' in data plot which is obvisouly not distinct. Putting age_in_days after 'having' and before 'distinct' in select statement didn't work out.

My goal is to line graph 'age_in_days' against 'tot'. 

 

proc sql;
 create table plot as
 select distinct id,a1, a2, a3
  from temp1
  where (0 <= age_in_days <= 10)
  group id, a1, a2, a3
  having date = min(date); 
quit; 

proc transpose data=plot out=final;
run;
data final1(keep=tot _NAME_); set final;
tot=sum(of Col:);
run;

 

1 REPLY 1
ChrisBrooks
Ammonite | Level 13

Can you give us a sample of your data in the form of "have" and "want" data sets please? If it's difficult to advise you without knowing what your data looks like.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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