topic Re: Transform dataset based on columns in SAS Programming

Transform dataset based on columns

msantosp — Tue, 14 Jun 2022 10:49:46 GMT

Hi,

I have the dataset below

Usuario -- Año Inicio -- Año fin

5--2008--2011

and I would like to transform it into the next one:

Usuario--Año

5--2008

5--2009

5--2010

5--2011

Someone could help me? 🙂

Thanks

Re: Transform dataset based on columns

PeterClemmensen — Tue, 14 Jun 2022 11:11:42 GMT


data have;
input Usuario AnoInicio Anofin;
datalines;
5 2008 2011 
;

data want(drop = AnoInicio Anofin);
   set have;
   do ano = AnoInicio to Anofin;
      output;
   end;
run;

Re: Transform dataset based on columns

msantosp — Tue, 14 Jun 2022 11:19:28 GMT

Super! Thanks 😄

Re: Transform dataset based on columns

PeterClemmensen — Tue, 14 Jun 2022 11:24:27 GMT

Anytime 🙂