About Jens89

Jens89 · ‎06-25-2020

Hi, I first added a dataset to the interactive grouping node, after which I grouped the factors. I then froze the bins. Now I have the same dataset with some extra factors, I want to keep the bins for the factors I already have and then group the additional factors. I have tried a couple of things: - add the new dataset to the existing interactive grouping node from dataset 1. the extra factors are not showing up - copy the node and then separately join the second dataset to this node. I am then getting an error where I must turn off frozen groupings because fine groups don't exist. I found the following forum post which I tried to follow but on step 2 I'm getting the same error where I must turn off frozen groupings https://communities.sas.com/t5/SAS-Data-Mining-and-Machine/How-do-I-add-a-new-variable-to-an-interactive-grouping-node/td-p/19110 thanks, Jens

Jens89 · ‎04-14-2020

Hi, When opening any of my projects in Miner, I keep on getting the following error: SASMiner - Cannot connect to "SASMiner - Logical Workspace Server" Make sure the workspace server is running and accessible. I have added a screenshot.

Jens89 · ‎01-23-2020

When I'm transposing, I want my column names to be a merged version of 2 separate columns. Column 1: is called "Topic", example: Cars per household Column 2: is called "Variable", example: 3 When I transpose I want to merge these two columns and as a result have something like "Cars per household : 3" Both column names are of the type character. I've tried something like transpose data = mydataset out = transposed_data; id Topic:Variable; run; but that doesn't run which I expected.

Jens89 · ‎01-14-2020

thanks, it worked. I had some error but it was unrelated to your solution.

Jens89 · ‎01-14-2020

run indeed, I've been using too much proc sql I'd say! I'm not sure if I understand the code you've written. if I have var = 20 in the first datastep, how can I then use 1:20 in the second part and why would you write var = 21 in the first step, I don't see how that fits in? thanks

Jens89 · ‎01-14-2020

I'm looking for a way to add number ranges in the where statement instead of adding them individually. the below would be ideal but that doesn't work data mydataset; set mydata; where var IN(1-20, 30-33, 50-65); quit; I have quite many ranges, I could work around it with defining the ranges individually but I am hoping there is a more efficient way. thanks

Jens89 · ‎01-02-2020

that's beautiful! thanks

Jens89 · ‎01-02-2020

I'm looking to enter a list of values as a parameter in a macro. eg: %macro test(list_of_values); data analysis; set file; where numbers in (&list_of_values); run; %mend; So then I can enter something like %test((100,101,102)) it's not always 3 numbers, it could also be 2 or 4. the list of values is also not the only parameter. I have some more in my code but the list would be one of them

Jens89 · ‎12-19-2019

thanks, the second option is exactly what I was looking for.

Jens89 · ‎12-19-2019

I'm trying to select all the columns from a table and one of those columns I need to change to a numeric type. When I try the following it doesn't work: proc sql; create table grand_index as select * ,input(MGI_ID, 11.) as MGI_ID format numeric11. from LIP.MOSAIC_GRAND_INDEX ; quit; I'm getting the following warning: WARNING: Variable MGI_ID already exists on file WORK.GRAND_INDEX. I could simply do the following but then I'm creating a new column which I'm trying to avoid. I would like to get it done in one go proc sql; create table grand_index as select * ,input(MGI_ID, 11.) as numeric_var format numeric11. from LIP.MOSAIC_GRAND_INDEX ; quit; thanks

Jens89 · ‎09-09-2019

2) The Lib Option in the PROC FORMAT Statement simply tells SAS where to store the Format. Noting else. This is giving me an issue. with the multiple proc formats, values are overriden. I could have 1 = 'analyst/technician' but then for another one 1 = 'agriculture' so then it wouldn't match the right values unfortunately.

Jens89 · ‎09-09-2019

great. 2 other issues I've ran into now too. - If there are more keys which need to be matched to the same value eg: proc format lib=work out=t; value fmt 1='analyst/technician' 2='apprentice/to trade' 3='Artist' 4='Clerical' IN(5,6,7) = "manager" .='Missing' other='Unknown' ; run; - in the format step lib = work. in the data step, that specific table doesn't seem to be referenced which would mean I'd run into issues with multiple proc statements. is there a way to give it a name in the proc step and reference it in the data have step? once again, thanks so much for your help

Jens89 · ‎09-09-2019

thanks again, I will study this option as well. for now I think I will use the format step. One more question on that, how can I add something for "else" values?

Jens89 · ‎09-09-2019

2) So your 'Mapping Table'.. Do you have that in a separate data set like this? data map; input x Occupation :$50.; datalines;1 analyst/technician 2 apprentice/to trade 3 Artist 4 Clerical; I don't but I could create that. at the moment I have one large data step which contains lots of if elseif statements to map the values like this: if APP_ICB_WORST_EVER = 'J' then ICB_BAND_MAPPED = 'Bad ICB'; else if APP_ICB_WORST_EVER = 'F' then ICB_BAND_MAPPED = 'Bad ICB'; else if APP_ICB_WORST_EVER = 'W' then ICB_BAND_MAPPED = 'Bad ICB'; if APP_ICB_VISA_WORST_EVER = 'J' then VISA_ICB_BAND_MAPPED = 'Bad ICB'; else if APP_ICB_VISA_WORST_EVER = 'F' then VISA_ICB_BAND_MAPPED = 'Bad ICB'; else if APP_ICB_VISA_WORST_EVER = 'W' then VISA_ICB_BAND_MAPPED = 'Bad ICB'; else if APP_ICB_VISA_WORST_EVER = 'Wr' then VISA_ICB_BAND_MAPPED = 'Bad ICB'; etc.

Jens89 · ‎09-09-2019

that seems to work great! 2 questions: - I would need something for missing values. can I add that also in the proc format statement? - do you have an alternative solutions where I can add this within a data step. Within my dataset I have different maps within 1 data step so I would have to create several proc steps with all the different maps. This works, but I was wondering if there is a more elegant solution. thanks so much!

Online Status	Offline
Date Last Visited	‎07-10-2020 05:32 AM

SAS Miner - adding a new dataset with extra factors after having used ...

SASMiner - Cannot connect to "SASMiner - Logical Workspace Server"

Merging column names when transposing

Re: WHERE IN (number - another number)

Re: WHERE IN (number - another number)

WHERE IN (number - another number)

Re: adding a list of values as a parameter in a macro

adding a list of values as a parameter in a macro

Re: change a column type when selecting * in proc sql

change a column type when selecting * in proc sql

Re: adding a list of values as a parameter in a macro

Re: change a column type when selecting * in proc sql

Re: Matching Data

Re: Matching Data

Re: Matching Data

SAS Miner - adding a new dataset with extra factors after having used ...

SASMiner - Cannot connect to "SASMiner - Logical Workspace Server"

Merging column names when transposing

Re: WHERE IN (number - another number)

Re: WHERE IN (number - another number)

WHERE IN (number - another number)

Re: adding a list of values as a parameter in a macro

adding a list of values as a parameter in a macro

Re: change a column type when selecting * in proc sql

change a column type when selecting * in proc sql

Re: Matching Data

Re: Matching Data

Re: Matching Data

Re: Matching Data

Re: Matching Data