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: 
Mariloud
‎02-23-2024
  • 32 Posts
  • 5 Likes Given
  • 0 Solutions
  • 2 Likes Received

Need help building complex report

by Obsidian | Level 7 in SAS Programming
‎02-23-2024 02:36 PM
‎02-23-2024 02:36 PM
Hello, I have data in excel trying to make a report in SAS with similar format output as seen below. This is just sample, but I want the exact format with row being on left side, where I can calculate column differences and percentage changes. Really appreciate your help. Thank! ... View more

Re: Missing values after combining dataset with PROC SQL

by Obsidian | Level 7 in SAS Programming
‎08-03-2022 11:45 PM
‎08-03-2022 11:45 PM
thanks for replying! Data set A (content_) and data set C (reaction_types) do not actually have matching, it's in reaction_ an reaction_types that have matching values in type. And I want to join them all 3. ... View more

Re: Missing values after combining dataset with PROC SQL

by Obsidian | Level 7 in SAS Programming
‎08-03-2022 11:41 PM
‎08-03-2022 11:41 PM
Thanks for your reply! I am joining 3 dataset and just realized that Data set A (content_) and data set C (reaction_types) do not have matching, only reaction_ and reaction_types do in type. ... View more

Re: Missing values after combining dataset with PROC SQL

by Obsidian | Level 7 in SAS Programming
‎08-03-2022 11:36 PM
‎08-03-2022 11:36 PM
Thanks for replying! just realized that Data set A (content_) and data set C (reaction_types) do not have matching values in type as you  mention. It's actually reaction_ and reaction_types that have matching values in type.  Any tips on how to proceed at this point? here is the other part of the dataet ... View more

Missing values after combining dataset with PROC SQL

by Obsidian | Level 7 in SAS Programming
‎08-02-2022 05:38 PM
‎08-02-2022 05:38 PM
Hi everyone, I'm getting missing values after combining these 3 dataset as seen on the attached photos. There are no missing values in the key variables. I really appreciate  anyone's help!   ... View more

Re: Combine observations to get count distinct values by group

by Obsidian | Level 7 in SAS Programming
‎07-21-2022 12:07 AM
‎07-21-2022 12:07 AM
They actually do have differences in spelling such a "Animals" and "animals" ... View more

Re: Combine observations to get count distinct values by group

by Obsidian | Level 7 in SAS Programming
‎07-20-2022 11:37 PM
‎07-20-2022 11:37 PM
For example the dataset contains the following values:   Category   Category_count Animals         85 culture           37 education       33 Animals      1653 Culture        1501 Education    1278 so on...............   I want to be able to count distinct value by category group like this👇   Category   Category_count Animals           1738 Culture            1538 Education        1311               ... View more

Combine observations to get count distinct values by group

by Obsidian | Level 7 in SAS Programming
‎07-20-2022 10:21 PM
‎07-20-2022 10:21 PM
I am struck on this dataset needing help with combining observations of category variable so that I can get the count of distinct values by group. Thanks for your help! ... View more

Moving back column's values (part of it) into another column

by Obsidian | Level 7 in SAS Programming
‎07-09-2022 10:25 PM
‎07-09-2022 10:25 PM
I have a dataset with variables that contain other variable's values. For example part of address (AR 02531) is in another variable user_id as shown on the screenshot. I need help with putting the complete address as ''6208 Wright Mountains AR 02531'' Thank you! ... View more

Re: Remove space between variable name to add an underscore for exampl...

by Obsidian | Level 7 in SAS Programming
‎07-08-2022 06:37 PM
‎07-08-2022 06:37 PM
It worked great! Thank you! ... View more

Remove space between variable name to add an underscore for example (c...

by Obsidian | Level 7 in SAS Programming
‎07-08-2022 04:47 PM
‎07-08-2022 04:47 PM
I am working with a dataset that contains variables like customer ID and unit ID. I would like to remove space between them and add an underscore to be like customer_ID and unid_ID. Thanks for your help! ... View more

Re: Modify variable type in SAS model studio

by Obsidian | Level 7 in SAS Data Science
‎05-10-2021 10:23 AM
‎05-10-2021 10:23 AM
I got the dataset from kaggle, I guess I should change the data type before working with it in  sas model studio.   Thanks for responding! ... View more

Modify variable type in SAS model studio

by Obsidian | Level 7 in SAS Data Science
‎05-10-2021 01:10 AM
‎05-10-2021 01:10 AM
I am working on machine learning task in sas model studio, I have a variable bmi that's character and I want to change it to numeric, but I'm not really sure how to proceed. Any help is appreciated. Thanks!       ... View more

Re: Proc logistic - There is a complete separation of data points

by Obsidian | Level 7 in SAS Programming
‎03-09-2021 03:25 PM
‎03-09-2021 03:25 PM
Very helpful, thank you! ... View more

Re: Proc logistic - There is a complete separation of data points

by Obsidian | Level 7 in SAS Programming
‎03-09-2021 03:21 PM
‎03-09-2021 03:21 PM
I see, thank you! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-23-2024 05:56 PM
Likes given to
Likes from
View All
Quick links