cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
anitapamu2
‎08-29-2017
  • 34 Posts
  • 10 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to call URL API from SAS/WPS

by Calcite | Level 5 in SAS Procedures
‎07-28-2017 03:15 AM
‎07-28-2017 03:15 AM
How to call Web service  (Url) form SAS ? I am using 9.2 Windows Base SAS.   ERROR: Cannot load SSL support. Here is an example of code that can trigger the error. filename myref url "https://www.google.com"; data _null_; infile myref; run; ... View more

How to call URL API from SAS/WPS

by Calcite | Level 5 in SAS Procedures
‎07-28-2017 03:02 AM
‎07-28-2017 03:02 AM
%let url= " " ; filename in "C:\Users\anita.pamu\Desktop\In.txt"; filename out "C:\Users\anita.pamu\Desktop\Out.txt" recfm=v lrecl=32000; proc http in=in out=out url="&url" method="post" ct="application/x-www-form-urlencoded" ; run; ... View more

Re: Check if two datasets are the same

by Calcite | Level 5 in SAS Programming
‎10-15-2015 07:52 AM
‎10-15-2015 07:52 AM
PROC COMPARE compares two data sets: the base data set and the comparison data set. The procedure determines matching variables and matching observations. Matching variables are variables with the same name or variables that you pair by using the VAR and WITH statements. Matching variables must be of the same type. Matching observationsare observations that have the same values for all ID variables that you specify or, if you do not use the ID statement, that occur in the same position in the data sets. If you match observations by ID variables, then both data sets must be sorted by all ID variables. proc compare base=proclib.one compare=proclib.two novalues; run;   COMPARE Function Returns the position of the leftmost character by which two strings differ, or returns 0 if there is no difference. data test2; pad1=compare('abc','abc '); pad2=compare('abc','abcdef '); truncate1=compare('abc','abcdef',':'); truncate2=compare('abcdef','abc',':'); blank=compare('','abc', ':'); run; ... View more

Re: MERGING DO LOOP

by Calcite | Level 5 in SAS Programming
‎10-15-2015 05:39 AM
‎10-15-2015 05:39 AM
Hereafter It will not repeat and Thank you!   Can you please help out In Data Step Method ...for the same Problem ... View more

MERGING DO LOOP

by Calcite | Level 5 in SAS Programming
‎10-15-2015 04:00 AM
‎10-15-2015 04:00 AM
Data one; input var1 $; datalines; scan MRI ;run; Data two; input res1 res2; datalines; 10 45 13 56 ; run;   OUTPUT: IN ONE DATASET Var1 res1 res2 scan 10 45 scan 13 56 MRI 10 45 MRI 13 56 ... View more

Can we replace macro variable.

by Calcite | Level 5 in SAS Programming
‎05-21-2015 03:39 AM
‎05-21-2015 03:39 AM
/*************** macro varaiable *********************/ % let refvar = AEENDT ; /********************* creating new variable =AEENDY  *******************/ data works._RefDate_; set  _RefDate_; RFSTDTC =input ( RFSTDTC  ,YYMMDD10.); if  &refvar.   le RFSTDTC then  AEENDY  =  &refvar. - RFSTDTC + 1; if  &refvar.  ge RFSTDTC then  AEENDY  =  &refvar. - RFSTDTC ; run; The macro varaible  AEENDT  has suffix "DT" DT should  be place by "DY"...  and  create the new variable.. "  In the above code i have hard code the new variable name "AEENDY "."" ... View more

I am trying to write a macro to calculating days for the all the datas...

by Calcite | Level 5 in SAS Programming
‎04-17-2015 12:19 AM
‎04-17-2015 12:19 AM
Please find the attached file and code file. Source data library contains two data set  : DEMO and AEDATA. transaction data library contain one data set Metadata (metadata consist of variable information for example  action = "DATE" and dy = "Y" then NumDays = intck( 'day', startdate, endday ); ) 1) Want to merge the Demo data with the both data set form Source data library (DEMO and AEDATA.) [aim to add RFSTDTC variable in all the dataset in source library] . 2) Then want to merge the  data with metadata then according to  the condition the calculation of the dates should occur action = "DATE" and dy = "Y" then NumDays = intck( 'day', startdate, endday ); 3) Want calculate the date (days) difference using common data set   ("DEMO. RFSTDTC"). Thanks, Anita ... View more

