topic Re: How do I import a sas7bdat file to SAS studio and then use it for data manipulation? in SAS Data Management

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

jjoy4891 — Mon, 20 Jul 2020 20:48:12 GMT

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 ?

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

PaigeMiller — Mon, 20 Jul 2020 20:56:47 GMT

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";

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

jjoy4891 — Mon, 20 Jul 2020 21:03:41 GMT

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

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

jjoy4891 — Mon, 20 Jul 2020 21:09:04 GMT

please bear with me, have less exposure to sas programming

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

PaigeMiller — Mon, 20 Jul 2020 21:17:04 GMT

data want;

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

by somevariablename; /* Optional */

run;