About ash

ash · ‎03-26-2020

Thank you. That's probably the only combo I hadn't tried, since I thought that would have kept only the last visitdate (from my example, I would think that would have kept: ID = 1 and only the last row of the last visitdate (12/25/2019).

ballardw · ‎04-06-2015

Stub code: proc sort data=have; by ID date;run; data want; set have; by Id; Retain IdRec .; if first.id the IdRec=1; else IdRec+1; run;

GraphGuy · ‎02-24-2011

It's a bit awkward/kludgy, but you're probably going to have to add some 'missing' values to your data ... each of the 50 states will have to have each of the 6 subtypes (with a sas 'missing' value for the pcr_count). -- There might be another way, but this is the technique I usually use. This should work ok, since you're doing a type=sum bar chart (whereas if you were doing a frequency count bar chart, you might have to be a little trickier).

ballardw · ‎01-24-2011

If FLUPOS is coded as 0/1 then MEAN instead of PERCENT will give you a percent of 1 coded responses, use an appropriate format for display.

Online Status	Offline
Date Last Visited	‎06-30-2021 01:13 PM

Re: using last. for observations with multiple

using last. for observations with multiple

Create ID variable for multiple records per individual

making color assignments permanent in stacked graphics

Re: gbarline with stacked bars and a percentage for the line

gbarline with stacked bars and a percentage for the line

Re: using last. for observations with multiple

Re: character date to Date9.

Re: Create ID variable for multiple records per individual

Re: using last. for observations with multiple

Re: Create ID variable for multiple records per individual

Re: making color assignments permanent in stacked graphics

Re: gbarline with stacked bars and a percentage for the line