python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - proc-sql

How to use SAS - PROC SQL, IF THEN statement and a Do loop in 1 script?

Hopefully somebody can help me with my problem. For the company I work for, I need to check if there is any data available in the dataset which is delivered monthly to me. If there is no data availabl...
test-img

Roontje

if-statement

sas

sas-macro

proc-sql

do-loops

Votes: 0

Answers: 1

Latest Answer

Sounds like you just need to create a dataset with the list of values you want to force to exist and merge it with your actual data. data required; do yearmonth = 202110, 202111 ; output; end...
test-img

Tom

Use multiple proc sql or just 1 to join 3 tables to 1 table?

I have a large table A, with around 5M observations and want to join it with 3 other tables with around 400k observations each. The tables will be joined using different keys to A. All tables have jus...
test-img

Vishrut Jaipuria

sas

left-join

proc-sql

Votes: 0

Answers: 1

Latest Answer

The only richt answer to your question is: It does not matter. In contrast to many other procedures and to the data step, proc sql does not wait for a run statement to execute: each sql statement is e...
test-img

Dirk Horsten

Creating a flag using CASE WHEN with multiple conditions in PROC SQL

I'm trying to create a flag indicating if a customer is a holistic customer based on different combinations of their subscription types. ID Subscriber_Type 1 Online 1 Mail 1 Email 2 Online ...
test-img

Alice Wang

case

proc-sql

Votes: 0

Answers: 1

Latest Answer

There is for sure a cleaner way to do this, but the following should give you the expected output. data have; infile datalines4 delimiter="|"; input id subscriber_type $; datalines4; 1|Onlin...
test-img

Kermit

PROC Transpose by YearMonth and ID for duplicate values

I'm trying to transpose this table: YearMonth ID Purchase Purchase Value 201912 1 Laptop 1000 202012 1 Computer 2000 202112 1 Phone 1000 201912 2 Stereo ...
test-img

Alice Wang

sas

proc-sql

Votes: 0

Answers: 1

Latest Answer

Assuming agent_number is equivalent to id in your example, I reproduced the data: data have; infile datalines4 delimiter="|"; input yearmonth id purchase :$8. PV; datalines4; 201912|1|Laptop...
test-img

Kermit

Posts

Questions

Blogs

Jobs