topic A lock is not available for a dataset in New SAS User

A lock is not available for a dataset

walkerel — Sun, 10 Nov 2019 23:29:56 GMT

DATA	HypTabs.Vitals (LABEL = "Vital Signs");

	ATTRIB SSN LABEL = 'Social Security Number'
		   VisitDt LABEL = 'Visit Date' FORMAT = DATE9.
		   HtIn LABEL = 'Height (In)' LENGTH = 8.
		   WtLb LABEL = 'Weight (Lb)' LENGTH = 8.
		   SBP LABEL = 'Systolic BP (mmHg)' LENGTH = 8.
		   DBP LABEL = 'Diastolic BP (mmHg)' LENGTH = 8.;
		   
	KEEP SSN VisitDt HtIn WtLb SBP DBP;
	
	SET	WORK.Vitals_IA
		WORK.Vitals_MS
		WORK.Vitals_UT2;
	
	RUN;

PROC SORT DATA = HypTabs.vitals;
	BY SSN VisitDt HtIn WtLb SBP DBP;
	RUN;
	
PROC CONTENTS DATA = HypTabs.Vitals VARNUM;
	RUN;
	
PROC PRINT DATA = HypTabs.Vitals (OBS = 1);
	RUN;

When I enter in the code above, I get several errors saying that a lock is not available for the data set. I'm not quite sure what this error message is telling me and I am also not sure how to fix it as it shows up after every single run statement.

Re: A lock is not available for a dataset

r_behata — Mon, 11 Nov 2019 00:22:22 GMT

Please show the entire log.

Re: A lock is not available for a dataset

Patrick — Mon, 11 Nov 2019 00:43:20 GMT

Table HypTabs.Vitals must be locked by another process (like another EG session having the table open).

Below two procedures require only read access to the table. Can you execute these two (without executing the code before)?

PROC CONTENTS DATA = HypTabs.Vitals VARNUM;
	RUN;
	
PROC PRINT DATA = HypTabs.Vitals (OBS = 1);
	RUN;

If you can't then some other process must be locking the table in write access. If you can then there must be another process locking the table with read access.

Re: A lock is not available for a dataset

jvdl — Mon, 11 Nov 2019 07:42:52 GMT

If the data is stored in a shared location and another programmer is working on the same project, they might have had the data open at the same time as you.

Re: A lock is not available for a dataset

Kurt_Bremser — Mon, 11 Nov 2019 08:00:40 GMT

Is it reported as "locked by another process", or "locked by you in environment ..."?

Please post the whole log of all these steps.