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: 
Konkordanz
‎08-03-2023
  • 122 Posts
  • 62 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: shorter way to combine rows

by Pyrite | Level 9 in SAS Programming
‎09-15-2021 02:34 AM
‎09-15-2021 02:34 AM
Faster coding 😉 ... Im leanring SAS and SQL and Im always interested in finding shorter ways for my coding issues. ... View more

Re: shorter way to combine rows

by Pyrite | Level 9 in SAS Programming
‎09-15-2021 02:33 AM
‎09-15-2021 02:33 AM
Thank you! This easy way works! Cause Im learning SAS and SQL im looking also for a solution in SQL...do you have one? ... View more

Re: shorter way to combine rows

by Pyrite | Level 9 in SAS Programming
‎09-15-2021 02:31 AM
‎09-15-2021 02:31 AM
A solution with sql would be great...but I dont get your point, sry. Can you please show it to me as code? ... View more

shorter way to combine rows

by Pyrite | Level 9 in SAS Programming
‎09-14-2021 05:36 AM
‎09-14-2021 05:36 AM
Hey forum,   Ive 8 tables with the same columns and only 1 row. I want to combine all the rows into one table. For doing that Im using the following steps...Its working. But: It feels like a dirty method. Is there a better (shorter) way to reach the aim? Thank you!   proc sql; insert into c5 select * from c4; quit; proc sql; insert into c6 select * from c5; quit; proc sql; insert into c7 select * from c6; quit; proc sql; insert into c8 select * from c7; quit; proc sql; insert into c9 select * from c8; quit; proc sql; insert into c10 select * from c9; quit; proc sql; insert into c11 select * from c10; quit; ... View more

Re: SQL sum: avoid rounding

by Pyrite | Level 9 in SAS Programming
‎09-09-2021 07:59 AM
‎09-09-2021 07:59 AM
Thank you! ... View more

SQL sum: avoid rounding

by Pyrite | Level 9 in SAS Programming
‎09-09-2021 07:32 AM
‎09-09-2021 07:32 AM
Hi,   in my dataset Kredit1 I want to sum the values of the column c3 and want to copy the result into a new row of the same table. That works. But: The result has no or only one decimal-digit. The aim is: 3 decimal-digits. I use the following code...is there a option for this code, which could help?     proc sql noprint; select sum(c3) into :Gem3 from Kredit1; quit; proc sql; insert into KREDIT1 (NameBST,c3) values ("Gem",&Gem3); quit;       ... View more

Re: output proc report: No zeros

by Pyrite | Level 9 in SAS Programming
‎08-12-2021 05:47 AM
‎08-12-2021 05:47 AM
Thank you all, this forum is very helpful and important for me! ... View more

Re: output proc report: No zeros

by Pyrite | Level 9 in SAS Programming
‎08-12-2021 05:14 AM
‎08-12-2021 05:14 AM
@all: Thank you for your help, pretty helpful! It works! 🙂 But Ive one more question: In some cells the result is not 0 but empty. In the output it results in a point. But empty cells also should be a "-". I tried it with this code but it doesnt work. Could you please give me another hink?     proc format; value nozero 0='-' other=[best10.2]; value nopoint "" ="-" other=[best10.2]; run; proc report data=... [...] define Jahr_&Jahr1. / display "Data" style={cellwidth=5 cm} format=nozero.; format=nopoint.; ... View more

Re: output proc report: No zeros

by Pyrite | Level 9 in SAS Programming
‎08-11-2021 04:47 AM
‎08-11-2021 04:47 AM
Thank you both for your answers, good ideas. @PaigeMiller : I tried also your way to understand the proc-format-thing. But it doesnt work. I tried this code, but where is the problem of my attemption?   data have; input city $ price; datalines; Dresden 2005 Berlin 0 Frankfurt 0 Bonn 2 Berlin 4030 Bonn 0 Dresden 2005 Frankfurt 6053 Berlin 0 Frankfurt 0 Dresden 0 Bonn 0 Berlin 4030 Frankfurt 0 Bonn 3050 Dresden 0 ; run; proc format; value $nozero 0='-' other=[best10.2]; run; proc report data=have; column city price; define city / display; define price / display format=$nozero; run; ... View more

output proc report: No zeros

by Pyrite | Level 9 in SAS Programming
‎08-10-2021 07:51 AM
‎08-10-2021 07:51 AM
Hi Forum,   I have a SAS-Output with Zeros in serval cells. These are the result of a formular many steps earlier. But: I dont want to get these Zeros in my output. I actually want SAS to do: If the result=zero then give me a "-" in this cell. Is it for example in the output-option doable?   Thank you! ... View more

