topic Re: Using EG to transform Semi Structured Log Data in SAS Enterprise Guide

Using EG to transform Semi Structured Log Data

nat1 — Tue, 02 Aug 2016 01:59:17 GMT

Hi, I have a data set in CSV that looks like the following. T1 - T29 are actually the column names for the data columns that follows at the bottom.

How do I use SAS EG to assign the column names (T1, T2, T3, etc) to the columns that i extracted using the import wizard as seen below, instead of the default column names F1, F2, etc?

Appreciate any input! thanks very much

Regards

Nat

Re: Using EG to transform Semi Structured Log Data

Ksharp — Tue, 02 Aug 2016 02:43:45 GMT

If you know the exactly number of variables, that would be easy.

data want;
 set have(rename=(F1-F29=T1-T29));
run;

Re: Using EG to transform Semi Structured Log Data

nat1 — Tue, 02 Aug 2016 03:24:07 GMT

Thanks but the column names are actually the ones hidden in black (for confidentiality purposes), so its not as easy as "T1" and "T2" etc. It looks something like P1TU45S and Q_24FTG, etc.

I tried to import that column separately and transpose so I would have a table with a single row where the column name is the same as the data in the first row. I thought it would work if I appended these two tables but it didnt.. furthermore the formats don't match (i.e. column name table has all characters and data table is numeric, hence no match).

Any suggestions?

Regards,

Nat

Re: Using EG to transform Semi Structured Log Data

Ksharp — Tue, 02 Aug 2016 04:11:53 GMT

If you can make a MAP file to display how to rename them, That would be easy.


data map;
input old $ new $;
cards;
F1 T1
F2 T2
;
run;

data _null_;
 set map end=last;
 if _n_=1 then call execute('proc datasets lib=work nolist nodetails;modify have;rename ');
 call execute(catx('=',old,new));
 if last then call execute(';quit;');
run;