import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
# “%cd” is one of magic command.
%cd C:\D\WinSAS\HF\HF13A\sb
adsl = pd.read_sas('hf_f014.sas7bdat', format='sas7bdat')
adsl
# the next is testing filtering
adsl1=adsl[(adsl['sex']==b'1') & (adsl['area']==b'2') ]
adsl1[(adsl1['age'] >=25 )&(adsl1['age']<=64) & (adsl1['year'] >=1972 )&(adsl1['year']<=2002) ]
how to code in Python "where" clause of SAS
| Messages In This Thread |
|
how to code in Python "where" clause of SAS - by FelixS - Mar-26-2019, 01:47 PM
RE: how to code in Python "where" clause of SAS - by buran - Mar-26-2019, 02:09 PM
RE: how to code in Python "where" clause of SAS - by FelixS - Mar-26-2019, 04:59 PM
|
| Possibly Related Threads… | |||||
| Thread | Author | Replies | Views | Last Post | |
| How to use the LIKE clause in Python | Columbo | 9 | 1,680 |
Oct-09-2022, 10:22 PM Last Post: Larz60+ |
|
| SQL Query is not executing WHERE clause | hammer | 7 | 2,394 |
Nov-15-2021, 01:44 PM Last Post: hammer |
|
| How does this if clause work? | Pedroski55 | 3 | 2,323 |
Jun-10-2021, 06:31 AM Last Post: Gribouillis |
|
| can i raise an exception in a try clause? | Skaperen | 14 | 5,816 |
Dec-19-2019, 12:29 AM Last Post: Skaperen |
|
| pass captured value from input() to where clause | metro17 | 5 | 3,312 |
Sep-09-2019, 05:24 AM Last Post: metro17 |
|
| finally clause | Skaperen | 6 | 3,914 |
Jun-02-2019, 09:02 PM Last Post: snippsat |
|
| if clause fails | DeadCthulhuWaitsDreaming | 10 | 4,824 |
Apr-07-2019, 09:19 PM Last Post: DeadCthulhuWaitsDreaming |
|
| break Statements and else Clause on Loops | Phytonnewbie | 2 | 2,819 |
Mar-02-2018, 09:50 AM Last Post: buran |
|
| My else clause doesn't work (general help) | NMW | 10 | 8,017 |
Jul-17-2017, 01:07 AM Last Post: ichabod801 |
|
Users browsing this thread: 2 Guest(s)