topic Re: how to keep the dataset label while dropping few variables in SAS Programming

how to keep the dataset label while dropping few variables

vraj1 — Mon, 30 Sep 2019 12:07:10 GMT

I have a code where i am dropping variables which are not needed but it also removes the label of the datasets. Can anyone help me in how to prevent it.

code used is

call execute(
"data &outlib.." || compress(dataset) || "(drop=" || trim(varlist)
|| ");" || "set &outlib.." || compress(dataset)
|| ";" || "run;"
);

Re: how to keep the dataset label while dropping few variables

FreelanceReinh — Mon, 30 Sep 2019 13:05:09 GMT

Hello @vraj1,

Use PROC SQL to drop the variables in order to preserve the dataset label, e.g., like this:

call execute(
"proc sql; alter table &outlib.." || compress(dataset) || " drop " 
|| translate(trim(varlist),',',' ')|| "; quit;"
);

(Ideally, you would create VARLIST as a comma-separated list in the first place.)

Re: how to keep the dataset label while dropping few variables

vraj1 — Thu, 03 Oct 2019 11:12:33 GMT

This is failing if my varlist has only one variable to drop

"proc sql; alter table &out.." || compress(dataset) || " drop "
|| translate(trim(compbl(varlist)),',',' ')|| "; quit;"
);

I get the below error:

3 + proc sql;
NOTE: Line generated by the CALL EXECUTE routine.
3 + alter table sE drop ,BEY;
-
22
ERROR 22-322: Expecting a name.

Re: how to keep the dataset label while dropping few variables

FreelanceReinh — Thu, 03 Oct 2019 11:42:20 GMT

Hi @vraj1,

The problem is actually not that varlist contains only one variable name, but that it apparently contains a leading blank (which is then "TRANSLATEd" into a leading comma, which in turn is invalid after "DROP"). The solution is very easy: Just replace "trim" by "strip" to remove both trailing and leading blanks from varlist.

(The risk of stray blanks being translated into commas was the reason why I recommended a comma-separated list in varlist.)