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: 
MG18
‎10-07-2024
  • 192 Posts
  • 52 Likes Given
  • 7 Solutions
  • 14 Likes Received

Re: Sas aml scenario

by Lapis Lazuli | Level 10 in SAS Programming
‎05-28-2018 07:39 AM
1 Like
‎05-28-2018 07:39 AM
1 Like
Hi Raju I am new to SAS AML so I  wanted to understand how the value of n is getting picked /calculate or how/where is value stored ? I was referring the SAS10006 scenario.  where this array (datekey {i}) definition  is defined ?? Please clarify on this. Many thanks in adavance. ... View more

Re: Not able to perform interaction between two section of SAS VA repo...

by Lapis Lazuli | Level 10 in SAS Visual Analytics
‎03-29-2018 03:15 AM
‎03-29-2018 03:15 AM
It is working with Google chrome 🙂 ... View more

Re: Not able to perform interaction between two section of SAS VA repo...

by Lapis Lazuli | Level 10 in SAS Visual Analytics
‎03-29-2018 03:02 AM
‎03-29-2018 03:02 AM
Please find below are  answer to your all question :-   What release of SAS Visual Analytics are you using? :-  I am using SAS Visual Analytics 7.3. Are you seeing the problem in the modern (HTML5) version of SAS Visual Analytics Viewer? :- How to check version of HTML ? Please tell me how to check this version and i m using internet explorer.   If so, are you going directly from designer to viewer (File > View report), or are you opening the report directly in the viewer. If you are opening from designer, it is possible that you are encountering a problem with Internet Explorer where changes made in designer are not immediately reflected in viewer.   :-  i have tried to view after closing the report from designer then open the same from viewer again but which is not performing the interaction also. ... View more

Not able to perform interaction between two section of SAS VA report b...

by Lapis Lazuli | Level 10 in SAS Visual Analytics
‎03-23-2018 03:29 AM
‎03-23-2018 03:29 AM
Hi,   I've been having a hard time making an interaction between two sections in SAS VA while opening in SAS VA viewer but same is working fine in designer.  The datas from the different sections all came from the same source yet, whenever I making an interaction, it shows  changes in designer but when i am opening same report it is failing to perform interactions between two sections .  How can I make it work? Please help. Thanks.  ... View more

data is not coming correctly in datalines

by Lapis Lazuli | Level 10 in SAS Programming
‎03-22-2018 08:35 AM
‎03-22-2018 08:35 AM
LIBNAME samp2 BASE "E:\Sachin\FirstRpt\Library"; data samp2.sample; infile datalines dlm=' ' dsd ; input country_name$ diaseases$ death ; datalines; India Cancer 200 India TB 300 Pakistan Cancer 200 Pakistan TB 400 united state of america TB 300 united state of america Cancer 4000 ; run; proc print data=samp2.sample; run;       Output :-   country_ Obs name diaseases death 1 India Cancer 200 2 India TB 300 3 Pakistan Cancer 200 4 Pakistan TB 400 5 united state . 6 united state .     How to fix this issue as data for USA is not coming correctly. ... View more

Re: How to Start SAS Environment Manager

by Lapis Lazuli | Level 10 in Administration and Deployment
‎03-19-2018 07:42 AM
‎03-19-2018 07:42 AM
Please tell me how to check link using SAS management console , I have access to SAS SMC and password for sasadm@pw. ... View more

How to Start SAS Environment Manager

by Lapis Lazuli | Level 10 in Administration and Deployment
‎03-19-2018 06:09 AM
‎03-19-2018 06:09 AM
Hi Team,   Please advise how to start how to SAS Environment Manager on windows server. I am not able to the link for the SAS Environment Manager and on services for SAS Environment Manager and SAS Environment Manager agent are running on Windows server .   I have tried    http://blrevpsosvr1.ad.*****.com:7080/  http://blrevpsosvr1:7080/  where blrevpsosvr1 is hostname how can i found the link for SAS Environment Manager ? ... View more

Re: How to find out maximum value with group by condition ?

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 06:11 AM
‎03-13-2018 06:11 AM
DATA VISITS; INPUT ID VISIT_DATE : MMDDYY10. sell @@; FORMAT VISIT_DATE DATE9.; DATALINES; 1 02/01/2003 180 1 03/02/2003 178 1 04/01/2003 170 2 03/03/2003 170 2 04/01/2003 172 3 04/01/2003 130 3 06/01/2003 128 3 08/01/2003 128 5 04/01/2003 130 5 06/01/2003 128 5 08/01/2003 128 5 04/01/2003 130 5 06/01/2003 128 5 08/01/2003 128 ; proc sql; select * from (select id,sum(sell) as sum_sell from VISITS group by id ) where sum_sell = (select max(sum_sell) as sum_sell from (select id,sum(sell) as sum_sell from VISITS group by id ) ); quit;   This is worked 🙂   ... View more

