How do I import a sas7bdat file to SAS studio and then use it for data manipulation?

[jjoy4891]

Hi,

I have 4 sas7bdat files , wanted to concatenate them for data manipulation . How can i import the same to sas university edition and perform concatenation ?

[PaigeMiller]

You don't import the .sas7bdat files. Instead, you point SAS to the folder they are stored in by using a LIBNAME statement.

Something like this:

libname myfiles "/folders/myshortcuts/temp/temp";

[jjoy4891]

thank you,
i did the above step, however, i can't merge these 4 datasets >

[jjoy4891]

please bear with me, have less exposure to sas programming

[PaigeMiller · Accepted solution]

data want;

    merge myfiles.dataset1 myfiles.dataset2 myfiles.dataset3 myfiles.dataset4;

    by somevariablename; /* Optional */

run;