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: 
Primohunter
‎12-05-2022
  • 18 Posts
  • 16 Likes Given
  • 0 Solutions
  • 2 Likes Received

Use of 'case when + contains/like' when i have number such as 50 and 5...

by Obsidian | Level 7 in SAS Enterprise Guide
‎11-28-2022 10:11 AM
‎11-28-2022 10:11 AM
Hello everyone, i m trying to create a new column (using case when and contains/like) depending on the context of another string column, but i find it troublesome when it comes to containing numbers such as 50 and 500 for example:   HAVE DATASET CPP blabla DP50_L blablablu DP 50 L ble DP50 blx DP50_500  blibli DP500_L bliblibla DP 500 L bliblible DP500 blublu DP500 50   WANT DATASET CPP                               SPEED blabla DP50_L                50 blablablu DP 50 L           50 ble DP50                        50 blx DP50_500                50 blibli DP500_L                500 bliblibla DP 500 L           500 bliblible DP500               500 blublu DP500 50             500   As a result, i have faulty classification. What is the proper way to create the column of the example above? Thanks alot for your time and insights! ... View more

Create V2 based on V1 and where V1 missing, assign the max value of V1...

by Obsidian | Level 7 in SAS Enterprise Guide
‎11-24-2022 08:42 AM
‎11-24-2022 08:42 AM
Hello everyone, i have a question regarding the creation of a column based on another, as you can read in the subject. Example HAVE DATASET: V0    V1                  1       23/11/22 2       24/11/22 3       . 4       21/11/22   WANT DATASET: V0    V1                 V2   1       23/11/22       23/11/22 2       24/11/22       24/11/22    3       .                    24/11/22 4       21/11/22       21/11/22     Thank you all, in advance ... View more

Re: combining 2 rows of same VAR1 value but dif VAR2 and VAR3 values

by Obsidian | Level 7 in SAS Enterprise Guide
‎10-06-2022 06:14 AM
‎10-06-2022 06:14 AM
Thanks for your response will keep that in mind. i just used different real life variable names to make the reasoning easier. Is there another way to do it with those character variables? ... View more

Re: combining 2 rows of same VAR1 value but dif VAR2 and VAR3 values

by Obsidian | Level 7 in SAS Enterprise Guide
‎10-06-2022 06:02 AM
‎10-06-2022 06:02 AM
lets just say that for some reason nick and john are both qualified for having VAR 3 AND VAR 4  (e.g. 'Y') but the input program could only accept  only one VAR input at a time. For example nick wears a black and white shirt  so the dataset becomes as follows:    PROBLEMATIC INPUT                                                    DESIRED FORMAT FOR FURTHER ANALYSIS Name     Status       White   Black              --->                    Name     Status       White   Black   Nick      Dressed        Y         N                                                Nick      Dressed        Y         Y         Nick      Dressed        N         Y ... View more

combining 2 rows of same VAR1 value but dif VAR2 and VAR3 values

by Obsidian | Level 7 in SAS Enterprise Guide
‎10-06-2022 05:43 AM
‎10-06-2022 05:43 AM
Hello everyone, below you can find an example of a data set that i want to turn to the OUTPUT example below as well. Have DATASET: Var1     Var2     Var3     Var4 Nick      ran1       Y        N Nick      ran1       N        Y John     ran2       Y         N John     ran2       N         Y George  ran3      N        Y   Output (Want) Dataset:   Var1     Var2     Var3     Var4 Nick      ran1       Y        Y John     ran2       Y         Y George  ran3      N        Y ... View more

Re: missing value is screwing my whole dataset

by Obsidian | Level 7 in New SAS User
‎02-02-2022 11:18 AM
‎02-02-2022 11:18 AM
https://www.kaggle.com/adityak2003/college-basketball-players-20092021?select=CollegeBasketballPlayers2022.csv there u go. 2022 college ... View more

Re: missing value is screwing my whole dataset

by Obsidian | Level 7 in New SAS User
‎02-02-2022 11:09 AM
‎02-02-2022 11:09 AM
never opened again the csv with the excel. in fact the default program to open csv file is notepad. ... View more

Re: missing value is screwing my whole dataset

by Obsidian | Level 7 in New SAS User
‎02-02-2022 08:46 AM
‎02-02-2022 08:46 AM
Well here is my dataset. I wanna use some of its stats   for a correlation analysis (PROC CANCORR)  and i d like to fix my dataset in order to do so... The missing values ( . , NA, ) are messing with how the program reads the lines.   Im also attaching the csv file ... View more

missing value is screwing my whole dataset

by Obsidian | Level 7 in New SAS User
‎02-02-2022 07:22 AM
‎02-02-2022 07:22 AM
Hello,   i have a dataset with 60 variables. i wanna use in my code only 10-11 of them. But i cant input only those because of some missing values on a variable i m not gonna use. So i dropped the DATA want;                                               INFILE 'mypath.csv';          way of importing the data and then i moved to PROC IMPORT where i get a result without an error ONLY if use the guessingrows=max but then the variable Player Name gets to 385 length   and im afraid something else is also screwed up in the dataset. My Code so far is Any help doin this firstly with the INFILE method and then the import one? ... View more

Suggestion for Analysis and PROC

by Obsidian | Level 7 in SAS Programming
‎02-01-2022 08:27 PM
1 Like
‎02-01-2022 08:27 PM
1 Like
Hello everyone,  I am looking for suggestions on methods of analysis and what SAS PROC i can use for the following variables/dataset Suggestions such as: how to find the win probability for the Home_Team?! Many thanks in advance. ... View more

Re: Dates prior to 1900 dataset

by Obsidian | Level 7 in SAS Programming
‎02-01-2022 05:38 PM
‎02-01-2022 05:38 PM
Thanks for the whole explanation. U are too kind! Thanks again everyone! ... View more

Re: Dates prior to 1900 dataset

by Obsidian | Level 7 in SAS Programming
‎02-01-2022 05:09 PM
‎02-01-2022 05:09 PM
thanks you. that seemed to be the problem. redownloaded the file changed the default program to open csv files to notepad and reuploaded it in SAS. it seems to be working properly now. Thanks again for your time ... View more

Re: Dates prior to 1900 dataset

by Obsidian | Level 7 in SAS Programming
‎02-01-2022 04:51 PM
‎02-01-2022 04:51 PM
https://www.kaggle.com/martj42/international-football-results-from-1872-to-2017 ... View more

Re: Dates prior to 1900 dataset

by Obsidian | Level 7 in SAS Programming
‎02-01-2022 04:45 PM
‎02-01-2022 04:45 PM
The file is .CSV just as i have downloaded it from kaggle. I used excel just to check the format and help myself understand why i cant solve the problem.  The sas text editor was showing me the same thing     Probably the column Date has character values written like YYYY-DD-MM that.   and Also dates with numeric values with the format DD-MM-YY... ... View more

Re: Dates prior to 1900 dataset

by Obsidian | Level 7 in SAS Programming
‎02-01-2022 04:31 PM
‎02-01-2022 04:31 PM
  Well i hope this answers your question.     When i open my CSV file in excel, i could see that the dates prior to 1900 are all in GENERAL Form and they are all written in the form of 1899-10-23  and the dates after 1900 are all in  DATES form (DD-MM-YY). i really dont know hot to fix this via SaS.. Any way to remove first all the numeric dates and change the character ones to numerics and then add the numeric ones? is there another way? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-05-2022 12:04 PM
Likes given to
Likes from
View All
Quick links