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: 
kirkends
‎01-27-2022
  • 4 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Help Splitting a String and reshaping a data set

by Fluorite | Level 6 in New SAS User
‎06-04-2021 01:09 PM
‎06-04-2021 01:09 PM
@ballardw I have about 7 data sets all answering the same questions, but all entered in unique and creative formats. This is the most common entry layout but it is not the same across each dataset. I am hoping to reshape the dataset into the requested final format, merge all 7 sets (for sharing) and eventually provide frequency counts for IN OUT N/A N/O per V#.      ... View more

Help Splitting a String and reshaping a data set

by Fluorite | Level 6 in New SAS User
‎06-04-2021 12:08 PM
‎06-04-2021 12:08 PM
I am new to SAS and need some help reshaping a data set and am not sure where to start. My data set is an excel. I think I need to use an Array but am not sure how to logic it.    HAVE  Unique ID  IN OUT N/A N/O 1 1, 2, 3, 4, 5, 6, 7, 10, 11, 13, 15, 16, 17, 21, 22, 24, 28 30 14, 18, 19, 20, 23, 25, 26, 27, 29 8, 9, 12 2 30       3 1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 13, 15, 16, 17, 21, 22, 28   14, 18, 19, 20, 24, 25, 26, 27, 29 8, 12, 23 4 1, 2, 3, 4, 5, 10, 11, 13, 14, 15, 16, 17, 22, 28   18, 19, 20, 21, 25, 26, 27, 29 6, 7, 8, 9, 12, 23, 24 5 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 13, 15, 16, 17, 20, 22, 23, 28 10 14, 18, 19, 24, 25, 26, 27, 29 12, 21   Want   uniqueID V1 V2 V3 V4 V5 V6 V7 V8 V9 V10 V11 V12 V13 V14 V15 V16 V17 V18 V19 V20 V21 V22 V23 V24 V25 V26 V27 V28 V29..... V30           1 IN IN IN IN IN IN IN N/O N/O IN IN N/O IN N/A IN IN IN N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A IN N/A N/A           2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . IN           3 IN IN IN IN IN IN IN N/O IN IN IN N/O IN N/A IN IN IN N/A N/A N/O IN IN N/O N/O N/A N/A N/A IN N/A N/A           4 IN IN IN IN IN N/O N/O N/O N/O IN IN N/O IN N/A IN IN IN N/A N/A IN N/O IN IN N/A N/A N/A N/A IN N/A N/A           5 IN IN IN IN IN IN IN IN IN OUT IN N/O IN N/A IN IN IN N/A N/A IN N/O IN IN N/A N/A N/A N/A IN N/A N/A           ... View more

Re: Counting the occurrence of a variable across columns per observati...

by Fluorite | Level 6 in SAS Studio
‎01-06-2021 05:56 PM
‎01-06-2021 05:56 PM
This is exactly what I was looking for. Sorry about the term mix up I am still learning! This does explains why me searches were fruitless.... I am working on Survey Data and 1=yes, 0=No, 7=unknown, 9=missing, I just converted characters to numerics for ease of uses in other inquiries. Thank you ... View more

Counting the occurrence of a variable across columns per observation

by Fluorite | Level 6 in SAS Studio
‎01-06-2021 04:04 PM
‎01-06-2021 04:04 PM
I am new to SAS so forgive me if this is basic. I have a data set with 150,000+ rows, each with a unique ID, and 250 columns, all columns must be retained. However for this specific inquiry, I am only interested in 13 columns; each column is a variable with a valueof  "0" "1" "7" or "9".  I would like to make a new column that counts the number of times a "1" populates a column cell across the row/observation.    For example:                                                                                                                        count of "1" ID         Col1    Col2     Col3    Col4    Col5     Col6      Col7    Col8................WANT  152         1           0          1          0         1           9          1          7                        4 153         0           0          7          7         1           9          0          9                        1 154         1           9          1          9         9           0          0          9                        2 155         7           1          9          1         9           1          1          9                        4 156         9           0          0          9         0           0          0          0                        0 157         9           7          9          0         7           1          0          0                        1       I have tried solutions from other forums with similar problems haven't found anything that has worked for me. I appreciate the help!!  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-27-2022 01:21 PM
Likes given to
View All
Quick links