topic Re: reading from control files the dynamic variables name in SAS Enterprise Guide

reading from control files the dynamic variables name

SASuserxx — Wed, 20 Jul 2016 05:26:48 GMT

Hi All,

i need help on finding a way to read column names from a control table but this control table can be updated by end users by proc import. any idea is useful for me to experiment.

Below is the dynamic label i need to display to my dataset2. this can be change by users at any time.

examples.

col1 can be "apples" but then i can change it to "animals"

dataset1.

colname	dynamic label to display
col1	apples
col2	grapes
col3	banana

datset2.

this dataset ( eg. col1 etc is the one that need to display by the name in the control table above )

date	col1	col2	col3
1/07/2016	1	0	1
8/07/2016	0	1	1
15/07/2016	0	0	1

Thank you

Re: reading from control files the dynamic variables name

Reeza — Wed, 20 Jul 2016 05:43:59 GMT

Whats your question? Which part of the process do you need help with?

Re: reading from control files the dynamic variables name

Reeza — Wed, 20 Jul 2016 05:44:51 GMT

Proc import will read the file from Excel or your source text file.

Re: Controlling for variable

SASuserxx — Wed, 20 Jul 2016 06:09:28 GMT

Hi Reeza,

thanks for replying.

im not looking to analysis the variables. i just want to rename like a label, except that label is changeable when a user updates the dataset.

sorry wasnt clear in my post.

thanks

Re: reading from control files the dynamic variables name

Ksharp — Wed, 20 Jul 2016 06:10:30 GMT

It is easy, as long as you have dataset1.

data dataset1;
infile cards expandtabs;
input colname $ label $;
cards;
col1	apples
col2	grapes
col3 	banana
;
run;
 
data datset2; 	 
infile cards expandtabs;	 	 
input date : $20. col1 col2 col3 ;
cards;
1/07/2016	1	0	1
8/07/2016	0	1	1
15/07/2016	0	0	1
;
run;

proc sql noprint;
select cats(colname,'="',label,'"') into : label separated by ' '
 from dataset1;
quit;
proc datasets library=work nolist nodetails;
modify datset2;
label &label ;
quit;

proc print data=datset2 noobs label;run;

Re: Controlling for variable

Reeza — Wed, 20 Jul 2016 06:21:07 GMT

As long as run the process from beginning to end each time it's updated its fine. @Ksharp solution is exactly what I would suggest 🙂

If you want a trigger to update the dataset when the file is updated that's an order of magnitude difference.

FYI - this seemed to be posted in the wrong thread. I've moved it here.

Re: reading from control files the dynamic variables name

SASuserxx — Wed, 10 Aug 2016 03:34:16 GMT

Hi ksharp

sorry, ive been away.

the code works however im not sure why i get this error.

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: reading from control files the dynamic variables name

SASuserxx — Wed, 10 Aug 2016 05:52:35 GMT

hi,

please disregard the last posting, i found the answer.

thank you

Re: reading from control files the dynamic variables name

Reeza — Wed, 10 Aug 2016 06:14:48 GMT

@SASuserxx Please mark the correct solution please.

Re: reading from control files the dynamic variables name

SASuserxx — Wed, 10 Aug 2016 06:32:22 GMT

@Ksharp provided the correct solution

data dataset1;

infile cards expandtabs;

input colname $ label $;

cards;

var1 apple

Var2 banana

Var3 grape

;

run;

data datset2;

infile cards expandtabs;

input date : $20. Var1 Var2 Var3 ;

cards;

1/07/2016 1 0 1

8/07/2016 0 1 1

15/07/2016 0 0 1

;

run;

proc sql noprint;

select cats(colname,'="',label,'"') into : label separated by ' '

from dataset1;

quit;

proc datasets library=work nolist nodetails;

modify datset2;

label &label ;

quit;

proc print data=datset2 noobs label;run;

Re: reading from control files the dynamic variables name

Reeza — Wed, 10 Aug 2016 06:47:13 GMT

@SASuserxx If you navigate to his post you mark that solution as the answer and the question as solved.

Re: reading from control files the dynamic variables name

SASuserxx — Mon, 15 Aug 2016 04:26:55 GMT

Hi ,

last question, how to do i change to a dataset of the modified data rather than a proc print the result.

thanks

Re: reading from control files the dynamic variables name

Ksharp — Mon, 15 Aug 2016 05:09:46 GMT

The dataset has already been modified.
You can remove PROC PRINT, and use PROC CONTENTS to see what happened.

Re: reading from control files the dynamic variables name

SASuserxx — Mon, 15 Aug 2016 05:15:02 GMT

hello,

thanks for replying

i have already tried proc content, however, the modified table will then be used to join to another table to create a new dataset

i just want instead of printing the data ; for it to be a dataset that can be used to create other dataset.

thanks

Re: reading from control files the dynamic variables name

Reeza — Mon, 15 Aug 2016 05:58:40 GMT

Proc print requires a dataset to print. Isn't that the same dataset you want, ie dataset2 from @Ksharp solution.

The print is only for demonstration purposes.

Re: reading from control files the dynamic variables name

SASuserxx — Tue, 16 Aug 2016 03:05:16 GMT

Hi Both,

thanks for replying

Yes, I understand that proc print demonstrate. ive also tried the suggestion already.

I tried the dataset2, however it just gives me the orginal dataset2 with the VAR1,2,3

1/07/2016 1 0 1
8/07/2016 0 1 1
15/07/2016 0 0 1

Just wanting to know what option can you suggest to output the modified datset2 with the new labels as a dataset rather than a sas report

Re: reading from control files the dynamic variables name

Ksharp — Tue, 16 Aug 2016 03:32:21 GMT

If you need this table be used to join to another table ,
Then apply my code on your final dataset .not the temporary table.

Re: reading from control files the dynamic variables name

Reeza — Tue, 16 Aug 2016 03:47:34 GMT

Datset2 doesn't have the labels after the proc datasets?

That doesn't seem correct, otherwise how can Proc print display it correctly?

Re: reading from control files the dynamic variables name

SASuserxx — Tue, 16 Aug 2016 04:52:28 GMT

Hi Ksharp,

yes i have applied it and it works perfect.

just that when i open the dataset2, its not the modified version

i attached the file

Re: reading from control files the dynamic variables name

Reeza — Tue, 16 Aug 2016 06:00:44 GMT

View your proc contents.

Note that the LABEL is correct, but I'm suspecting you actually want to change the variable name, not the label.

Does that sound correct?