About shivas

shivas · ‎07-10-2012

Hi, You can try this.. data have; input (id col1 col2) ($); cards; 1 id1 desc1 5 id2 desc3 3 id1 desc1 ; data new; input (id col1 col2) ($); cards; 3 id1 desc2 ; proc sort data=have; by id col1; run; data have ; update have(in=a) new(in=b) ; by id col1; if a ; run ; or proc sql ; update have m set col2 = (select col2 from new r where m.id = r.id and m.col1=r.col1) where m.id in (select id from new) ; quit ; Thanks, Shiva

shivas · ‎07-09-2012

Hi, I dont understand the logic why you want the date in this format 31122011 .Any how you can just apply the format like this..SAS internally stores date values in numbers itself. data have; set dbf; date1=date*1; format date1 mmddyy7.; RUN; Thanks, Shiva

shivas · ‎07-09-2012

Hi, If you have posted some sample data it would have helped... data have; input date $; cards; 30102011 ; run; data want; set have; newdate=input(date,ddmmyy8.); format newdate date9.; run; Thanks, Shiva

shivas · ‎07-06-2012

Hi, If you have SAS BI dashboards webapplication these dials graphs are inbuilt. If you want to build using base sas then you can try using proc gkpi procedure. Thanks, Shiva

shivas · ‎07-04-2012

Hi, Instead of until use while . data one; set two ; do i=id while (variety='Ginger'); newid=6||id; end; run; From SAS documentation.The DO WHILE statement executes statements in a DO loop repetitively while a condition is true, checking the condition before each iteration of the DO loop. The DO UNTIL statement evaluates the condition at the bottom of the loop; the DO WHILE statement evaluates the condition at the top of the loop. Note: The statements in a DO UNTIL loop always execute at least one time, whereas the statements in a DO WHILE loop do not iterate even once if the condition is false. Thanks, Shiva

shivas · ‎07-04-2012

Hi Rajesh, Try this..Hope it helps.. data have; input name $ 20.; modified = compress(name,'0123456789_'); cards; ABCD GHIJ0000 RRJJZL0244 cdds_3 ABSD0122 NNN0111 ABCD0000 ; run; Thanks, Shiva

shivas · ‎07-04-2012

Hi Syn, Just check if your CSV file is corrupted,if not just get original CSV file and try... Are you converting your files to CSV format from different format? Thanks, Shiva

shivas · ‎07-04-2012

Hi, Is you Oracle Server/Schema defined in Management Console. Thanks, Shiva

shivas · ‎07-04-2012

Hi, From SAS documentation, The TRANWRD function replaces all occurrences of a given substring within a character string. The TRANWRD function does not remove trailing blanks in the target string and the replacement string. TRANWRD uses a single blank instead when the replacement string has a length of zero. Try using compress to remove all the blank spaces,if you want. data _null_; string1='*' || compress(tranwrd('abcxabc', 'abc', trimn(''))) || '*'; put string1=; string2='*' || compress('abcxabc', 'abc', '') || '*'; put string2=; run; Thanks, Shiva

shivas · ‎07-04-2012

Hi, I guess ports might be blocked by your network team to that particular PC or just try to telnet to the metadata server port 8561 from you client machine and try.. or check the JRE version (because xp and window 7 uses different JRE versions) Thanks, Shiva

shivas · ‎06-27-2012

Hi , I guess we cannot get the code generated by SAS BI dashboards. Thanks, Shiva

shivas · ‎06-27-2012

Hi Nitin, Are you looking for something like Theme Designer in SAS.You can see this document SAS(R) Theme Designer 2.5 for Flex: User's Guide or you can define you own custom theme. Thanks, Shiva

shivas · ‎06-27-2012

Hi, Column level security is not possible in WRS..but find this document which provides an alternative solutions http://www.zencos.com/2012/04/column-level-security-for-web-reports/ Thanks, Shiva

shivas · ‎06-26-2012

Hi, Post some sample data and code that you are using. Thanks, Shiva

shivas · ‎06-26-2012

Hi, As i dont have tables,I have created using datalines or cards.Just try to execute this on sample data. /* Original table that you want to read ..You can delete this in your code as you are reading for table*/ DATA original ; LENGTH Unit_Type $12 Unit_Name $10; INPUT Unit_Type 1-10 Unit_Name 11-23 ; Datalines; Data_Unit DATA Data_Unit DATAVALUE Rand_Unit ACCOUNT ;;; run; /* format for your original table*/ data fmt (keep=FMTNAME START END LABEL TYPE); length FMTNAME $30. START END $256.; set WORK.original; FMTNAME = 'unit' ; START = Unit_Name; END = START; LABEL = Unit_Type; TYPE = 'C' ; run; proc format cntlin=fmt lib=work; run; /*Check or applying formats for the newrecords as well as for existing records*/ data wanttable; input ID Name $ 5-14 Type $ 15-20; unit=put(Name,unit.); cards; 101 DATA Bytes 102 ACCOUNT Rand 103 DATAVALUE Bytes ; run; Thanks, Shiva

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: sql

Re: Dates = numbers? HOW

Re: Dates = numbers? HOW

Re: SAS dial graphs

Re: Why this do until loop using all the observations?

Re: help in extracting string

Re: CSV file contains embedded CR and LF inside double quotes. How to ...

Re: Explorer - create library

Re: Trimn retruns a null string of zero-length string. But here it is...

Re: DI Studio 4.21 install on Windows 7 x62

Re: SAS Dashboards

Re: SAS Dashboard Color themes

Re: condiotional highlighting for non numeric fields

Re: error in proc format

Re: more efficient way to program