@LFern wrote:
Hello,
I have:
data have;
input country $6. min max ;
datalines;
Canada 495 507
Haiti 10 15
;
run;
I want either of these versions (they're substantively the same but one is long-format and the other is wide-format):
Wide format:
![want1.PNG want1.PNG](https://communities.sas.com/t5/image/serverpage/image-id/62738i8F20F8ABC4B296D6/image-size/large?v=v2&px=999)
Long format:
![want2.PNG want2.PNG](https://communities.sas.com/t5/image/serverpage/image-id/62737i3B352427D71644E4/image-size/large?v=v2&px=999)
Any suggestions?
data want;
set have;
do in_range=min to max;
output;
end;
keep country in_range;
run;
If you want the "wide" version you could use proc transpose but can't see any real advantage to that.
I have to assume you wanted the integer versions. "All values", in a mathematical sense, is an infinite number of values regardless of the range.