About shivas

shivas · ‎04-10-2012

Hi, Try this...hope this helps.. %macro a; %let test_value = test_val; This is a test; %mend a; data sample; msg = "this is a test"; run; data two; set sample; x=resolve('&test_value'); y=resolve('%a'); run; or proc sql; create table a as select msg, RESOLVE('&test_value') as val,Resolve('%a') as val2 from sample ; quit; Thanks, Shiva

shivas · ‎04-10-2012

Hi, Just run the code in reverse order...first run the SQL code and then try to run the data step code then you can find the difference. Data step code will show good performance. Solution 2: proc sql; create table wuTemp.CustTRBcur as select 'Version Date'n , 'HUB Cust Id'n , 'Last Month Average Balance'n from CNMAP.VIEW_MAPRH_M_CN_CUS_TRB where 'Version Date'n=&CurDate and 'Last Month Average Balance'n>=0; quit; Solution 1: DATA wuTemp.CustTRBcur (keep='Version Date'n 'HUB Cust Id'n 'Last Month Average Balance'n ) ; SET CNMAP.VIEW_MAPRH_M_CN_CUS_TRB ; where 'Version Date'n=&CurDate and 'Last Month Average Balance'n>=0; run; Thanks, Shiva

shivas · ‎04-10-2012

Hi, Two &s (&&) resolve to one & Four or more &s are resolved from left to right. So if you want &city6 then you need to use &&&&&var&n. Thanks, Shiva

shivas · ‎04-09-2012

Hi, I faced the similar issue and I followed below SAS note and it worked..Try this link. http://support.sas.com/kb/34/150.html Thanks, Shiva

shivas · ‎04-03-2012

Hi, Try replacing dbms=excel.Hope this helps. proc import datafile="T:\X21AB100\X2100LIXI.xlsx" out=work.lixi dbms=excel replace; run; Thanks, Shiva

shivas · ‎03-14-2012

Hi, Try this... data want; set one;set two; run; data want1; merge one two; run; Thanks, Shiva

shivas · ‎02-24-2012

Hi , Try this...Hope this helps.. signon outtsk2 sascmd="C:\Program Files\SAS\SASFoundation\9.2\sas.exe -nosyntaxcheck"; rsubmit outtsk2 wait=no; libname tt 'F:\SASALM'; data tt.want; input name $ no; cards; test 12 want 23 ravi 44 ; run; endrsubmit; signoff outtsk2; Thanks, Shiva

shivas · ‎02-24-2012

Hi Sunil, You can create dependency jobs in LSF scheduler.You can try that. Thanks, Shiva

shivas · ‎02-24-2012

HI Suresh, Check in Services.msc ,SAS [Config-Lev1] SASMeta - Metadata Server is started or not. Also check the hostname of your virtual machine and if it not localhost change that name. Thanks, Shiva

shivas · ‎02-23-2012

Hi, Hope these two variables are inputs parameters for stored process..If yes, then need to write one more condition for missing inputs for eg: %if %length(&DISTRICT) >= 0 %then %do; %if %length(&where_clause) > 0 %then %let where_clause = &where_clause and; %let where_clause = &where_clause (DISTRICT = "&DISTRICT"); %else %let where_clause = &where_clause and; %let where_clause = &where_clause; %end;

shivas · ‎02-21-2012

Hi, If you have ETS software ,you can use this procedure for quaterly aswell as well as for 6 months... Try this.. proc expand data=have out=want from=month to=semiannual; convert SMB_Dom HML_Dom MOM_Dom ; by country; id dat1; run; proc expand data=have out=want from=month to=qtr; convert SMB_Dom HML_Dom MOM_Dom ; by country; id dat1; run;

shivas · ‎02-21-2012

Hi ... use LET option in transpose.. eg proc transpose data=b out=c let; by branch_code PFSCustSegmentCode LoanCMP OutstandingCMP NationCMP Version NewCustInd OccupationCMP TRBLevel ZoneCMP; id cmp ; var NoCount; run;

shivas · ‎02-21-2012

Hi, Try this... data have; input Year $ Office $ Safey WellBeing AdminSupport stafftrai; cards; FY11 Office1 .90 .67 .78 .99 ; run; proc transpose data=have out=want; var year office Safey WellBeing AdminSupport stafftrai; run;

shivas · ‎02-21-2012

Hi , Is this what your are expecting, data a; input branch_code $ PFSCustSegmentCode $ LoanCMP $ OutstandingCMP $ NationCMP $ Version $ NewCustInd $ OccupationCMP $ 13. TRBLevel $ 13. ZoneCMP $ 7. cmp $ 22. NoCount; cards; AFU NORMAL N N CN 201201 N Commercial TRB1:0_10K Zone 1 Male 1 AFU NORMAL N N CN 201201 N Commercial TRB1:0_10K Zone 2 Female 2 AFU NORMAL N N CN 201201 N Commercial TRB1:0_10K Zone 1 Commercial 3 AFU NORMAL N N CN 201201 N Commercial TRB1:0_10K Zone 1 Production 4 AFU NORMAL N N CN 201201 N Commercial TRB1:0_10K Zone 1 SavingAccountBalance 15763.67 ; run; proc sort data=a out=b;by branch_code PFSCustSegmentCode LoanCMP OutstandingCMP NationCMP Version NewCustInd OccupationCMP TRBLevel ZoneCMP;run; proc transpose data=b out=c ; by branch_code PFSCustSegmentCode LoanCMP OutstandingCMP NationCMP Version NewCustInd OccupationCMP TRBLevel ZoneCMP; id cmp ; var NoCount; run;

shivas · ‎02-21-2012

Hi, Try this ... data samp ; set before ; retain online1 radio1 sem1; if online = . then online =online1 ; else online1 = online ; if radio = . then radio =radio1 ; else radio1 = radio ; if sem = . then sem =sem1 ; else sem1 = sem ; drop online1 radio1 sem1; run ;

Online Status	Offline
Date Last Visited	‎01-27-2020 04:50 AM

Re: SAS Management Console

Re: SAS web portal log on failure whick log to check

Re: Error msg: the launch of the server process failed with an unknown...

Re: SAS Studio Mid -tier

Re: Uninstall hot fix

Re: SAS Admin metadata folder

Re: delete history by flow user or by definition in processes manager...

Re: Extract SAP HANA VIEW using SAS/ACCESS Interface to SAP HANA

Re: SAS Installation - Choosing a deployment directory for SAS/GRAPH J...

Re: SAS EG output view

Re: Center caption under table using ODS TEXT= ?

Re: Where is the physical location of work folder

Re: How to copy libraries and database connections across SAS Servers?

Re: Need SAS SQL to return the minimum date as date but not as number

Re: sql tables and ambiguous reference error message

Re: Can I call a macro process which builds a dataset inside RESOLVE?

Re: Efficiency problem on "data set" and proc sql?

Re: why multiple ampersand resolve to this?

Re: Problem with sas 9.2

proc import hangs when reading .xlsx file

merge no nulls

Forcing all sas queries to execute remotely

DI Job

Port # 8561 error on my VirtualMachine (SAS distudio)

Re: Macro variable "where_clause"

from monthly dataset to quarterly

How to write transpose for such data?

proc transpose question

How to write transpose for such data?

Re: auto fill