topic Re: Creating new column and renaming the values in SAS Programming

Creating new column and renaming the values

Solly7 — Wed, 12 Aug 2020 10:07:15 GMT

Hi, I need help in creating/adding a new column onto an existing data..I need to add new column and rename it as 'notes', then rename all the column values as 'Baseline' under 'notes' column

Data Have ( Table name = financial_transactions)

policy_no Amount

1 100

2 200

3 300

4 400

Data Want

policy_no Amount Notes

1 100 baseline

2 200 baseline

3 300 baseline

4 400 baseline

Re: Creating new column and renaming the values

PeterClemmensen — Wed, 12 Aug 2020 10:21:50 GMT

Like this?

data have;
input policy_no Amount;
datalines;
1 100
2 200
3 300
4 400
;

data want;
   set have;
   retain notes 'baseline';
run;

Re: Creating new column and renaming the values

Solly7 — Wed, 12 Aug 2020 10:28:12 GMT

Absolutely perfect..its working as expected. thank you very much

Re: Creating new column and renaming the values

PeterClemmensen — Wed, 12 Aug 2020 10:30:55 GMT

Anytime

Re: Creating new column and renaming the values

gamotte — Wed, 12 Aug 2020 13:29:13 GMT

Hello,

Are you sure you need to do that ? If your dataset is big, you will use a lot of additional storage space for very few information (no observation specific information).

Maybe, you could just use a macrovariable :
%let notes=baseline;

Or, if you have different datasets with distinct notes, you can create
a dataset which associates dataset names to their corresponding notes.

data notes;
input dsname $ notes $;
cards;
have baseline
...
;
run;

What will this new column eventually be used for ?