Hi everyone,  Is there a easy way to transpost my wide data into long format?   It's a pretty simple dataset which looks like this;   ID_mom        ID_child          ID_father  year  111               444                  777          2010 222               555                  888         2011 333               666                  999         2012    I want to transform it to long format, as:   ID  111 222 333 444 555 666 777   I have made an solution with below coding: data id (keep ID); set id_popb; rename ID_MOM = ID; run;  repeated for both child and father id  afterwards I append these three datafiles into one file.    But I really thin there's a smarter way to do this    Thank you in advance    Kind regards Frank  ... View more

Hi everybody   I'm trying to extract a subset of variables from some locked datafiles with a macro. I do only have reading access to the folder where i'm importing my data from.   My syntax looks like this:   %macro extract_bef(start, end); %do year = &start. %to &end.; data rawdata.bef&year.; Merge ekstern.&pop (in = A) data.bef&year. (in = B keep = &BEF.); by ID; if A and B; run; %end; %mend; %extract_bef(201312,201812)   This works fine, but my problem is that I get a lot of datafiles that I really dont need. I want to extract some defined variables in the macro &bef from year 2013 until 2018. But in my output datafolder I also gets the "years" 201313, 201314, 201315..... 201399 and etc. Really frustrating. It is not a opportunity for me to change the names from bef201312 to bef2013 etc. in the input datafolder because I do only have reading access. Does anyone have an idea how to solve this?   In a basic datastep my syntax would have looked liked this:   data bef2013; set bef201312 (keep = &BEF.; run; Instead of doing this multiple times i'm  trying to solve this with the above macro &extract_bef.   Hope there is someone who can help me fix this.   Kind regards Frank   ... View more

Hello I'm quite new to the SAS platform.   I'm trying to make a data extract from some tables with identical names, but with different years as prefix, ex   UDDA2002 UDDA2003 UDDA2004 UDDA2005 UDDA2006 etc.   I have to extract the exact same variables from the different tables, but instead of doing it manually I was wondering if I could do this in a do-loop instead? lets say I want to extract the variables pnr, x and y from the tables and save them as UDDA2004, UDDA2005 etc. on a different location than my import location.   Kind regards Frank. ... View more