topic Re: Columns used in project in SAS Programming

Columns used in project

sasuser381 — Thu, 27 Sep 2018 13:14:29 GMT

Is there any way to get the list of all columns in a project which are being used? Sashelp.vcolumn will give me all columns from certain tables, not only the ones i used in queries and programs.

Re: Columns used in project

Mar1ene — Thu, 27 Sep 2018 13:23:41 GMT

Hello sasuser381 (creative name ;P),

if you use

proc contents data=TABLE_NAME; run;

you get the table (specified) column names and attributes... is this what you're looking for?

Alphabetic List of Variables and Attributes# Variable Type Len Format Label

4	EMP_BANDS	Char	9	$9.	EMP_BANDS
2	INCOME_BANDS	Char	7	$7.	INCOME_BANDS
5	INT_RATE_MARGIN_BANDS	Char	18	$18.	INT_RATE_MARGIN_BANDS
1	LOAN_BANDS	Char	8	$8.	LOAN_BANDS
6	Loan_Amount	Num	8	18.2	Loan Amount
7	N	Num	8		N

Marlene

Re: Columns used in project

RW9 — Thu, 27 Sep 2018 13:28:09 GMT

SASHELP.VCOLUMNS will only give you columns where libnames have been assigned, i.e. only if SAS Knows about the tables can it give the information. Some further information would be useful. What "project" - i.e. what software are you using. Do you have some sort of setup file?

Re: Columns used in project

sasuser381 — Thu, 27 Sep 2018 13:35:52 GMT

I use SAS EG 7.1. and most of the project is done in query buliders or in a custom program. Can i get the list of all colums that are used in in, without running the project?

Re: Columns used in project

RW9 — Thu, 27 Sep 2018 13:42:26 GMT

I don't believe so. This is a very good reason why you should document your whole process before even starting to code. No point trying to patch it up afterwards.

Run the whole project putting proc scaproc on before will get you all the inputs outputs, and the log will show what code is run. Have fun trying to patch it all together though, you will find out why documenting before even coding is required.

Re: Columns used in project

Reeza — Thu, 27 Sep 2018 14:15:23 GMT

Not that I know of. And if you used any select * or SET it somewhat implies that you've used the entire data set. You can try PROC SCAPROC but I don't think it goes down to that level either.

@sasuser381 wrote:

Is there any way to get the list of all columns in a project which are being used? Sashelp.vcolumn will give me all columns from certain tables, not only the ones i used in queries and programs.

Re: Columns used in project

Mar1ene — Thu, 27 Sep 2018 15:41:38 GMT

Maybe this is useful in what you want to achieve.

http://bi-notes.com/2012/10/sas-code-show-sas-macro-variables/