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: 
Helle
‎01-04-2019
  • 20 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received
About
Data quality, data management

Re: Clustering in Data Management Studio

by Calcite | Level 5 in SAS Data Management
‎04-27-2016 09:22 AM
‎04-27-2016 09:22 AM
Hi Ron,   Thanks for your reply. Unfortunately, I lack the EEL skills to be able to follow your instructions. It would be great if you could provide me with an example of how to code the steps starting with "Start with the first description value.." and ending with "Reset the initial value...".   Thanks a lot,   Helle ... View more

Clustering in Data Management Studio

by Calcite | Level 5 in SAS Data Management
‎04-01-2016 04:14 AM
‎04-01-2016 04:14 AM
Hi,   I am trying to compare lists of values which originate from different tables. The format is typically like this: ID              Description             Table_Name ABC          Testing                   Table_A ABC          Testing                   Table_B ABC          TEsting                   Table_C   In most cases, the descriptions are exactly the same but sometimes there is a small difference (like in Table_C above). I would like to extract a list of those rows that have the same ID but different descriptions. I assume that I can use the clustering functionality in Data Management Studio but I am not quite sure how. Does anyone have a suggestion? I have attached a small data job with some sample data (DM Studio 2.6). I only have access to DM Studio so I cannot make use of SAS code.   Thanks, Helle ... View more

Re: Gchart showing five most frequent values only

by Calcite | Level 5 in Graphics Programming
‎12-21-2010 03:17 AM
‎12-21-2010 03:17 AM
Hi Dan and Robert, Thanks a lot for your suggetions - they both do the job 🙂 Best regards, Helle ... View more

Gchart showing five most frequent values only

by Calcite | Level 5 in Graphics Programming
‎12-20-2010 06:57 AM
‎12-20-2010 06:57 AM
Hi, How can I use proc gchart display the five most frequent values in a data set? From running proc freq, I know that these are the five most frequent values: Value Count -1000.00 157 -2000.00 156 -3000.00 155 -4000.00 120 -10000.00 110 I have searched the forums and the web for help but cannot seem to come up with the right combination of search terms to find an answer so I hope that someone in here can help me. Thanks, Helle ... View more

Re: Adding same value to variable within groups of rows

by Calcite | Level 5 in SAS Programming
‎11-29-2010 08:28 AM
‎11-29-2010 08:28 AM
Hi, Thanks for your input. SPR: I understand the logic of your suggestion but unfortunately processing my more than 33,000 observations in that way made SAS come to a complete standstill. Cynthia: I modified your suggestion and made it work on the dataset that I had already created containing only the four observations per case that I needed. The original txt file had different numbers of rows per case so I had to specifically select strings matching the four categories that I was looking for. Here is the code that I ended up with: data showlogic caseinfo (keep=dato inival type casechar); retain dato inival type casechar origord dtext itext ttext ctext; set cases; origord = _n_; num = mod(origord,4); if text1 =: 'DATE:' then do; dtext=text1; dato=text2; end; else if text1 =: 'INIT:' then do; itext=text1; inival=text2 ; end; else if text1 =: 'LOAN:' then do; ttext=text1; type=text2; end; else if text1 =: 'CASE:' then do; ctext=text1; casechar=text2; end; output showlogic; if num = 0 then do; output caseinfo; ** reset the retained variables; dato =.; casechar = ' '; type=' '; inival = ' '; dtext = ' '; itext = ' '; ttext = ' '; ctext = ' '; end; return; run; Thanks again, Helle ... View more

Adding same value to variable within groups of rows

by Calcite | Level 5 in SAS Programming
‎11-26-2010 08:28 AM
‎11-26-2010 08:28 AM
Hi, I am importing a txt file into SAS and looking only for rows that contain the four types of text strings below ("date", "ini", "type", "case"). Four rows at a time are related to the same case number. The challenge is that the order of type and case is not always the same in the text file and so I would like to sort by case number to obtain the same order in all by-groups (and use proc transpose afterwards). I have extracted the case number into a variable of its own so that the data set has two variables: text and caseno. text caseno date: xxx . ini: hli . type: l . case: 123 123 date: yyy . ini: lbj . case: 587 587 type: l . date: zzz . ini: jcg . type: t . case: 789 789 How can I replace the missing values in caseno with the correct case number? I have experimented with do-loops and the retain statement but somehow cannot figure out how to get it right. Thanks, Helle ... View more

