Hi, I want to run a report that gives me all the categories for all columns with percentages in one go. Like a single report. My tables could have >100 categorical (character) value fields. Issue is that it is taking very long and does not have enough memory to run for all fields - any ideas how to handle it Have Id Gender State Grade 1 Male IN 8 2 Female MO 8 3 Female TX   4 Null TX   5 Null   6 6 Null TX 7   Want a single output  Gender n % M 1 17% F 2 33% Null 3 50%       State     IN 1 17% MO 1 17% TX 3 50% Blank 1 17%       Grade     6 1 17% 7 1 17% 8 2 33% Blank 2 33% ... View more

Hi, I used proc pwencode to generate encrypted password but when trying to use it with ODBC connection to Azure server it's not recognizing it and gives error. Code is   %let ts_pwd = {SAS003}XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;   LIBNAME TEST ODBC DATAsrc=‘XXX' USER="ABC" PWD= "&ts_pwd" SCHEMA=ABCXYZ CURSOR_TYPE=FORWARD_ONLY;     ERROR: Failed to authenticate the user ‘ABC’ in Active Directory (Authentication option is 'ActiveDirectoryPassword').  Error code 0xCAA20003;        state 10  ID3242: The security token could not be authenticated or authorized. ERROR: Error in the LIBNAME statement. Any ideas or suggestions please ! Thanks ... View more

Hi, I want to search multiple values in a string field. e.g. currently i am using this code to look for either Val1 or Val2 : Newfield = Index (Field, in "Val1", "Val2")) The original field has values separted by comma like this Val1,Val2, ....,Val50   SAS error says too many arguments.   Any ideas how can search more than 1 value in the same field? Thanks   ... View more

data have; input ID1 ID2 R I Seq ; datalines; 1 11 1 . 1 2 11 0 1 2 1 143 0 1 1 1 22 1 . 1 2 22 1 . 2 3 22 1 . 1 4 22 1 . 2 1 165 0 1 1 1 164 0 1 1 1 166 0 1 1 1 33 0 1 1 2 33 1 . 2 3 33 1 . 3 4 33 1 . 4 ; proc sort data = have; by ID2; run; data want; set have; by ID2; if I = 1 and lag(R) =1 the Rnew = 1; Else Rnew = 0; run;   Want To create a new field called Rnew where if I = 1 then Rnew = Lag(R)  I sorted the data by ID2 so that this rule applies to only ID2 and changes everytime ID2 changes - but its not working   For ID2 = 11 SAS is reading the R field for the next ID2  (143) and ignoring the lag function and shows RNew = 1 when infact it should be 0; Any ideas what am I doing incorrect and how do I tell SAS to apply this rule for a set of IDs only. Thanks   WANT ID1 ID2 R I Seq Rnew 1 11 1   1 0 2 11 0 1 2 0 1 22 1   1 0 3 22 1   1 0 2 22 1   2 0 4 22 1   2 0 1 33 0 1 1 1 2 33 1   2 0 3 33 1   3 0 4 33 1   4 0 1 143 0 1 1 0 1 164 0 1 1 0 1 165 0 1 1 0 1 166 0 1 1 0 ... View more