Hi, I am using proc append in a macro.  My base data is an empty data: data1; input message $120; run;   data2; message = 'A message less than 120 characters'; run;   proc append base = data1 data = data2 force; run;   even though I set my base data length to be a lot longer than appending data, the message after proc append force is trimmed to "A", which is the first letter in the message. Can someone explain why that happens? Thanks! ... View more

Hi,  I know that I can use sqlobs to refer to the observations in the proc sql step.  what is I am processing multiple proc sql steps? how do I differentiate the sqlobs from the first step to the sqlobs from the second step? Is there a way to name them? ... View more

Hi, I found a macro that gets a table's size. I was wondering if there's a way to adjust it so it can output an empty table?  %macro get_table_size(inset,macvar); data _null_; set &inset ; call symput("&macvar",size); stop; run; %mend;   And here's how to use it: %let count=; %get_table_size(table, count); %put &=count;   right now for empty table, %put statement will return count =  I want it to return count = 0 because then I will expand this to: if &count= 0 then do; data new; message = 'table is empty'; ... how may I do this? Thanks   ... View more

Hi, I was wondering if I could add log message to a dataset I'am using the macro VarExists(ds,var) as an example:   %macro VarExist(ds,var);    %local rc dsid result;    %let dsid = %sysfunc(open(&ds));       %if %sysfunc(varnum(&dsid, &var)) > 0 %then %do; %let result = 1; %put Note: Var &var exists in %ds; %end;   %else %do; %let result = 0; %put Note: Var &var not exists in &ds; %end;   %let rc = %sysfunc(close(&dsid)); &result %mend VarExists;   %varexist(sashelpclass, aaa);     I have little knowledge in SAS, but what I want (I will write a pseudo code below) is    if result = 1:     do nothing if result = 0: data want; input message $; datalines; Note: Var &var not exists in &ds  \* here &var and &ds will be the macro input*\ ;   so there will be a final dataset that looks like this:   message var aaa not exists in sashelp.class   Is there a way to do this? Thanks! ... View more

Hi,  I want to create a dataset that looks like this   data out; input id description $ num_of_errors error $; datalines; 1001 some_string &count_of_record some_error ; data table1; input test; datalines; 1 2 3 ;   here I want &count_of_record to be the number of rows from table1. so when I print the data out, the result will look like this   id          description               num_of_error         error 1001        some_string                 3                    some_error   I'm wondering if there's a programming way to do this instead of manually type in. Thanks! ... View more

Hi, This is a really silly question... I want to create a data set where one of its column value contains dash in the string.  here's my code   data out; input id $ description ~$ message ~$ num error ~$; datalines; ACN-1-001  "BLABLA" "BLABLA" 4 "BLABLA"; RUN;   what i want:   id                   description     message      num         error ACN-1-001    BLABLA          BLABLA         4           BLABLA   there's an error message: statement is not valid or it is used out of proper order. I think the id input might need a special format but I don't know which one I should use.     Thanks!   ... View more