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: 
jarr25
‎12-19-2015
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Download and instalation of NorthWind databse

by Fluorite | Level 6 in SAS Data Management
‎12-18-2015 07:02 PM
1 Like
‎12-18-2015 07:02 PM
1 Like
Hello, could you guide me how to install Northwind database to SAS Data Integration Studio 4.9? ... View more

Re: How to change cells value to different with IF function?

by Fluorite | Level 6 in SAS Data Management
‎01-18-2015 10:18 AM
‎01-18-2015 10:18 AM
That's not working for me, would you have other ideas? ... View more

Re: How to change cells value to different with IF function?

by Fluorite | Level 6 in SAS Data Management
‎01-18-2015 07:29 AM
‎01-18-2015 07:29 AM
Just first which crossed my mind - it's often in use in programming I'm using Data Integration Studio could you tell me which one is a proper one for me and how to fill that function? COALESCE(/*any-type, any-union-compatible-type*/) COALESCE(expr [, expr ]...) COALESCE( scalar_expression,scalar_expression,...) COALESCE(<value>) SELECT COALESCE ( <expression1>, <exprression2>, ...[exprN] ) ... View more

How to change cells value to different with IF function?

by Fluorite | Level 6 in SAS Data Management
‎01-18-2015 07:04 AM
‎01-18-2015 07:04 AM
Hello, I have some problem with my SAS What I'm trying to do, it's basically changing column value with function IF. So i have that type of column: What I need, is that blank cells (dots) to be filled with text 1501018, if there text in it already, it should leave it. Could you explain me how to do that, please? I'm trying to do it with IF function, but I have some problems with it.. It would be: IF(/*expr1,expr2,expr3*/) changed to IF(/*ENDDATE = .. ? ... View more

Re: How to count how many times value in a table repeated ?

by Fluorite | Level 6 in SAS Data Management
‎01-12-2015 10:48 AM
‎01-12-2015 10:48 AM
Ok I think now I will translate it better to you I have that kind of table ^ What I need is that kind of table, but in some way made in SAS ... View more

How to count how many times value in a table repeated ?

by Fluorite | Level 6 in SAS Data Management
‎01-12-2015 09:34 AM
‎01-12-2015 09:34 AM
Hello , I'd like to ask a question, since I'm trying to acquire result which I want, and don't know how. I have a table, and what I'd like to do, is to count how many times, value in a colums repeats. Where can I find such an option? Let's say I have Col1 Col2 Col3 Col4 1 1 5 g 1 2 4 b 1 3 4 b 2 4 7 d .. and what I want to do with that is that kind of result: there are 3 col2 that can be assigned to the value of col1 , there is 4 - which is number repeated most of col3 - 4 have a value of b edit. Is the function Frequencies can count this? (how many times some value repeated?) ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-19-2015 07:07 AM
Likes from
View All
Quick links