topic Re: export varlist column names into dataset in SAS Programming

export varlist column names into dataset

radha009 — Tue, 17 Apr 2018 18:42:26 GMT

creating a dataset with proc sql from two tables. In onetable i have varlist. column names. i want to display the column names as per our req. order.

proc sql noprint;
select name into :varlist separated by ' '
from dictionary.columns
where
libname = "PATCH" and
memname = "table1" and
name like '%CHG%';
quit;

Expected:

ID	Name	support by	microVar1	microvar2	microvar3	owner	App
1	abc	a	yes	yes	yes	y	r
2	xyz	d	no	no	no	h	d
3	ert	f	yes	yes	yes	h	f
4	sap	r	no	no	no	h	c

table 1:
ID	Name	supportby	microVar1
1	abc	a	yes
2	xyz	d	no
3	ert	f	yes
4	sap	r	no

table 2:
ID	Name	microvar2	microvar3	owner	App
1	abc	yes	yes	y	r
2	xyz	no	no	h	d
3	ert	yes	yes	h	f
4	sap	no	no	h	c

The microvar name is displaying from the varlist. How do i put all in one dataset

Re: export varlist column names into dataset

Kurt_Bremser — Tue, 17 Apr 2018 18:49:08 GMT

That's a simple data step merge by id name; that varlist stuff is not necessary.

@radha009 wrote:

creating a dataset with proc sql from two tables. In onetable i have varlist. column names. i want to display the column names as per our req. order.

proc sql noprint;
select name into :varlist separated by ' '
from dictionary.columns
where
libname = "PATCH" and
memname = "table1" and
name like '%CHG%';
quit;

Expected:

ID Name support by microVar1 microvar2 microvar3 owner App

1 abc a yes yes yes y r

2 xyz d no no no h d

3 ert f yes yes yes h f

4 sap r no no no h c

table 1:

ID Name supportby microVar1

1 abc a yes

2 xyz d no

3 ert f yes

4 sap r no

table 2:

ID Name microvar2 microvar3 owner App

1 abc yes yes y r

2 xyz no no h d

3 ert yes yes h f

4 sap no no h c

The microvar name is displaying from the varlist. How do i put all in one dataset

Re: export varlist column names into dataset

radha009 — Tue, 17 Apr 2018 19:03:57 GMT

i am able to merge the data, but the order is displaying as below. My expected order is different

Name

support by

owner

App

microvar1

microvar2

microvar3

Re: export varlist column names into dataset

SuryaKiran — Tue, 17 Apr 2018 19:14:25 GMT

You can use RETAIN to re-order the variables in a dataset.

data want;
retain Height Weight Name;
set sashelp.class;
run;

Re: export varlist column names into dataset

Kurt_Bremser — Wed, 18 Apr 2018 05:45:30 GMT

Do you need that somehow automated?

I use an "empty" format statement (only variable names, no formats) to force an order of variables.

But frankly, this is a non-issue. SAS adresses variables by name, so the horizontal position in the dataset is irrelevant. When you need reports or eports or such ordered, force the order there.