Questions about proc-sql
Read more about proc-sql
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Insert multiple columns into a single column using pandas
I am converting a SAS code to python and got stuck here.
My input table is like:-
St
sgmt
Val
A
CD
200
A
PQ
300
My output should be like:-
Col
Val
A
500
CD
200
PQ
300
500...
user18734161
Votes: 0
Answers: 1
Construct continuous intervals from non-contiguous validity ranges
Given
data have;
infile datalines missover delimiter="|" dsd;
input id :$20. (start_date end_date) (:date9.) (attribute_1 attribute_2 attribute_3 attribute_4) ($);
format start_d...
legends1337
Votes: 0
Answers: 0
How to use a SAS Macro inside data step
I'm running a code similare to the following one and the data step is not working and I can't seem to understand why
%macro macro_1(variable);
rsubmit;
data want_&variable. (keep = a b c);
set hav...
Thomas Sere
Votes: 0
Answers: 1
Skip/Ignore a condition in CASE statement in SQL
I have a query in which I am querying based on few CASE conditions. I want a particular CASE statement to do nothing and skip that case all together.
select colA
case
when colB = 'P' then colC in (col...
Rogue258
Votes: 0
Answers: 1