Hi, I have this dataset where I want to display the subtotals and grand total without using a proc tabulate. From my "HAVE" dataset, I'd like the totals (num1 and num2) be calculated for each Group, and the grand total be calculated, placed in the first cell of the "WANT" dataset. I'd like to have the output in SAS dataset form, not Proc Report nor Tabulate. Thank you! data have; input Group :$20. Member :$20. num1 num2; datalines; Group_a Member_a_1 6 0 Group_a Member_a_2 4 1 Group_b Member_b_1 6 3 Group_b Member_b_2 3 1 ; run; data want; input final_text :$20. num1 num2; datalines; Grand_Total 19 5 Group_a 10 1 Member_a_1 6 0 Member_a_2 4 1 Group_b 9 4 Member_b_1 6 3 Member_b_2 3 1 ; run; ... View more

Hi! I'd like to know how I can zip datasets (SAS and non-SAS) , using X command in SAS.   We only have SAS 9.1 installed, and no existing ZIP programs in our computers. I've been trying the below code, but I won't get it to work successfully.   x 'zip myzipfile.zip /file/to/zip.csv';   I've also tried a gunzip code, but it's also not working.   Thank you! ... View more

Whenever we open a table in SAS DI, we return a "no rows" window even though the physical version of the table still exists (physical is still in the server with rows). How can we view the metadata of the tables again?   Some of our DI jobs execute with error due to the empty metadata. ... View more

Hi! I have this dataset with old and new birth dates for each name. I'd like to get the birth date from the rows with Source = "NEW". But for names with no Source = "NEW" (as in the case below SARAH), I'd like to retain the old record.    I'd like to do it with only one SQL statement without need of joining tables, I'm thinking of a group by and min/ max statement.. but I can't get it right. Or is it not possible? Thank you.     data have; infile datalines missover; input NAME :$5. BIRTHDATE :$8. SOURCE :$3. ADDRESS :$8.; datalines; ANGEL 09122018 OLD USA ANGEL 09112018 NEW FELIX 07252017 OLD UK FELIX 07252017 NEW SARAH 09092018 OLD CANADA ; run;       data want; infile datalines missover; input NAME :$5. BIRTHDATE :$8. SOURCE :$3. ADDRESS :$8.; datalines; ANGEL 09112018 NEW USA FELIX 07252017 NEW UK SARAH 09092018 OLD CANADA ; run; ... View more

Hi, I'd like to output which ranges overlap (no fixing of affected ranges required).    data HAVE; infile datalines dlm="|"; input NUM1 NUM2 ADDRESS :$12. CITY :$12.; datalines; 0|2|GREEN ROAD|RED CITY 1|4|GREEN ROAD|RED CITY 3|4|GREEN ROAD|RED CITY 5|7|GREEN ROAD|RED CITY 2|9|WHITE ROAD|RED CITY ; run;     /*Output affected Ranges*/ data WANT; infile datalines dlm="|"; input NUM1 NUM2 ADDRESS :$12. CITY :$12.; datalines; 0|2|GREEN ROAD|RED CITY 1|4|GREEN ROAD|RED CITY 3|4|GREEN ROAD|RED CITY ; run;     ... View more

Hi, I would like to detect duplicate rows in my dataset below    data HAVE; infile datalines dlm="|"; input COL1 :$5. COL2 :$5. COL3 :$5.; datalines; CAT|DOG|ANT ANT|CAT|DOG HORSE|CAT|HORSE ; run;   *It's in Row 1 and 2. /*Output Duplicates*/ data WANT; infile datalines dlm="|"; input COL1 :$5. COL2 :$5. COL3 :$5.; datalines; CAT|DOG|ANT ANT|CAT|DOG ; run;   I'm not sure how to do it, I was thinking of transposing, sorting, then concatenation, but it seems not efficient. Perhaps there is a better way to do it. Thank you!       ... View more

I have a REF_TABLE containing some ranges.   If street number from the HAVE table field (address field in text) falls under the ranges in the REF_TABLE, how can I classify the address field based on the range group in the REF_TABLE?   Here are the codes for the tables: REF_TABLE   data REF_TABLE; infile datalines dlm="|"; input STARTNUM ENDNUM GROUP :$10.; datalines; 0|10|GROUP1 11|20|GROUP2 ; run;     HAVE table   data HAVE; infile datalines dlm="|"; input ADDRESS :$20.; datalines; 1 STREET #11 STREET ; run;     WANT table (expected result)   data WANT; infile datalines dlm="|"; input ADDRESS :$20. GROUP :$10.; datalines; 1 STREET|GROUP1 #11 STREET|GROUP2 ; run;     Thank you! ... View more

Hi, I need help to produce the WANT dataset from my HAVE dataset. data want; input num code $; cards; 1 A 1 B 2 C 2 D ; run;   data HAVE; input num code $; cards; 1 A,B 2 C,D ; run; ... View more