Close the data (SAS Guide 8.3)

SASdevAnneMarie — Fri, 14 Jan 2022 08:32:28 GMT

Hello Experts,

I'm working on SAS Guide 8.3. I have the error because the data remains open (in yellow) after the code execution. There are some options please to close the data, please ? Thank you !

%macro cleartemplib(libtofree);
	%if %sysfunc(libname(&libtofree)) ne 0 %then
		%put NOTE: Libref &libtofree could not be unassigned;
	%else %put NOTE: Libref &libtofree has been unassigned;
%mend;


%macro Affectation (libref= , metaLibName= );
	
	%cleartemplib(&libref);


	libname &libref meta library="&metaLibName";
%mend Affectation;

%Affectation(libref= PSAEU11, metaLibName= PEGASE - PSAEU11);

%let Rep_Travail			= \\lamondiale.com\LMPAPROD\USINE_PRIIPS\;
%let EntreesManuelles  		= &Rep_Travail.2. DONNES INPUT\2.1 DONNEES MANUELLES;
%let EntreesManuellesBis	= &Rep_Travail.\5. RETRAITEMENTS MANUELS\Chaine Produits;
%let EntreesPDFemtn			= &Rep_Travail.2. DONNES INPUT\2.2 PDF EMTN;
%let Sorties 				= &Rep_Travail.4. DONNEES OUTPUT;
%let Publications			= &Rep_Travail.6. PUBLICATIONS\6.1 DICTIONNAIRES DE DONNEES;
%let ArchivesPublications	= &Rep_Travail.6. PUBLICATIONS\6.1 ARCHIVES PUBLICATIONS;
%let SortiesPDFemtn			= &Rep_Travail.6. PUBLICATIONS\6.2 PDF EMTN;
%let SortiesFicemtn			= &Rep_Travail.6. PUBLICATIONS\6.4 FICHIERS_EMTN;


Data _null_;
	DateInitiale='01JAN2018:00:00:00'dt;
	Call symputx('DateInitiale',DateInitiale);
	DatePublication=today();
	Call symputx('DatePublication',DatePublication);
run;


Data _null_;
	YYYY=year(&DatePublication);

	if month(&DatePublication) < 10 then
		MM=compress(("0"!!month(&DatePublication)));
	else MM=month(&DatePublication);

	if day(&DatePublication) < 10 then
		DD=compress(("0"!!day(&DatePublication)));
	else DD=day(&DatePublication);
	DatePubli=compress(YYYY!!MM!!DD);
	Call symputx('DatePubli',DatePubli);
run;

%put  &DatePubli;


proc import 
	datafile= "&EntreesManuellesBis\xxxxxx"
	out=PRODUITS_PRIIPS
	replace dbms=xlsx;
	getnames=yes;
	range="SAS_IMPORT";
run;


proc import 
	datafile= "&EntreesManuelles\xxxx"
	out=EMTN_EXCLUS
	replace dbms=xlsx;
	getnames=yes;
run;

Re: Close the data (SAS Guide 8.3)

JosvanderVelden — Thu, 13 Jan 2022 13:39:46 GMT

How are you terminating the data creation code?
If you are using proc sql you probably should end with quit;
Can you provide the code?

Best regards, Jos

Re: Close the data (SAS Guide 8.3)

SASdevAnneMarie — Fri, 14 Jan 2022 08:34:14 GMT

Hello,

Thank you, I added the code to my main message. The table PRODUITS_PRIIPS remains open.

Re: Close the data (SAS Guide 8.3)

JosvanderVelden — Fri, 21 Jan 2022 17:10:09 GMT

Hi Marie,
Were you able to solve this?
The code you provide is not enough to be able to help in solving.
Do you have an active libref to the xlsx-file?
If yes then you need to clear that libref so that the xlsx-file is released.

Best regards, Jos

topic Re: Close the data (SAS Guide 8.3) in SAS Programming

Close the data (SAS Guide 8.3)

Re: Close the data (SAS Guide 8.3)

Re: Close the data (SAS Guide 8.3)

Re: Close the data (SAS Guide 8.3)