Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Assign value to blank variable
You are ridiculously talented genius. This worked perfectly! Many thanks!!!- Starbury
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Assign value to blank variable
I have a file with about 20,000 observations, but the variable A is blank in the vast majority of observations. All other variables have values for every observation. The first observation provides a value for the variable A. I want to assign all successive observations with blank values the...- Starbury
- Thread
- Replies: 2
- Forum: SAS Institute, Inc. solutions
-
[b]SAS equivalent to MS Excel RANK function[/b]
Well, that does it for me, but I want put the results back into the data step. GOAL: Var A is 613 unique observations. Var B is a the rank of the Var A Var C = 490th highest value of Var A Var D = If Var B<=410th highest value of Var A Then (C-A) Else 0; Var A is dependent on previously...- Starbury
- Post #3
- Forum: SAS Institute, Inc. solutions
-
[b]SAS equivalent to MS Excel RANK function[/b]
Is there a SAS equivalent to the RANK function in MS Excel>- Starbury
- Thread
- Replies: 3
- Forum: SAS Institute, Inc. solutions
-
Use sum of variable in another variable
Thank you, Klaz! It works! Also, I did not know that I could use proc sql to make a macro variable. http://www.cognigencorp.com/perspective/tipsNtricks.pub/1/PROC%20SQL%20Talk_12_.ppt proc sql; select mean(rhin_age) into: meanage from orcl.pat_survey1 where...- Starbury
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Use sum of variable in another variable
I have a variable A and variable B and each has 613 observations. Variable C = A/B. I want to create variable D within the data step that divides sum total of variable A by sum total of variable B. Yes, variable D will be same value for all 613 observations. I cannot use a macro as a constant...- Starbury
- Thread
- Replies: 2
- Forum: SAS Institute, Inc. solutions
