Latest Tagged - SAS Support Communities

Subject

Replies

Author

Likes

Views

Latest Post

Proc SQL how to use SET FROM statement correctly - ( ‎12-02-2024 09:39 PM )

2

Obsidian | Level 7

0

814

by

Find Standard deviation from 2, or more, columns/variables with aim of... - ( ‎04-27-2024 08:11 PM )

11

Lapis Lazuli | Level 10

0

4130

by

Duplicates in the table, but keep them based on other conditions - ( ‎03-15-2024 01:38 PM )

11

Obsidian | Level 7

0

2722

by

Create a table with increasing integers from 1 to N in SQL - ( ‎02-29-2024 12:06 PM )

16

Obsidian | Level 7

0

6419

by

How do I use a temporary SQL table in passthrough? - ( ‎02-03-2024 11:41 AM )

5

Fluorite | Level 6

0

3066

by

How to deduplicate data using Proc Sql with 2 different criteria. - ( ‎10-23-2023 06:26 PM )

6

Fluorite | Level 6

0

2108

by

What is the equivalent SQL code for first. or last. - ( ‎10-19-2023 10:13 AM )

13

Obsidian | Level 7

1

5948

by

Re: How to use cast function in SAS - ( ‎10-10-2023 02:00 PM )

0

Ammonite | Level 13

1

13066

by

Outer join- force missing values to not match? - ( ‎08-22-2023 02:21 PM )

2

Fluorite | Level 6

0

855

by

Re: Using a macro variable with into: in PROC SQL - ( ‎08-23-2022 05:28 PM )

1

2

1470

by

Re: Using a variable in PROC SQL AS - ( ‎08-02-2023 04:52 PM )

0

2

1650

by

Re: Help needed to find alternatives for joins - ( ‎07-28-2023 12:21 PM )

0

Obsidian | Level 7

2

903

by

ds2 vs proc sql - ( ‎05-17-2018 12:51 PM )

5

Quartz | Level 8

1

2195

by

How do I flag increases in variables that are in two datasets - ( ‎02-17-2023 02:25 PM )

4

Fluorite | Level 6

0

1779

by

Can't remove duplicate rows after merging two datasets - ( ‎01-18-2023 01:31 PM )

11

Fluorite | Level 6

0

4639

by

How to make API requests with loop in SAS - ( ‎09-12-2022 09:25 AM )

2

Fluorite | Level 6

0

1089

by

SQLITE over ODBC -- works but get weird error messages - ( ‎08-25-2022 07:12 PM )

9

Fluorite | Level 6

0

3425

by

Using a macro variable with into: in PROC SQL - ( ‎08-23-2022 02:11 PM )

4

Fluorite | Level 6

0

1519

by

Create Volatile Table in Teradata Using ODBC - ( ‎06-14-2022 10:52 PM )

12

Obsidian | Level 7

0

3924

by

Convert a Ranged Lookup to Standard - ( ‎05-19-2022 10:58 AM )

4

Pyrite | Level 9

0

1574

by

Merging in SQL, want to write this code in sql: if (a and b) = 1 then ... - ( ‎03-28-2022 09:08 AM )

3

Obsidian | Level 7

1

2186

by

How do I use/refer a macro variable in a macro parameter? - ( ‎11-04-2021 06:40 PM )

3

Obsidian | Level 7

0

1365

by

Reference a Sequence of Columns in PROC SQL - ( ‎08-02-2021 01:48 PM )

8

Pyrite | Level 9

1

4333

by

PROC SQL Syntax Error - ( ‎07-20-2021 03:19 PM )

3

Pyrite | Level 9

0

1200

by

Sum column based on "date between" - ( ‎05-06-2021 12:43 PM )

2

Calcite | Level 5

0

903

by

PROC RANK order by descending - ( ‎04-27-2021 03:57 AM )

4

Calcite | Level 5

0

1776

by

How can I concatenate variables based on a rule? - ( ‎03-31-2021 07:06 AM )

10

Fluorite | Level 6

0

2180

by

Using & variable to automate CAT - ( ‎03-26-2021 11:47 AM )

2

Fluorite | Level 6

0

822

by

How to implement different formulas in long format data that differ de... - ( ‎12-23-2020 04:02 AM )

1

Quartz | Level 8

0

1047

by

Sas proc sql to teradata - ( ‎07-19-2020 05:57 AM )

7

Fluorite | Level 6

0

2067

by

Pass-through facility SQL access - ( ‎07-13-2020 10:09 AM )

3

Fluorite | Level 6

0

1034

by

How to do a summary for the totals for each quarter and send output to... - ( ‎05-26-2020 01:46 PM )

3

Obsidian | Level 7

0

1146

by

Macro function to create an "EquiJoin" Condition - ( ‎03-21-2020 04:06 PM )

2

Pyrite | Level 9

0

847

by

SQL Memory Usage - ( ‎02-26-2020 04:38 PM )

4

Calcite | Level 5

0

1641

by

PROC SQL row order - ( ‎02-11-2020 06:04 PM )

4

0

2918

by

How to calculate percentages and counts with PROC SQL? - ( ‎01-15-2020 02:17 PM )

8

Fluorite | Level 6

0

26185

by

Re: combining overlap date ranges based on the effective run dates and... - ( ‎12-30-2019 01:38 PM )

4

Fluorite | Level 6

0

1928

by

How do I create this table using proc sql passthru using teradata cal... - ( ‎11-16-2019 09:04 PM )

4

Obsidian | Level 7

0

1866

by

Pulling Data from SQL Server Based on List of Values in SAS Table - ( ‎10-30-2019 12:11 PM )

70

Pyrite | Level 9

0

7297

by

Left Join not Correct When using Where Clause - ( ‎10-16-2019 12:42 PM )

4

Pyrite | Level 9

0

1369

by

Selecting Data based off of Date and ID - ( ‎07-25-2019 11:57 AM )

2

Pyrite | Level 9

0

1635

by

Getting max value by group and with a predefined time horizon. - ( ‎05-12-2019 04:42 PM )

13

Obsidian | Level 7

0

5394

by

Comparing between dates across column and rows - ( ‎05-06-2019 12:27 PM )

3

Calcite | Level 5

0

1308

by

how do i concatenate multiple tables in proc sql - ( ‎04-05-2019 09:06 AM )

6

Obsidian | Level 7

0

5270

by

PROC SQL question - ( ‎04-05-2019 03:18 AM )

4

Calcite | Level 5

1

1540

by

Re: Please help me to find the top three salary from emp table - ( ‎03-05-2019 10:03 AM )

1

Barite | Level 11

1

1905

by

Proc SQL in macro - ( ‎01-11-2019 04:19 AM )

14

Obsidian | Level 7

0

3702

by

Proc SQL Join - ( ‎12-13-2018 06:06 PM )

8

Quartz | Level 8

0

2292

by

Proc sql for all columns in a table - ( ‎10-30-2018 03:57 PM )

11

Fluorite | Level 6

0

4991

by

Passing a value from Netezza back to SAS using a macro variable. - ( ‎10-10-2018 10:42 AM )

12

Obsidian | Level 7

0

3534

by