CAN WE CALCULATE "DAYS" THE DIFF BETWEEN TWO DATES FORM TWO DIFFERENT ...

by Calcite | Level 5 in SAS Programming
‎04-16-2015 03:31 PM
‎04-16-2015 03:31 PM
PLEASE FIND THE ATTACHED FILES , AEDATA HAS TWO VARIABLE  AND DEMO HAS ONE VARIABLE OUTPUT IT SHOULD  FIND THE DAYS DIFFERENCE FOR THE VARAIABLE AVALIABLE IN AEDATA DATSET.using DEMO DATA SET  HAS BASE DEMO.RFSTDTC -AEDATA .AESTDT DEMO.RFSTDTC - AEDATA AEENDT ... View more

plz cnvrt into days

by Calcite | Level 5 in SAS Programming
‎04-08-2015 06:37 AM
‎04-08-2015 06:37 AM
data _null_; td=today(); *td='18jul2014'd; bgn_date=intnx('month',td,0,'b'); end_date=intnx('month',bgn_date,0,'e'); prev2mth=intnx('month',td,-2,'s'); call symput('As_of_dte',put(td,yymmdd8.)); call symput('As_of_dt',put(td,yymmdd10.)); call symput('As_of_dte1',put(td-1,yymmdd8.)); call symput('month_begin',put(bgn_dte,yymmdd10.)); call symput('month_end',put(end_dte,yymmdd10.)); call symput('month_stamp',put(bgn_date,yymmn6.)); call symput('prev2mth',put(prev2mth,yymmddn8.)); run; ... View more

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

by Calcite | Level 5 in SAS Programming
‎03-18-2015 02:05 PM
‎03-18-2015 02:05 PM
Can we create a macro variable for following text (ram is "very disposition",now we want ,to eat you,right"way is not collected")  %let want = 'ram is "very disposition",now we want ,to eat you,right"way is not collected" '; %put want ; ITS NOT WORKING CAN ANYONE HELP ME ... View more

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

by Calcite | Level 5 in SAS Programming
‎03-18-2015 12:34 AM
‎03-18-2015 12:34 AM
Hi All, I have created a small macro to  *Converting all character values to uppercase %macro UPCASE_Var(_a_infile_,_a_outfile_); data &_a_outfile_.; set &_a_infile_.; array Chars _character_; do i = 1 to dim(Chars); Chars = upcase(Chars); end; drop i; run; %mend; %UPCASE_Var(sashelp.class,test1234); But can some help me to write for all SASDATA SET in the Libname %macro UPCASE_Var(libname); code here.... %mend; % UPCASE_Var(libname); ... View more

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

by Calcite | Level 5 in SAS Programming
‎03-17-2015 06:53 AM
‎03-17-2015 06:53 AM
Thank you !! ... View more

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

by Calcite | Level 5 in SAS Programming
‎03-17-2015 01:57 AM
‎03-17-2015 01:57 AM
Hi Xia Keshan, In the variable Stroke and Points we can see the special character ' [] ' . ... View more

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

by Calcite | Level 5 in SAS Programming
‎03-17-2015 01:54 AM
‎03-17-2015 01:54 AM
Hi Xia Keshan, the datavalues have been missed placed in the data set. ... View more

Re: FINALTIME VARIABLE IS NOT LOADED .CAN SOME LOOK INTO IT

by Calcite | Level 5 in SAS Programming
‎03-17-2015 01:42 AM
‎03-17-2015 01:42 AM
Hi , we missing the variable called Place.and the place contain '--' that special character should present in the data set along with the variables. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-29-2017 04:06 AM
Likes given to
Quick links