Re: Converting several special characters in the same value

by Calcite | Level 5 in SAS Programming
‎09-21-2010 02:59 AM
‎09-21-2010 02:59 AM
Hi, Thanks a lot for your suggestions - they both give me the desired results 🙂 Regards, Helle ... View more

Converting several special characters in the same value

by Calcite | Level 5 in SAS Programming
‎09-20-2010 09:08 AM
‎09-20-2010 09:08 AM
Hi, I have a dataset containing the variable "memname". The values of "memname" may contain one or more Danish characters like Æ, Ø and Å. I need to convert these to AE, OE and AA respectively. The new converted values are stored in the variable "memname_dk". Examples of values with Danish characters include "ÅRSOPGØRELSE" and "ANSØGT_VILKÅR". I have tried to use different loops to make sure that all Danish characters are converted but didn't succeed yet so in the end I decided to simply run three almost identical data steps (see below). However, I am sure there must be a more simple way to do this. Can anybody help me please? Here's the current solution: data aa; set aa; memname_dk=memname; if find(memname_dk,'Æ') > 0 then memname_dk=tranwrd(memname,'Æ','AE'); run; data aa; set aa if find(memname_dk,'Ø') > 0 then memname_dk=tranwrd(memname,'Ø','OE'); run; data aa; set aa if find(memname_dk,'Å') > 0 then memname_dk=tranwrd(memname,'Å','AA'); run; Thanks, Helle ... View more

Re: PROC COPY error when input dataset name has special character

by Calcite | Level 5 in SAS Procedures
‎08-20-2010 08:49 AM
‎08-20-2010 08:49 AM
Hi, In the end, I opted for the simple data step solution because I still received the same error message even after changing the options and modifying the code. Thanks for all your input. Helle ... View more

PROC COPY error when input dataset name has special character

by Calcite | Level 5 in SAS Procedures
‎08-16-2010 07:20 AM
‎08-16-2010 07:20 AM
Hi, I wanted to use PROC COPY for copying a dataset but received an error after submitting the following: proc copy out=work in=ntsqlpro; select LÅN_GARANTI; quit; ERROR: The value 'LÅN_GARANTI'n is not a valid SAS name. I am running 9.1.3. I assume that it is because of the special character in the original dataset name. Is there a way to circumvent this or is it not possible to use PROC COPY with special characters? I googled the web for explanations but didn't come across any. Thanks, Helle ... View more

Re: Conditionally processing non-matching values

by Calcite | Level 5 in SAS Programming
‎08-13-2010 09:37 AM
‎08-13-2010 09:37 AM
Thanks for all your help - I will look into the different suggestions. Helle ... View more

Re: Searching for value across datasets in library

by Calcite | Level 5 in SAS Procedures
‎08-13-2010 08:47 AM
‎08-13-2010 08:47 AM
Hi, Thanks for your suggestion which I can definitely adapt to my needs. In the ideal world, it would be great to be able to search all datasets regardless of variable name, length etc. in a Google-like manner but in the meantime this will do. We are running 9.1.3 by the way and the other questions were answered correctly, too 🙂 Thanks, Helle ... View more

Searching for value across datasets in library

by Calcite | Level 5 in SAS Procedures
‎08-11-2010 09:48 AM
‎08-11-2010 09:48 AM
Hi, Is it possible to search for a specific value across all datasets in a library? I have a list of incorrect userids and I would like to know if these are present in any other datasets in a specific library. I have tried a lot of different search combinations in Google to find something about this topic but haven't had much luck so hopefully somebody in this forum can shed some light on this for me. Thanks a lot, Helle ... View more

Re: Conditionally processing non-matching values

by Calcite | Level 5 in SAS Programming
‎08-11-2010 09:41 AM
‎08-11-2010 09:41 AM
Hi, Can anybody tell me how I would do something similar in PROC SQL? I have another case involving a very large dataset and I run out of memory when sorting it. Thanks, Helle ... View more

Re: Conditionally processing non-matching values

by Calcite | Level 5 in SAS Programming
‎08-11-2010 09:40 AM
‎08-11-2010 09:40 AM
Hi Scott, Thanks for your suggestion. However, I want to keep all the observations from A and if I use your code, the only observations left in "new" are the ones that are not in B (all the ones which are in both A and B are deleted). Regards, Helle ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-04-2019 02:19 PM
Quick links