SAS Support Communities

Xiaoningdemao · ‎07-18-2016

No, I didn't. But this is very helpful as well! Thanks again. Best,

Xiaoningdemao · ‎07-18-2016

hi dallardw, But I did put keep and drop in one data step before, i didn't recall any weird result though.... O_O Best,

Xiaoningdemao · ‎07-18-2016

Dear Reeza, Thank you very much! This is exactly what I want!! Best,

Xiaoningdemao · ‎07-18-2016

And since the 1000 variables we have here has both numerical and character variables I cannot simply transpose it.

Xiaoningdemao · ‎07-18-2016

Hi PG, I meant the variable 'keep' stores the variable names I want to keep, 'drop' stores the variables I want to drop, we only need to use one of it. But i don't know which is easier to use. @PG Stats@PG Stats

Xiaoningdemao · ‎07-18-2016

Dear All, I have a question about drop / keep variables. Now I have such a data set: age gender height keep drop 10 1 160 age gender 11 2 159 * height 8 1 161 * * So the first three variables are the observation info, and the last two variables listed the variables that I want to kee/drop. So the desired fresult would be: age 10 11 8 I can not use keep or drop because the actual data set contains almost 1000 variables, it is unrealistic to list them. I have been struggled with this for almost two days. Thank you in advance!! Best, Thank

Xiaoningdemao · ‎07-15-2016

OK, I see. Thank you!!! @KachiM

Xiaoningdemao · ‎07-14-2016

Hi @ballardw, Thank you!! But I meant the code you fist provided me produced a proc freq of each character variable. Result like this: N Gender 11,972 male 1220 female 30 But the value I wanted is the number of nonmissing values in this example 1220+30=1250. I'm wondering is there a solution to get this value? thanks again!! Best,

Xiaoningdemao · ‎07-14-2016

Dear @SuzanneDorinski, Thank you so much for working on this problem and wrote such a nice code with all comments on! But the data set i'm dealing with is very large, this code takes a lot time(about 10 minutes). Sorry I didn't accept this as solution...... Since i am a beginner in SAS, i did learn a lot from your code. Thanks again!! Best,

Xiaoningdemao · ‎07-14-2016

This is perfect! I got exactly what I want!! Just to double check with you, I just need to change all the "100" in this code to the number of obs in my data set, right? @KachiM

Xiaoningdemao · ‎07-14-2016

thank you your help!!! But the result looks like a proc freq for each character variable, but I just want a count of non-missing, instead add them up manually do you have other solution? since the data set I deal with now have almost 1000 variables, so go through them one by one is not very realistic....

Xiaoningdemao · ‎07-13-2016

Hi All, The program: proc tabulate data=sashelp.class f=comma6.0; title ; var _numeric_; table _numeric_, nmiss n/ box='Variable'; run; can be used to count non-missing values for numerical variable, I also want count for character variable, could you help me modify this code to achive my goal? Thanks a lot! Best wishes,

Xiaoningdemao · ‎07-13-2016

Hi Cynthia, Your program: proc tabulate data=sashelp.class f=comma6.0; title '2) PROC TABULATE equivalent of MEANS output'; var _numeric_; table _numeric_, nmiss n / box='Variable'; run; count non-missing values for numerical variable, I also want count for character variable, could help me modify this code to achive my goal? Thanks a lot! Best wishes,

Xiaoningdemao · ‎06-14-2016

Hi data_null__, I post the question named as "Delete obsvations with certain strings". Thanks a lot!

Xiaoningdemao · ‎06-14-2016

Hi all, Say I have the following observations: fruit apple apple comments pear pear comment banan I want to delete those have 'comments' and 'comment'. I wrote code as data mock; set mock0; run; data mock; modify mock; where fruit contains 'comment' and 'comments'; remove; run; But it doesn't remove those with 'comments'. Can I do thses two select at once? Thanks alot!

Online Status	Offline
Date Last Visited	‎11-13-2019 05:31 PM

SAS Support Communities

Re: record observations count by ID

Re: record observations count by ID

record observations count by ID

Re: How to perform t test on slope in proc reg

Re: How to access old output result

Re: How to perform t test on slope in proc reg

Re: How to access old output result

How to perform t test on slope in proc reg

Re: How to access old output result

How to access old output result

Re: record observations count by ID

Re: record observations count by ID

Re: How to access old output result

Re: proc score with no intercept

Re: date time format

proc score with no intercept

Re: apply a new data set to a logistic regression model

Re: Keep/Drop variables based on one variable

Re: Keep/Drop variables based on one variable

Re: Keep/Drop variables based on one variable

Re: Keep/Drop variables based on one variable

Re: Keep/Drop variables based on one variable

Keep/Drop variables based on one variable

Re: count missing value for character variable

Re: count missing value for character variable

Re: count missing value for character variable

Re: count missing value for character variable

Re: count missing value for character variable

count missing value for character variable

Re: Proc Means and CSV file

Re: Delete observations that CONTAIN in a variable a certain word

Delete obsvations with certain strings

Follow Us

What is...