topic SAS Studio: How to use filename input sas7bdat and print data in SAS Programming

SAS Studio: How to use filename input sas7bdat and print data

mgwynethj — Mon, 11 Sep 2023 01:33:04 GMT

I have uploaded a .sas7bdat file to SAS Studio and the file's path is /home/u63582165/abg_vbg_f23.sas7bdat (found it through file properties).

But when I run proc print data, it shows the table but it's null.

Here's the log:

and the result

Thanks,

Gwyneth

Re: SAS Studio: How to use filename input sas7bdat and print data

SASKiwi — Mon, 11 Sep 2023 01:47:13 GMT

You don't use FILENAME and INPUT with SAS datasets as SAS already knows how to read them. This should work:

proc print data = '/home/u63582165/abg_vbg_f23.sas7bdat';
run;

You can also define a SAS LIBNAME pointing at SAS datasets in a folder:

libname MyData "/home/u63582165";

proc print data = MyData.abg_vgb_f23;
run;

Re: SAS Studio: How to use filename input sas7bdat and print data

mgwynethj — Mon, 11 Sep 2023 03:02:36 GMT

Thank you for your help !

Re: SAS Studio: How to use filename input sas7bdat and print data

Amir — Mon, 11 Sep 2023 10:16:54 GMT

Hi @mgwynethj,

Welcome to the forums, I hope you continue to have a good experience.

Please note that when a person provides a working answer then marking their post as the solution gives them the credit for their effort, which would be @SASKiwi in this case. You might be able to change which post you have marked as the solution, and it is also good to know for the future.

Thanks & kind regards,

Amir.