topic Re: Extracting the data from SAS format in SAS Software for Learning Community

Extracting the data from SAS format

drvasu — Tue, 07 Feb 2023 07:21:31 GMT

Hi,

Can you please help me to extract the data in this .SAS file into Excel?

SASJedi — Tue, 07 Feb 2023 13:29:44 GMT

This file is a SAS program, not a SAS data set. It contains only SAS code (text). Can you provide details about what you intend to accomplish?

drvasu — Tue, 07 Feb 2023 13:31:15 GMT

I would like to get the details of the codes

PaigeMiller — Tue, 07 Feb 2023 13:44:48 GMT

@drvasu wrote:

I would like to get the details of the codes

Ask specific questions about the code. Explain (as @SASJedi said) what it means to extract this into Excel.

Tom — Tue, 07 Feb 2023 13:50:20 GMT

If you want to read a text file, like the one you posted, use a DATA step.

data code ;
  infile 'clean data.sas' truncover ;
  row+1;
  input code $char200.;
run;

If you want to write data into Excel you can use PROC EXPORT, or the XLSX libname engine or the ODS EXCEL engine.

Kurt_Bremser — Tue, 07 Feb 2023 17:42:22 GMT

Why do you want to make SAS code unusable by storing it in a spreadsheet file?