Hello everyone. I have problem when I run : %let y=abcdefg; proc sql noprint; update one set x = catx('|',x,&y) ; quit; after U run the code: :WARNING: Character expression will be truncated when assigned to character column x.. And In the result,the value of x is missing. Please help. Thanks! ... View more

Hello everyone. Does anyone could give me an exapmle of how to use proc oIap ? Thanks in advance! ... View more

Hello , Here is a data set have, The problem is I want new variable count_sub count the number of each type for each id, Please help. Thanks! data have; input id type $; cards; 1 A 1 A 1 A 1 B 2 A 2 B 2 B 2 C 2 C 2 C 2 C ; proc sql noprint; create table want_bad as select *,count(distinct type) as count_type,count(type) as count_sub from have group by id order by id,type ; quit; The dataset want should be like this: 1 A 2 3 1 A 2 3 1 A 2 3 1 B 2 1 2 A 3 1 2 B 3 2 2 B 3 2 2 C 3 4 2 C 3 4 2 C 3 4 2 C 3 4 ... View more

Hello Everyone, There is a problem troubles me for long time , when I use SAS base doing reading and creating tables,if the SAS section has opened and closed a lot of tables ,a SAS messae log will show up and I have to stop the SAS section and restart the SAS and run the program again to get the dataset needed for the rest steps. I attached the picture of the SAS Message log below,I think maybe I had opened too much datasets and the memory of the computer need to be release otherwise there isn't enough memory space for the SAS to do the rest job. Please give me some advice. Thanks! The picture of the SAS Message log : vuhWdwbar ... View more