All,     I know there are many posts on the community and I tried following the suggestions in these posts without much success. Here is a very relevant post (https://communities.sas.com/t5/SAS-Programming/URGENT-extract-Year-and-Month-from-a-date-variable/td-p/288783) .       Let me show what I have tried to do and my code:  Data Have; Set Work.temp (Keep = UtcReadTime ); Left = scan(UtcReadTime,1,'T'); Right = scan(UtcReadTime,2,'T'); format Left yymmdd8.; format Right yymmdd8.; Date = input(Left,yymmdd8.); Year = Year(Date); Month = Month(Date); Day = Day(Date); Hour = Hour(Right); Run; ... View more

All,    Can somebody kindly help point out what I am doing wrong in the following code ?    %Let DesHour = %sysfunc(hour(%sysfunc(tzoneu2s(%sysfunc(tzones2u(%sysfunc(datetime()))),america/los_angeles)))); %Put NOTE: Current Hour in Desired Location is : &DesHour; %Let Cond2 = %eval(&DesHour == 11); %Put NOTE: Condition For Hour Of Day Is: &Cond2;   Best  Uday  ... View more

All,      Here is a question that I am struggling with. I would like to find the last day of the month in a different time zone. I know there are countless examples using intnx() which show how to compute the last day of the month. I tried to apply the same concept as shown in one such example. Here is my code:    /*%Let T = %sysfunc(tzoneu2s(%sysfunc(tzones2u(%sysfunc(datetime()))),asia/singapore)); %Put Test: &T; %Let T1 = %sysfunc(intnx('dtmonth', &T, 0, 'E')); %Put Test1: &T1;*/    I receive a warning which says:  WARNING: Argument 1 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The result of the operations have been set to a missing value.    Alternatively, if I format "T" as a date time as shown below, that results in an errror:    %Let T = %sysfunc(tzoneu2s(%sysfunc(tzones2u(%sysfunc(datetime()))),asia/singapore),datetime.); %Put Test: &T; %Let T1 = %sysfunc(intnx('dtmonth', &T, 0, 'E')); %Put Test1: &T1; ERROR: Argument 2 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number. ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC or %QSYSFUNC function reference is terminated.  Any help or advice is appreciated. Thanks in advance.  Best  Uday  ... View more

Hello All,           I would like the community's help on looping around the columns of a data set, check if a column has at least one row with a missing value.   data values; input @1 var1 3. @5 var2 3.; if missing(var1) then do; put 'Variable 1 is Missing.'; end; else if missing(var2) then do; put 'Variable 2 is Missing.'; end; datalines; 127 988 195 ; run;           This is the manual way I can see from Missing() documentation and it would work for small datasets. But I would like the ability to do this over large data sets easily.  ... View more

All,   I have a fairly simple question. When I have a string in open code, how can I add single / double quotes around it ?      %Let sep = %str(-); %Let first = %str(uday) ; %Let last = %str(guntupalli); %Let name = %sysfunc(catx(&sep.,&first.,&last.)); %Put &name.; I looked at discussions in the community but they use a data step. Can anybody kindly show, how I can achieve similar results in open code ?    Best  Uday    ... View more

All,       I have a stored process that I have developed and it is able to return an XML when invoked using a SOAP call. However, in the response, SAS automatically encodes the response and returns "<" as "&lt".        I would like to request to request your help for :  1. Is there a way to ensure that SAS response does not have this encoded ? (Please note that, I have already tried reading the XML response as a string and using  tranwrd function to replace the "<" and also using htmldecode function. However, in both the cases, the "&lt" still remains  2. Is there a way to respond with a '.csv' file when the SAS stored process is called ?  (Kindly provide an example)         Appreciate your help    Best  uday  ... View more

All,     Wondering whats wrong in the open code that I am trying here:      The following works in a data step      Data Test; x1 = 'not a &lt;tag&gt;'; x2 = htmldecode(x1); Run;        However, when I move away from a datastep into open code, this fails(does not return an error, but does not have the desired impact. desired impact/result is demonstrated in data step):    %Global x1 x2; %let x1 = 'not a &lt;tag&gt;'; %Put &x1; %let x2 = htmldecode(&x1);       Can somebody kindly explain why ? The desired output is demonstrated in the data step.  ... View more

All,      I would like to request your help in guiding me in my attempt to rename all the columns in a SAS dataset. I have gone through different approaches that have been explained by different people, I am not sure on how to apply these solutions to my case.      My attempt is based on the SUGI submission (http://www2.sas.com/proceedings/sugi28/118-28.pdf)    %Macro renameallcols(lib,dsn); Options Pageno= 1 NoDate; Proc Contents Data = &Lib..&dsn; Title "Before Renaming All Variables"; Run; Proc Sql NoPrint; Select nvar into :num_vars From dictionary.tables Where libname="&LIB" and memname="&DSN"; Select Distinct(name) into :var1- :var%TRIM(%LEFT(&num_vars)) From dictionary.columns Where libname="&LIB" and memname="&DSN"; Quit; Run; Proc Datasets library=&LIB; Modify &DSN; Rename %Do i=1 %to &num_vars; &&var&i=Col_&i. %End; ; Quit; Run; Options Pageno= 1 NoDate; Proc Contents Data = &Lib..&dsn; Title "Before Renaming All Variables"; Run; %Mend renameallcols; %renameallcols(SASHelp,Air);  I have made a minor modification to adjust to my needs i.e. the name that is being assigned is a little different that what was being discussed in the paper. In most of the relevant posts that I see in the community, a lot of people are trying to define a "rename" list where they define "oldname = newname" and save it and run it in a do-while loop. I think the approach adopted by the author of the paper is very similar. Can someone kindly explain why the above is failing ?  ... View more