Check system macro variable &syslast.   data class; set sashelp.class; run; data x; set &syslast ; run; ... View more

You'd have to provide an example of your data. My guess is that your dates are already either date or datetime values and you simply need to add the desired format.   I suggest that you create a new thread and ask your question there.   Art, CEO, AnalystFinder.com   ... View more

If your data comes from a delimited file, use option GETNAMES=NO in your import procedure. That way the first column will always be called VAR1. ... View more

The function is EXIST (not existS) - try change  line to:    %sysfunc(exist(&outtabel)) ... View more

Program1  %macro c; data x; x=3; run; %mend;   Program2 %c;   First, you run the Program1, Then you can run the Program2.   If you want to change script in Program1, you need to change it and rerun Program1. Otherwise, %с will refer to the old version of the script ... View more

I found this %let P = %sysfunc(inputn(%sysfunc(putn(%sysfunc(intnx(month,%sysfunc(today()),&D.-1,B)),z6.)),DDMMYYN10)); in my mailbox. Apart from the fact that it creates a raw value instead of a formatted date (which was expected), it looks like a serious attempt of someone who gets a kick out of hurting him/herself. It violates several Maxims, notably Maxim 12 and parts of Maxim 11. It is a bear to type correctly (at which it failed anyway), is hard to read for the next maintainer, and hard to debug. Instead do data _null_; mydate = intnx(month,today(),&D.-1,"b"); call symputx('P',put(mydate,best.),'g'); run; and use macro variable P directly, without "&P."d. (where somedate <= &P.) ... View more

When you run your data step you're not updating B, you're creating a new version of it. I'm guessing in the Data Set A the variable has a length of 3? If you want to preserve the length of BH you need to include a length statement or just put length statements in your data step and drop the Proc SQL e.g.   proc sql; create table B (BH char(100)); quit; data B; length BH $100; BH="BHBHBH"; run; ... View more

ODS Excel is a great option if you have SAS 9.4M3 ... View more

Use yr = round(yr,.01); to round up to the second fractional digit. ... View more

Remove empty rows and empty columns from excel inspired by https://goo.gl/ZlgFGn https://communities.sas.com/t5/Base-SAS-Programming/how-to-check-if-a-macro-variable-exists/td-p/206121 Slightly more complex with a mixture of numeric and character columns in excel. libname xel "d:/xls/colrow.xlsx"; * create some data; data xel.have; array cols[*] $8 Mary Joe Mike Jane Ted Tim; do rep=1 to 5; do var= 1 to dim(cols); jane=' '; if rep=3 then cols[var]=''; else cols[var]='A'!!put(int(100*uniform(-1)),z3.); end; drop rep var; output; end; run;quit; libname xel clear; HAVE (Excel sheet with missing column and missing row) Up to 40 obs WORK.HAVE total obs=5 Obs MARY JOE MIKE JANE TED TIM 1 A092 A041 A069 A069 A074 2 A010 A022 A069 A057 A068 3 4 A092 A006 A010 A009 A095 5 A009 A002 A068 A086 A094 WANT Up to 40 obs from want total obs=4 Obs MARY JOE MIKE TED TIM 1 A005 A082 A037 A067 A088 2 A019 A071 A026 A060 A043 3 A044 A077 A070 A041 A062 4 A086 A062 A008 A051 A081 WORKING CODE proc freq data=xel.have nlevels; set xel.have(drop=&colmis); if coalescec(of _character_)="" then delete; FULL SOLUTION ============= libname xel "d:/xls/colrow.xlsx"; * create excel workbook with sheet have and table have; data xel.have; array cols[*] $8 Mary Joe Mike Jane Ted Tim; do rep=1 to 5; do var= 1 to dim(cols); jane=' '; if rep=3 then cols[var]=''; else cols[var]='A'!!put(int(100*uniform(-1)),z3.); end; drop rep var; output; end; run;quit; ods output nlevels=nlevels; proc freq data=xel.have nlevels; run;quit; ods select all; /* Up to 40 obs from WORK.NLEVELS total obs=6 Obs TABLEVAR TABLEVARLABEL NLEVELS NMISSLEVELS NNONMISSLEVELS 1 MARY MARY 5 1 4 2 JOE JOE 5 1 4 3 MIKE MIKE 5 1 4 4 JANE JANE 1 1 0 5 TED TED 5 1 4 6 TIM TIM 5 1 4 */ %symdel colmis; * just incase it exists; data _null_; length colmis $1024; do until (dne); set nlevels end=dne; if nnonmisslevels=0 then colmis=catx(' ',colmis,tablevar); end; call symputx('colmis',colmis); rc=dosubl(' data want; set xel.have(drop=&colmis); if coalescec(of _character_)="" then delete; run;quit; '); run;quit; %put &=colmis; /* COLMIS=JANE Up to 40 obs from want total obs=4 Obs MARY JOE MIKE TED TIM 1 A005 A082 A037 A067 A088 2 A019 A071 A026 A060 A043 3 A044 A077 A070 A041 A062 4 A086 A062 A008 A051 A081 */ ... View more

Use a BEST format instead of 20.2. When you use 20.2 it always expects 2 decimal places, BEST will look at what it is. You can format it after to look like whatever you want.   new_MT = input (MT, best32.); format new_MT 20.2; ... View more