topic Re: How to create observation in a variable which has existing observations in New SAS User

How to create observation in a variable which has existing observations

shanky_44 — Tue, 19 Feb 2019 21:37:06 GMT

Hello everyone,

I am new to SAS and trying to learn as much as possible. While practicing, I came across a data set in which I need to create a variable with particular observations. I think this problem can be solved from first. and last. observation. However, expecting experts feedback and please provide alternate solutions as well as, if possible. Thanks !

Problem ;

data is similar to this scenario: new var is a character variable

name country gender New_var

x Y M D1

x1 Y1 F D2

X2 Y2 M D1

X3 Y3 M D2

Here I have created new_var and I have D1 and D2 values but I need to have D1 +D2 observation is same variable along existing observation.

Re: How to create observation in a variable which has existing observations

PGStats — Tue, 19 Feb 2019 21:50:31 GMT

I suggest you start by reviewing the definitions of Observation and Variable in SAS. Then you might want to reword your question.

Re: How to create observation in a variable which has existing observations

Reeza — Tue, 19 Feb 2019 21:53:26 GMT

This may be easier if you show what you have as a starter and what you want as the final output. I *think* you're starting with name, country, and gender, and you're trying to calculate New_var?

Re: How to create observation in a variable which has existing observations

VDD — Wed, 20 Feb 2019 01:24:11 GMT

Wow that is almost confusing.

Please post a sample dataset of what you want and the SAS code you have tried. Your sample code might assist the community with understanding your request.

Re: How to create observation in a variable which has existing observations

shanky_44 — Wed, 20 Feb 2019 14:11:38 GMT

this is the shell. ROI variable is not in our data, I have created ROI varibale with ROI 1 and ROI 2 observation in data set with the help of one variable. Now I want ROI 1 + ROI 2 in same variable with other observation. I know it is not explained well but in this platform and the technicality of work, I am not able to explain everything. I apologize and thanks for everyone for trying to help me out.

Re: How to create observation in a variable which has existing observations

shanky_44 — Wed, 20 Feb 2019 14:19:36 GMT

Hi Reeza,

Actually, it is a lengthy work I can share everything here. I have posted a shell above and I have to create listing for that. The issue was variable ROI is not in our data so i have created a variable in data set and populated the value on the basis of other variable. But I need one more observation which should be ROI 1 + ROI 2 . I was not clear how to get that. I am really sorry it is still messed up. I am not able to explain clearly, but thanks for the help. while posting this, I think I got the answer. Thanks.

Re: How to create observation in a variable which has existing observations

Reeza — Wed, 20 Feb 2019 16:05:29 GMT

Look up multilabel formats, with PROC MEANS or TABULATE is likely what you need.

Or PROC TABULATE can do it all at once.

proc tabulate data=sashelp.class;
class sex age;
var height;

table (sex all = 'M + F')* age , height*(mean median min max);
run;

Re: How to create observation in a variable which has existing observations

shanky_44 — Wed, 20 Feb 2019 18:35:32 GMT

Hi Reeza,

This problem is more about creating dummy variables and then transpose them on some parameters. By the shell it looks like it is calculation scenario but it is not. Even I have not clarified the things properly here because it is a lengthy process and I am just asking in mid where ever I get struck. Thanks for the help!

Re: How to create observation in a variable which has existing observations

Reeza — Wed, 20 Feb 2019 20:44:09 GMT

I think you need to go back and answer this question then, I'm clearly not the only confused by your question.

This may be easier if you show what you have as a starter and what you want as the final output

Also, dummy variables aren't needed for most procedures, SAS will create them automatically. If you need to create dummy variables, there are several easy ways to do so and then you can test the various hypothesis using contrast statements.

@shanky_44 wrote:

Hi Reeza,

This problem is more about creating dummy variables and then transpose them on some parameters. By the shell it looks like it is calculation scenario but it is not. Even I have not clarified the things properly here because it is a lengthy process and I am just asking in mid where ever I get struck. Thanks for the help!

Re: How to create observation in a variable which has existing observations

shanky_44 — Mon, 25 Feb 2019 17:01:31 GMT

Hi Reeza,

Yeah, I know and I apologize for that. This is a listing format and a long process. I am just asking where i am confused with either data orientation (transpose rule) or new dummy data creation. I would not be able to share data here. However, I am really thankful for your efforts. At least I have learned one new thing which you mentioned in Proc tabulate.

I hope you will understand. and I will try to explain better next time for further queries.

Thanks Everyone!

Shanky