topic Re: Importing sas7bdat file in SAS Programming

Importing sas7bdat file

DingDing — Mon, 29 Aug 2016 13:59:56 GMT

I want to import this data: myda.sas7bdat . here is my code based on the solution offered by aboved link:

 LIBNAME SAS "\\Client\D$\sas";
PROC PRINT DATA= SAS.myda;
run;

up to now, it works well, but if I want to modify the dataset, it doesn't work.

DATA myda1;
set SAS.myda;
run;

So i don't know how to use the dataset with suffix sas7bdat, anybody helps? Thank you.

Reeza — Mon, 29 Aug 2016 14:01:22 GMT

Sas7bdat files are SAS datasets. You don't import them.

You refer to the dataset using the libname.dataset_name format.

So assign a libname to the folder where you store the dataset and then refer to it in the format above.

DingDing — Mon, 29 Aug 2016 14:12:51 GMT

Thank you. but my codes:
DATA myda1;
set SAS.myda;
run;

I can't get the dataset myda1. what can I do.

Reeza — Mon, 29 Aug 2016 14:16:34 GMT

Post your full code and log.

You put the name of the dataset your trying to use in the SET statement.

It it should look like the following:

Libname input 'path to folder';

data want;

set input.myda1;

run;

DingDing — Mon, 29 Aug 2016 14:28:47 GMT

Yes, you are right. It is solved. Thank you.