Hi Reeza and PGStats, the thread has been solved thanks to PGStat's original post. I mis-coded my array earlier, hence it didn't work. I realised my error and found that PGStat's solution worked perfectly. Thanks for your help!!
... View more
Hi Reeza,
Thanks for your reply. I am thinking of an array to change the values.
Essentially, I have several hundred numeric variables, where 1 = yes, 2 = no, 3 = don't know.
I wish to change all the '3's to missing.
Here are some examples of variable names that I have:
a1_1-a1_8 b1_1-b1_9 b1n2_1-b1n2_7 c1n3_1-c1n3_9 d1-d10
The issue is that when I tried using an array, it wouldn't read in the variables "a1_1-a1_8". It comes up with an error saying:
Syntax error, expecting one of the following: an integer constant, *.
... View more
Hi,
I have a dataset with a bunch of variables: a1-a20 (i.e. a1, a2, ... a20), b1-b10, c1-c10.
All of the variables have the same attributes (all numeric): 1 = yes, 2 = no, 3 = don't know.
Is there a quick way to change all the variables, such that whenever the value is 3, it is set to missing, for all variables in the dataset?
Thanks!
the dataset looks like this:
a1 a2 a3... b1
1 2 1 ...3
etc.
... View more
Thanks for the help! I tried both methods and they both worked For my purposes i am using a proc sql, but E.G. task solution is pretty neat too
... View more
Hi, suppose if I have a dataset, that looks like the one below: ID Age Gender 1 0 M 2 2 F 3 5 F 4 4 F 5 1 M 6 4 M 7 1 M 8 1 F 9 2 F 10 2 M 11 2 M 12 3 F 13 4 M 14 5 M 15 6 F The proc-freq output for Age * Gender is below: Age F M 0 1 0 1 1 2 2 2 2 3 1 0 4 1 2 5 1 1 6 1 0 I want to modify the proc freq step so that: 1. It exclude rows (i.e. age) where either male or female has a count of 1 or less, so that the proc freq will look as below: Age F M 5 2 2 2. AFTER excluding rows where counts <= 1, then it outputs the row percentages using PCT_ROW. Is there any way I can do that in proc freq? Thanks very much!
... View more