Re: New column with value by group

by Pyrite | Level 9 in SAS Programming
‎08-09-2021 03:50 AM
‎08-09-2021 03:50 AM
@Ksharp and @PaigeMiller: Thank you! Both are practial solutions! ... View more

New column with value by group

by Pyrite | Level 9 in SAS Programming
‎08-06-2021 08:15 AM
‎08-06-2021 08:15 AM
Hi,   Ive a dataset with a column "city" (each city exists multiple times) and a column with "prices" (€, sometimes also multiple times, but always the same price). In the price-coulumn there are many empty cells. What I want is to fill the empty cells with the city specific prices. How is this doable? Maybe with Alter table?   Have: city price Dresden 2005 Berlin   Frankfurt   Bonn   Berlin 4030 Bonn   Dresden 2005 Frankfurt 6053 Berlin   Frankfurt   Dresden   Bonn   Berlin 4030 Frankfurt   Bonn 3050 Dresden   ....n ....   want: city price price2 Dresden 2005 2005 Berlin   4030 Frankfurt   6053 Bonn   3050 Berlin 4030 4030 Bonn   3050 Dresden 2005 2005 Frankfurt 6053 6053 Berlin   4030 Frankfurt   6053 Dresden   2005 Bonn   3050 Berlin 4030 4030 Frankfurt   6053 Bonn 3050 3050 Dresden   2005 ...n .... ....   Thank you for help!       ... View more

Re: copy specific value for each city in new var

by Pyrite | Level 9 in SAS Programming
‎08-03-2021 05:18 AM
‎08-03-2021 05:18 AM
Thx for explaination. So, can it interprated as follows? And what does the open points mean? What I doesnt understand: The code shall combine table a and table b...but isnt the column "city" only a content of the table a?     create table want as select a.city,a.year,a.quarter /*these var comes into the temp. table "a"*/, b.population as pop_q4_2020 /*this var comes into the temp table "b" and get a new name*/ from have /*the source-table of the variables */ as a left join (select * from have where year=2020 and quarter=4) /*all data of the table "a" with the filter year=2020 and quarter=4 shall get involved*/ as b /* ????*/ on a.city=b.city; /*????*/ quit;       ... View more

Re: copy specific value for each city in new var

by Pyrite | Level 9 in SAS Programming
‎08-02-2021 07:41 AM
‎08-02-2021 07:41 AM
Great, thank you! Do you have a further minute for writing a short description what your sql-commands exactly do? What for example means the "a.*" (a.city, a.quarter,...)? I want to learn it and need to get some hinks... ... View more

copy specific value for each city in new var

by Pyrite | Level 9 in SAS Programming
‎08-02-2021 06:50 AM
‎08-02-2021 06:50 AM
Hi forum,   I have a dataset with >400 cities. Each city has population-values for all quarters of 2 years (Q1 2019, Q2 2019, ..., Q4 2020). I want to create a new variable (pop_q4_2020) with the values of Q4 2020 of the respecitve city. Thats what I have:     data have; input city $ year quarter population; datalines; CityA 2019 3 20029 CityB 2019 2 34900 CityA 2020 2 19853 CityB 2020 2 34500 CityA 2019 2 20029 CityA 2020 4 19853 CityB 2020 4 34300 CityA 2019 4 20029 CityB 2019 3 34800 CityB 2020 1 34600 CityA 2019 1 20135 CityA 2020 3 19853 CityB 2020 3 34400 CityB 2019 4 34700 CityA 2020 1 20029 CityB 2019 1 35000 ; run;   Thats what I want:   Region year quarter pop_q4_2020 CityA 2019 3 19853 CityB 2019 2 34300 CityA 2020 2 19853 CityB 2020 2 34300 CityA 2019 2 19853 CityA 2020 4 19853 CityB 2020 4 34300 CityA 2019 4 19853 CityB 2019 3 34300 CityB 2020 1 34300 CityA 2019 1 19853 CityA 2020 3 19853 CityB 2020 3 34300 CityB 2019 4 34300 CityA 2020 1 19853 CityB 2019 1 34300   I tried it with this steps: create a new var and copy the value of population-var if year=2020 and quarter=4. But I dont know how to copy the values into the cells with the same city-names.   Thank you for help!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-03-2023 10:38 AM
Likes given to
Likes from
View All
Quick links