Re: How to find out maximum value with group by condition ?

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 06:03 AM
‎03-13-2018 06:03 AM
  Still it didnt worked  :<   proc sql; select id, max(sum_sell) from (select id,sum(sell) as sum_sell from VISITS group by id) group by id HAVING max(sum_sell) =sum_sell ; quit;   output :-  ID ------------------ 1 528 2 342 3 386 ... View more

How to find out maximum value with group by condition ?

by Lapis Lazuli | Level 10 in SAS Programming
‎03-13-2018 05:06 AM
‎03-13-2018 05:06 AM
How to find out Maximum value with group by condition and below is example but it didnt worked :-   DATA VISITS; INPUT ID VISIT_DATE : MMDDYY10. sell @@; FORMAT VISIT_DATE DATE9.; DATALINES; 1 02/01/2003 180 1 03/02/2003 178 1 04/01/2003 170 2 03/03/2003 170 2 04/01/2003 172 3 04/01/2003 130 3 06/01/2003 128 3 08/01/2003 128 ; proc sql; select id,max(sum_sell) from (select id ,sum(sell) as sum_sell from VISITS group by id ) group by id; quit;   Output :- ID max_sell ------------------ 1 528 2 342 3 386   but expected output is  ID max_sell ------------------ 1 528   How to achieve this using proc sql ?    ... View more

Re: problem in deleting matching recoreds from two datasets

by Lapis Lazuli | Level 10 in SAS Programming
‎03-12-2018 05:39 AM
‎03-12-2018 05:39 AM
The below code merge will work for ur problem :- data a; input num 3.; datalines; 1 2 3 ; run; data b; input num 3.; datalines; 2 3 ; run; data c ; merge a b ; by num; run; proc print data=c; run;   output :- Obs num 1 1   ... View more

Re: getting wrong output pls help this code once

by Lapis Lazuli | Level 10 in SAS Programming
‎03-12-2018 05:15 AM
‎03-12-2018 05:15 AM
  Below code will also give u ur desired output:-   data club; infile datalines dsd; input idnumber 1-4 @5 name $14. @20 team $6. @27 startwi 3. @31 endwi; datalines; 1023 DAVID shaw RED 189 155 1049 AMELIA verna YELLOW 145 125 1219 ALAN ranju red 210 192 1246 RAVI shankar YELLOW 177 177 1078 ASHELY valley RED 127 118 1221 JIM rose YELLOW 220 220 ; proc print data=club; id idnumber; run; ... View more

SAS dataset size on LINUX is not changing after deleting rows

by Lapis Lazuli | Level 10 in SAS Programming
‎03-08-2018 01:21 AM
‎03-08-2018 01:21 AM
I have 100GB SAS dataset on LINUX. Space allocated for the dataset after deleting 50 GB data from the dataset is still 100 GB. I'm not sure if this is related to SAS or LINUX. The below code is performing the delete: Proc SQL; Delete * from dataset where Column=value; Quit;     i have tried below Query also but again Size of dataset is still same . QUERY :- LIBNAME LIBNAME '';  Data LIBANME.DATASET NAME ;  MODIFY LIBANME.DATASET NAME;  IF condition then remove ;  Run ; ... View more

how to use informat for a external file having 2 different format of d...

by Lapis Lazuli | Level 10 in SAS Programming
‎02-22-2018 06:50 AM
‎02-22-2018 06:50 AM
Hi all,  we have one external file in which one of numeric column has the two different type of data as shown in below :-   Country   Revenue  India        2000 Nepal      2000  USA        $2,000  Canada  $300 AUS       $2005     how to write code for above scenario and Dataset output should look like :-   Country   Revenue  India        2000 Nepal      2000  USA        2000  Canada  300 AUS       2005   ... View more

Re: How to fetch org.omg.COMBRA.COMM_FAILURE error ?

by Lapis Lazuli | Level 10 in Administration and Deployment
‎02-22-2018 06:40 AM
‎02-22-2018 06:40 AM
Thanks for your reply and we have tried to set the  a keepalive parameter but our version is 9.3 and u have mentioned for 9.4, Please let me know how to set keeplive parameter for 9.3 . Many Many  thanks in advance.   below are the some additional details about ourenvironment:   What OS is the Metadata Server running :- Linux Are there any firewalls between this client and the server(s)? :- Yes . How long has this issue been occurring?:- it has been occurring from last 1 month but we havent changed any parameter on server. Is this a new issue or has this issue happened ever since the environment was created? :- This is new issue and environment is working fine from last 3/4 years.     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-07-2024 08:24 AM
Likes given to
Likes from
Quick links