data monthly; /* You are creating an output data set named MONTHLY; This is a temporary data set and will be stored in the WORK library; It gets deleted once you terminate your sas session */   set test.monthly_exch_mv(where=(_type_=3)); /* #1 test.monthly_exch_mv is your source data set.  You applied a filter where you want the records to be _type_=3 only #TEST - is a permanent library which is assigned in the libname statement A libname statement is an alias to a path or a folder location; Once you terminate your sas session the dataset monthly_exch_mv will still be there "physically" (as stated in the location defined in your libname TEST statement) */   by yyyymm exchange; /* I presume here the variables yyyymm and exchange were pre-sorted, serves as a grouping or classification variables but does not seem to have any effect in your succeeding statements below */ format numberofFirms comma8.0; /* format statement is used because you want the value to appear in max length of 8 with commas) drop _type_;  (you do not want to see this variable in your output dataset */ run; /* execute and termiantes the data step */ ... View more

I think it's because of this %let DIR_IN_BASE=I:\SGEE\SGEE\Jorge\Proyecto\ENTRADA; change it to this %let DIR_IN_BASE=I:\SGEE\SGEE\Jorge\Proyecto\ENTRADA\;   ... View more

Bro just a friendly reminder.  Make it a habit to check the log (for errors) from top to bottom.  The first error may be the reason why the succeeding steps failed.  Fix the first error (that you have encountered) then rerun your code.  Then repeat until you have not seen any error in the log.     Also, an error-free log does not mean you got the output data correctly.   ... View more

Try using proc format. In this approach, you have retained your original variable as numeric and masked the values by creating a user-defined format.  Notice that i forced the values to uppercase - this is to standardize my data. "A" is not the same as "a". proc format; value $hubfmt 'KG'=1 'BASIN (20 POUNDS)=2 other='Other' ; run; options fmtsearch=(WORK); /* Here's my sample data */ data WANT; input hub $30.; cards; kg basin (20 pounds) test ; run; proc sql; update WANT set hub=upcase(hub); quit; proc datasets lib=WORK; *Change work to library where your data is; modify WANT; format HUB $HUBFMT. run; quit; ... View more

data sample; symbol="This is the Copyright symbol"||'00A9'X; word=substr(symbol,1,find(symbol,'00A9'X)); Unicode=substr(Symbol,find(symbol,'00A9'X); run; ... View more

Hi.  I took the script from novinosrin from HB and made a little tweaking. data want;   set sample; by id var_a  notsorted;   length new $20;   retain new;   if first.id and first.var_a then do;   call missing(new);   new=var; end;   else if first.var_a then new=catx("",new,var_a); if last.id then do;   var=substr(new,1,1);   output; end; run; ... View more

  %macro param(company,product,campaign); data _null_; exec= tranwrd( catx(",", quote(coalescec("&company","")), quote(coalescec("&product","")), quote(coalescec("&campaign","")) ), '""',"") run; %mend; %param(you,,); %param(you,wanna,); %param(you,wanna,bet); %param(,,); %param(,wanna,bet); %param(,,bet); %param(,wanna,); %param(you,,bet);   ... View more

data exercise1; input Team $ 1-15 Attendance 8. Price 8.; cards; Atlanta 13993 20.06 Boston 14916 22.54 Charlotte 23901 17 Chicago 18404 21.98 Cleveland 16969 19.63 Dallas 16868 17.05 Denver 12668 17.4 Detroit 21454 24.42 Golden State 15025 17.04 Houston 15846 17.56 Indiana 12885 13.77 LA Clippers 11869 21.95 LA Lakers 17378 29.18 Miami 15008 17.6 Milwaukee 16088 14.08 Minnesota 26160 10.92 New Jersey 12160 13.31 New York 17815 22.7 Orlando 15606 20.47 Philadelphia 14017 19.04 Phoenix 14114 16.59 Portland 12884 22.19 Sacramento 17014 16.96 San Antonio 14722 16.79 Seattle 12244 18.11 Utah 12616 18.41 Washington 11565 14.55 ; run; proc print; run; ... View more