topic Re: How to hide the created variable column from my table in SAS Programming

How to hide the created variable column from my table

Kayla_Tan222 — Thu, 30 May 2019 09:27:07 GMT

Hi, was struggle about how to hide the created variable column from the table.

I don't want it to be shown in the table but I want to use it for calculations afterwards.

Foe example, the variable column that I have created is

yearcount=zclmpd+1

I don't want my table show the yearcount variable.

How can I solve this problem? isit by using %let statement?

Re: How to hide the created variable column from my table

KachiM — Thu, 30 May 2019 11:18:35 GMT

Use

drop yearcount;

Re: How to hide the created variable column from my table

Amir — Thu, 30 May 2019 11:27:16 GMT

Have you considered creating a view with just the columns you want to see?

Some examples are shown in the SAS documentation:

https://documentation.sas.com/?docsetId=sqlproc&docsetTarget=n0nolnbokay91in1gouzgw3xzl5e.htm&docsetVersion=9.4&locale=en

The original table will still have the yearcount variable for you to use later.

Amir.

Re: How to hide the created variable column from my table

PaigeMiller — Thu, 30 May 2019 12:19:23 GMT

@Kayla_Tan222 wrote:

I don't want my table show the yearcount variable.

What method in SAS you are you using to "show" the data? Please be specific.

For example, PROC PRINT and PROC REPORT allow you to show any columns you want and leave out any other columns you don't want. Also, as mentioned by @Amir you can use PROC SQL to create a view with only selected columns and then VIEWTABLE (for example) shows only the columns selected.

Re: How to hide the created variable column from my table

Ksharp — Thu, 30 May 2019 12:41:26 GMT

Create a VIEW and show it to your colleague .

proc sql;

create view want as

select a,b,c,d

from have;

quit;

Re: How to hide the created variable column from my table

Tom — Thu, 30 May 2019 12:47:30 GMT

It is not at all clear what you are trying to do. You cannot "hide" a variable. But there is no reason why you need to "show" variables other than the ones you want.

How are you showing the data?

If you are using a PROC then only list the variables you want.

proc means;
  var a b c ;
run;

Or drop the variable you don't want.

proc print data=mydata (drop=yearcount);
run;

Some procedures, like PROC REPORT, can let you use a variable to control the report but not display the variable's value in the report.

define yearcount / noprint ;