topic Re: Generate a new .sas file from a sas code in SAS Programming

Generate a new .sas file from a sas code

varshabansal — Wed, 18 Oct 2023 07:26:59 GMT

Hello everyone!

I need help please help me, I want write a code to generate a new .sas file from a sas code and a new file at a particular location.

Thanks in advance

I have Extract excel sheet name in sas and want to continue with generate new .sas file from this code.

/**Assign a libname for excel sheet*/
libname inexcel xlsx '/home/viadmin/casuser/mapping.xlsx';

PROC CONTENTS DATA=inexcel._ALL_ noprint
OUT=Sheets (KEEP=Memname);
RUN;

PROC SORT DATA=Sheets NODUPLICATES;
BY Memname;
RUN;

DATA Sheets;
SET Sheets;
ID=_N_;
RUN;

DATA _NULL_;
IF 0 THEN SET Sheets NOBS=X;
CALL SYMPUT('Recount', X);
STOP;
RUN;


%macro Excel;
%DO i = 1 %TO &Recount;
PROC SQL ;
create table sheet&i. as
SELECT Memname INTO :Name
FROM Sheets WHERE ID = &i;
quit;
%end;
%mend;

%excel;

Till here code is working fine. But after this i want to generate new .sas file for different Names like- sheet1.sas, sheet2.sas

Re: Generate a new .sas file from a sas code

andreas_lds — Wed, 18 Oct 2023 07:51:14 GMT

Why do you want to create a program for each sheet? What will happen in those programs?

Re: Generate a new .sas file from a sas code

Kurt_Bremser — Wed, 18 Oct 2023 08:08:58 GMT

Please post your code for the treatment of one sheet.

Re: Generate a new .sas file from a sas code

varshabansal — Wed, 18 Oct 2023 08:21:21 GMT

I want to create different jobs for different sheets.

Re: Generate a new .sas file from a sas code

varshabansal — Wed, 18 Oct 2023 08:32:48 GMT

This is my code:-

/**Assign a libname for excel sheet*/
libname inexcel xlsx '/home/viadmin/casuser/mapping.xlsx';

PROC CONTENTS DATA=inexcel._ALL_ noprint
OUT=Sheets (KEEP=Memname);
RUN;

PROC SORT DATA=Sheets NODUPLICATES;
BY Memname;
RUN;

DATA Sheets;
SET Sheets;
ID=_N_;
RUN;

DATA _NULL_;
IF 0 THEN SET Sheets NOBS=X;
CALL SYMPUT('Recount', X);
STOP;
RUN;


%macro Excel;
%DO i = 1 %TO &Recount;
PROC SQL ;
create table sheet&i. as
SELECT Memname INTO :Name
FROM Sheets WHERE ID = &i;
quit;
%end;
%mend;

%excel;

from this i got sheet names- Sheet1,sheet2,

now i want to generate .sas file for this so that It will be job for sheet.

like- Job_sheet1.sas , Job_sheet2.sas

Re: Generate a new .sas file from a sas code

Quentin — Wed, 18 Oct 2023 12:30:25 GMT

If you want to make a copy of a .sas file, the easiest way is to use your operating systems, COPY command. If you have options XCMD enabled, you could call this command from SAS.

But often having multiple programs (one per sheet) to maintain becomes a difficult mess.

Since you already have one macro in your program, did you consider developing a macro that would process each sheet, rather than creating a separate .sas program for each sheet?

Re: Generate a new .sas file from a sas code

Reeza — Wed, 18 Oct 2023 14:48:02 GMT

Why do you need one for different sheets? Is the processing different? Is it called under different conditions?

Re: Generate a new .sas file from a sas code

varshabansal — Fri, 20 Oct 2023 07:12:01 GMT

data null;
%let path=/home;
%let filename= sheet&i.sas;
%put &=&path.&filename;
file= "&path.&filename.";
put "put line inside the file";
run;