Hi, all:   I have a macro statement created by a previous coworker.   Could anyone explain what the "call symputx" part and the "if" condition after "call symputx" are for?  Thanks.   Y   %macro list(lib,sect);             data &sect.c;             set &sect.a(rename=(name=name_sup));               stabb=scan(name_sup,1,"_");       run;         data _null_;             set &sect.c end=eof;             by name_sup;               j+1;               call symputx("name"||trim(left(put(j,8.))),name_sup,'G');             call symputx("stabb"||trim(left(put(j,8.))),stabb,'G');             if eof then call symputx("count_state",j,'G');       run;   %mend list;   ... View more

Hi, all:   I saw several codes written from previous programmer.  Could someone let me know what they are refering to? Thanks.   Y   %including "file-specification"/source2; %rename (uned., _3);   %including "file-specification"/source2; %state (uned., _4);   %including "file-specification"/source2; %report (uned., _5);     ... View more

Hello,all:   I have some questions:   1, I would like to compare two data sets, some variables has the same name but different positions, how to set a flag to find them, and how to ignore.   For example, the variable “ID” has the name of “John” but one is at the left of the column and the other is at the center of the column.  If sometimes “John” is all in capital “JOHN”, and the other case is in “john”. How to let the system know they refer the same person, and it could be ignore. With all above, which statement I should be use? Please advice, thanks. ... View more

Hello:   I tried to import a '.csv' file into SAS.  I found some codes from the previous programmer as the list below.  I have some questions:   1.  Why use "informat" first then "format" statement?  I tried to just use the "format" statement.  I don't see any difference. 2.  After the file was imported, I found the order of the columns has been changed.  It changed to "JL Rating1 Rating2 Rating3 Rating4 RHSC HTLC LRC VS".  Due to the rating is corresponded to its previous column name,  how to keep the order the same as input order "JL $ RHSC $ Rating1 $ HTLC $ Rating2 $ LRC $ Rating3 $ VS $ Rating4 $"?     Thanks. Y     data test;       infile test MISSOVER DSD firstobs=2;       informat JL $22. ;       informat rating1 $32. ;       informat rating2 $18. ;       informat rating3 $100. ;       informat rating4 $12. ;       format JL $22. ;       format rating1 $32. ;       format rating2 $18. ;       format rating3 $100. ;       format rating4 $12. ;       input JL $ RHSC $ Rating1 $ HTLC $ Rating2 $ LRC $ Rating3 $ VS $ Rating4 $; run; ... View more

Hello:   I have the following PROC LOGISTIC procedure.  The result shows the analyst of Maximum Likelihood Estimate with Wald Chi-Square result.   I am also interested in obtaining the Odds Ratio and CL.  How to add them?  Please advise, thanks.   proc logistic data=test; class Y (ref="1") X1 (ref="2") X2 (ref="2") X3 (ref="2") X4 (ref="2") X5 (ref="2"); model Y = X1 X2 X3 X4 X5; where X1 in (1,2) and X2 in (1,2) and X3 in (1,2) and X3 in (1,2) and X3 in (1,2); run; quit;     ... View more

Hello,   I am learning using PROC SQL to replace the data step for data extraction.    I use PROC SQL / UPDATE statement, I found that I didn't update my data correctly, I lost some portion of my original ones.   PROC SQL; update work, test  set marital=case when marital in (2, 4) then 2 end, race=case when race in (3,5,6,7,8) then 7 when race in (4) then 9 end; quit;   As showing above, I got "martial 2 and 4" changing to 2, but missing 1 and 3 original categories in the updated data.  The same as race, I only got the 7 and 9 in race columns, but missing 1 and 2 original rows in the updated table.   How to avoid this problem?  Please advice.  Thanks.   ... View more