I have a dataset ds1. I want to have a list, that shows me how many missing values there is per (numeric) variabel. I know I can get this by simply using a proc means:    data ds1; input kon $ age ss; cards; M 20 1 K 22 2 M 24 2 M . . K . . . . . ; run;   proc means data=ds1 NMISS N; run;   But is it possibel to get the exact result output  (se attachments) I get from the proc means into a actual dataset, so I use that for further analysis? I want to use it to calcute late the response rate for each variabel/question.            ... View more

I have a simple dataset with two variable called "cc" and "ss", and I want to rename them using a datastep like the following:   data new_data;      set old_data;      rename cc=vcc ss=vss; run;   After the datastep, I run a proc contents to see that the variable names are change correctly - which they are. But if I then afterwards opens the actual new dataset, where the new variable name should be assigned, then I can't see the newly assigned names - like nothing have happend at all.   Does anyone know, why this happens and how I can fix it?  ... View more

I need to generate a new variabel that horizontally count the number of variabels out of a total of 9 numeric variabels that contains a none missing value. I've figured out to do so with a missing value, but how can I change the code, so instead of '.' it will be any value "not equal" to a missing value?    data have; set want; countvar = countc(catt(of var1 - var9), '.'); run;   (I still haven't worked with arrays, so I would appreciate a very simple code, ex based on the code above)   Thanks... ... View more

I want to compute a new numeric variabel, "Psum", as the sum of 5 other numeric variable, P1, p2, p3, p4, p5. A simpel way to do it could be:  Psum= p1+p2+p3+p4+p5; Some datalines includes missing values for the five variables, which will result in a missing value for the new variabel for these datalines.   Is there any way to get around this? I want to sum up the variabels, but I want SAS just to "ignore" if there is a missing value in one or more of the five variables and sum of the rest. I have thought about changning all the missing values in these 5 variable into the value of "0", but I would prefer to use a procedure that just ignores the missings values.  ... View more

 I have a +70 variables in my dataset which I need to change formats on from character variables to numeric. All of the variables names is similar sn_1, sn_2, ....    I plan to use the follow procedure to change the formats:  data work.xx sn_1n=input(sn_1, best8.); run;   Is there anyway that I can change the formats of all my variables in single procedure or do I need to do it "manually" for every single one of my variables?  ... View more