Hello,   SAS is running the following code but results are not being generated. I'm running Enterprise Guide 7.12.   %macro abc; data want; set have; %do num=1 %to 25; %if diag_code&num. in ("Z590", "Z591", "Z598") %then dcheck&num.=1; %end; run; %mend; %abc; run;  Thanks ... View more

Hello,   Say that I have a table like this:   Measure1 Measure2 Measure3 Id1 4 2 6 Id2 7 3 9 Id3 8 1 5   And I want Proc SQL to output the following table:   Count Percentage Id1 12 26.7 Id2 19 42.2 Id3 14 31.1   Count is a row's sum and percentage is a row's sum*100/column sum of "Count". How can I go about doing this? Thank you in advance. ... View more

Hello,   I have a very large dataset that needs to be updated using another very large reference dataset. I've tried Proc Sql Update but it is taking a very long time. I've come to know that running Proc Sql Update with Call Execute is a better alternative. I would appreciate it if someone can provide the Call Execute codes for the following Proc Sql:   proc sql; update datawant a set var1=(select var1 from datahave where a.var=var), var2=(select var2 from datahave where a.var=var); quit;     ... View more

Hello,   Say that I have dataset1 with ID and variable1, like this: ID Var1 A 1 B 2 C 3 D 4 E 5   I also have dataset2, which contains a reference variable, like this: RefVar 1 2 3   How do I modify dataset1 such that any Var1's values not found in dataset2's Refvar will be converted to missing? The resulting dataset1 should look like this: ID Var1 A 1 B 2 C 3 D . E .   The actual dataset has a lot of values for "Var1" and "RefVar" so a PROC SQL solution would be ideal, I believe. ... View more

Hello,   Let's say I have a string variable with the value "ABCD". How do I insert a 'K' between first and second characters so that the output is: AKBCD?   I tried the following but it's not working: substr(string,1,0) = 'K';   Thank you in advance.   ... View more

Hello,   Say that I have a dataset1 with ID and variable 1, like this: ID Var1 A 5.1 B 6.1 C 7.1 D 8.1 F 9.1 G 10.1   I also have dataset2, which is a reference table like this: Var2 Var3 5 20 6 30 7 40 8 50 9 60   How do I obtain a dataset that has ID, Var1, and Var3 such that Var3 corresponds to Var1's closest match in Var2 of the reference table. The resulting dataset would look like this: ID Var1 Var3 A 5.1 20 B 6.1 30 C 7.1 40 D 8.1 50 F 9.1 60 G 10.1 60   I came across the following article but I'm not sure how it can be adapted to my problem: http://www.lexjansen.com/pharmasug/2003/CodersCorner/cc001.pdf   Thank you. ... View more