Extracting the data from SAS format

[drvasu]

Hi, 

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

[SASJedi]

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]

I would like to get the details of the codes 

[PaigeMiller]

---

@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]

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]

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