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 ... View more

Dear experts, Need help on looping column names (varlist) and create a new table with unique name and id.     proc contents data=patch.Windows_patch out=patch.contents noprint; run; proc sql ;    select name into :varlist separated by ' '   from patch.contents where name like '%CHG%'; %let n=&obs; quit;   proc sql; do i = 1 to dim(Patch) ;     create table Patch.Patch(i) as select unique a.Name, a.CI_ID, B.App, b.App_ID from Patch.Troux a, Patch.Win_servers b         where a.CI_ID=b.App_ID and b.Patch(i) is not null order by a.Name; end; quit; ... View more

my excel data has the strike data. when i import in sas the strike data also imported and considering as real data. How can i clear the strike data and import the excel in sas   ... View more

i have multiple data sets (4 sas tables) want to export to excel in one sheet. ... View more