About Viktoreli

Viktoreli · ‎12-16-2019

Thank you very, much I am incredibly gratefull!

Viktoreli · ‎12-13-2019

I hope this helps! I didnt calculate means or standard deviations, I just put an x there instead. a b c 3 10 1.3095 4 10 0.291 3 25 0.388 4 10 2.91 3 25 0.194 4 25 1.164 4 10 1.121 Variable a(bodyparts) Time periods… 10 25 Total … 3 N=1, c mean = 1.3095 (c STD) N=2, c mean= x (c STD) N=3, c mean = x (c STD) 4 N =3, c mean = x (c std) N =1 c mean = 1.164 ( c std) N=4, c mean = x (c STD) Total N =4, c mean = x (c std) 7 , c mean = x (c STD)

Viktoreli · ‎12-13-2019

Hey! I wan't to create a table with two variables presented in every cell, one presented in number of observations and the other in mean and standard deviation. I couldn't find a good solution on the web and im somewhat new at SAS and could not get it right by myself. I want every cell to have the number of observations of variable a(body part) for every variable b(time period) together with the mean and standarddeviation of c for the same variables. If possible I would also like a column and row of totals. I would be immensly grateful for any help! Variable a(bodyparts) Variable b (time periods) P1 P2 P... Total a(Head) number of a (Head) for b (time period 1). Mean and standard deviation of variable c for variable a and b. a = 80, c = 0.4% (STD=0.04) ... C = total number of a for all b, mean of c for a (head) and total b (+STD) Legs a = 78, c = 0.3% (STD=0.03) ... ... ... Body part ... ... ... ... ... Total ... ... ... All a observations, mean of c(STD of d)

Viktoreli · ‎11-28-2019

Thank you so much:)

Viktoreli · ‎11-28-2019

Good question:)

Viktoreli · ‎11-27-2019

Thanks for your reply! Looked at my code and noticed mistakes when changing the names of the variables. I will try to follow your pointers in the future:)!

Viktoreli · ‎11-27-2019

Hi! I have a code where I remove all observations with the same variable A when variable B is not the same number for that same A. data want(drop=flag); do until (last. a); set have; by a notsorted; if first. a then _iorc_=b; if _iorc_ ne b then flag=1; end; do until (last. a); set have; by a notsorted; if not flag then output; end; run; Now I want to look at the data I removed. I want to remove all observations of variable A where the variable B only has a unqiue number for that A. A B 1 1 2 2 1 2 3 2 4 4 2 4 5 2 5 6 3 1 7 4 2 8 4 1 to A B 1 2 4 2 2 4 3 2 5 4 4 2 5 4 1 Help would be much appreciated!!:)

Viktoreli · ‎11-27-2019

Hi! I have somewhat of a problem that I could not find a solution for. I want to filter out datalines where variable A is not unique for any different variable B and C combination so that only one dataline remain. A B C 1 2 3 5 2 2 3 5 3 2 4 5 4 2 5 4 5 3 1 2 6 3 2 1 7 3 1 2 to A B C 1 2 3 5 2 2 4 5 3 2 5 4 4 3 1 2 5 3 2 1 I would much apreciate any help!

Viktoreli · ‎11-13-2019

Thank you alot!!:)

Viktoreli · ‎11-13-2019

Hi, I have a dataset that looks something like this id ve na ai 1 1 2 3 2 1 2 2 3 3 3 9 4 2 3 11 5 3 2 2 6 3 1 11 And I want to create a table where I have ve on the y axis and on the x axis I want the number of "na" observations for each of its numbers. Like na 1 2 3 ve 1 2 0 1 2 0 0 1 3 1 1 1

Viktoreli · ‎10-04-2019

Thanks alot!

Viktoreli · ‎10-04-2019

Worked great and yielded the same result as patricks! Im very grateful!

Viktoreli · ‎10-04-2019

Should have added that in my lines, b=5 was just an example of a value. I was not clear enough in what I was asking. If an observation meets certain conditions in variable A, I want to remove all observations with the same variable B as the observation that met the conditions for variable A.

Viktoreli · ‎10-04-2019

Hi, I could not find a solution for this problem on the board so I thought I would ask instead. As the long subject line says, If a variable A meets certain conditions then I want to delete all observations with the same variable B as the other observation. If A >10 and B is 5, then I want to remove all variables where B=5. I want this Obs A B 1 5 10 2 11 10 3 1 11 4 9 11 5 12 12 6 3 13 To become this 1 1 11 2 9 11 3 3 13 Thanks in advance!

Viktoreli · ‎09-26-2019

Thank you very much!

Online Status	Offline
Date Last Visited	‎05-04-2021 11:44 AM

Re: Table with two variables in every cell!

Re: Table with two variables in every cell!

Table with two variables in every cell!

Re: Looking at removed group

Re: Looking at removed group

Re: Looking at removed group

Looking at removed group

Filtering data by two variables

Re: Creating a table

Creating a table

Re: Table with two variables in every cell!

Re: Table with two variables in every cell!

Re: Looking at removed group

Re: Looking at removed group

Re: Looking at removed group

Re: Table with two variables in every cell!

Re: Table with two variables in every cell!

Re: Table with two variables in every cell!

Table with two variables in every cell!

Re: Looking at removed group

Re: Looking at removed group

Re: Looking at removed group

Looking at removed group

Filtering data by two variables

Re: Creating a table

Creating a table

Re: Deleteing observation with equal variable as one with certain cond...

Re: Deleteing observation with equal variable as one with certain cond...

Re: Deleteing observation with equal variable as one with certain cond...

Deleteing observation with equal variable as one with certain conditio...

Re: Removing observations where one variable is not unique