Hello, I have the below issue with proc report: Present proc report stmt: proc report data= atpresent nowd  box nowd ls =256 split='*' STYLE(header)=[just=left BACKGROUND= gray  FONT_WEIGHT= bold];         define Master_ID/display                 "Master ID"         style(column)={just=center tagattr="type:String"};         define SUPERVISER_ID /display             "SUPERVISER ID"       style(column)={just=center tagattr="type:String"};  The variables should not split when they appear in the report: Based on the lengh of the variable values, the variable names are displaying now like below   Master ID     SUPERVISER     EMPLOY Id        Report                        ID                                                   Date 11111111111 22222222      AB1010101010   QX-XXXX   But I need SUPERVISE ID the same line like Master ID, same thing applies to Report Date as well. I have tried by modifying the above proc report stmt, by removing the split='*' and adding a widht stmt like below, but doesn't seems to work. proc report data= atpresent nowd  box nowd ls =256 STYLE(header)=[just=left BACKGROUND= gray  FONT_WEIGHT= bold];         define Master_ID/display                 "Master ID"         style(column)={just=center tagattr="type:String"} width=12;         define SUPERVISER_ID /display             "SUPERVISER ID"       style(column)={just=center tagattr="type:String"} width=12;   What should I do to get the report like   Master ID        SUPERVISER ID  EMPLOY Id          Report Date                                     11111111111  22222222            AB1010101010      QX-XXXX ... View more

By using the below code, I'm able to identify the current week number of the month. Thanks for the previous post by user: ballardw ( Posted 05-18-2017 07:23 PM ) data _null_;     week = week(today()) - week((intnx('month',today(),0,'B'))) +1;     call symputx('week',week); run;   But I am facing difficulty, while running a report, which has to list the last week number......which means, if I am running a report now, it has to give me last week number, which is week4 (Here, I need to run a report that lists the data from last Monday to Saturday, i.e. 21st September to  27th September). Any kind of help is greatly appreciated. Thanks ... View more

  Hello, The below resolution from our community, works perfectly for macro variables separated by blanks %let mvar=aaaaa bbbbb ccccc zzzzz; %let mvar_quotes=%nrbquote(')%qsysfunc(prxchange(s/\s+/%nrbquote(',')/oi,-1,&mvar))%nrbquote('); %put mvar_quotes: %bquote(&mvar_quotes); resolution: mvar_quotes: 'aaaaa','bbbbb','ccccc','zzzzz'   But I do have the %let as %let mvar=aa-aa-a,bbbb-b,c-cccc,zzz-zz (where the variables are alreadu seperated by a ',') I need quotes for the variables separated by ',' which means  I need the resolved macro variables like beow. mvar_quotes: 'aa-aa-a','bbbb-b','c-cccc','zzz-zz'   I have tried modifying the above resolution stmt, but couldn't succeed. Pls help ... View more

data a; a='1234-01'; b=input(a,best12.); run;   I need to convert '1234-01' to number format like 1234-01 . Please help. ... View more

Hello! Below is the date macros code, that I'm using in my program DATA _NULL_; if "&sysparm" EQ '  ' THEN DO;    call symput('begdate',put(intnx('qtr',TODAY(),-1,'b'),date9.));    call symput('enddate',put(intnx('qtr',TODAY(),-1,'e'),date9.));  END;  ELSE DO;   call symput('begdate',PUT(input(scan("&sysparm.", 1, ',' ) , mmddyy10.),date9.));   call symput('enddate',PUT(input(scan("&sysparm.", 2, ',' ) , mmddyy10.),date9.)); END; RUN; %put begdate3 : &begdate; begdate3 : 01JAN2019 %put enddate3 : &enddate ; enddate3 : 31MAR2019 While using the macro in the program, mc.file_rcvd_date>= &begdate. and mc.file_rcvd_date < &enddate.     I'm getting the below error. rcvd_date>= &begdate. and NOTE: Line generated by the macro variable "BEGDATE".             01JAN2019               _______               22               76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET,               GROUP, GT, GTT, HAVING, LE, LET, LT, LTT, NE, NET, OR, ORDER, ^=, |, ||, ~=.  ERROR 76-322: Syntax error, statement will be ignored. rcvd_date < &enddate. ; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. Pleae help me on resolving this. Thanks. ... View more

Have a dataset with three columns have dataset dob1                dob2            rank 10/18/2017  10/27/1998      1 10/09/2017  11/03/1982      2 09/10/1991   09/10/1991     2   needed dataset   dob1                dob2            rank 10/18/2017  10/27/1998      1 10/09/2017  11/03/1982      2 09/10/1991   09/10/1991     null     if dob1=dob2 then ran=null ; else rank=rank;   both dob1 and dbo2 are date formats (type=date and length 😎   Please help how to get needed dataset. Thanks   ... View more