topic Re: insert values using proc sql with conditionaly in SAS Programming

insert values using proc sql with conditionaly

BrahmanandaRao — Mon, 10 Apr 2023 07:28:28 GMT

data insertvalues;
set sashelp.class;
run;


data newvalues;
set insertvalues  ;
 output; 
if mod(_n_,2)=0 then do  ;
 name='Anand';
 sex='M';
 age=16;
 Height= 8.11 ;	Weight= 54.22;
 output;
 end;
 proc print;
 run;

how to insert values conditionally in proc sql

Re: insert values using proc sql with conditionaly

Kurt_Bremser — Mon, 10 Apr 2023 08:05:15 GMT

Maxim 14. Use the Right Tool.

Here, it is the data step, which you already use. Forget SQL whenever sequence matters, and using it here would be pure idiocy.

Re: insert values using proc sql with conditionaly

Kurt_Bremser — Mon, 10 Apr 2023 11:26:15 GMT

If this is another of your useless homeworks (what imbecile comes up with such stupid exercises for things you will NEVER do in real life, and where the time could have been used for teaching meaningful things like hash objects, instead of being a total waste?), here some hints:

Use OUTER UNION CORR to stack the dataset with itself
as the first source, use the variables as they are, and create a new one (_name) from name, and another (_flag) as 0
as the second source, use name as _name, create all others (name,sex,age,height,weight) with your values, and _flag as 1
order by _name and _flag
drop both new variables with a dataset option from the result

As you will see, the code will be unwieldy and ugly as hell, and just an illustration what being a total idiot entices. Scratch this experience from your memory ASAP, it only wastes precious neurons.

Re: insert values using proc sql with conditionaly

Ksharp — Mon, 10 Apr 2023 11:53:36 GMT

You can't "insert values conditionally in proc sql".
INSERT statement in SQL is like PROC APPEND, can't like data step update obs conditionally.

Re: insert values using proc sql with conditionaly

Oligolas — Tue, 11 Apr 2023 11:49:16 GMT

Hi,

there is a way...

PROC SQL ;
   CREATE VIEW CLASS AS
      SELECT monotonic() AS _N_,*
      FROM sashelp.class
   ;
   CREATE VIEW class_hlp AS
      SELECT monotonic()+.1 AS _N_,
             'Anand' AS name,
             'M' AS sex,
             16 AS age,
             8.11 AS Height,
             54.22 AS Weight
      FROM CLASS
   ;
   CREATE TABLE want(DROP=_N_) AS
      SELECT *
      FROM CLASS
      UNION CORRESPONDING ALL
      SELECT *
      FROM class_hlp
      WHERE (mod(int(_N_), 2)=0)
      ORDER BY _N_
   ;
   DROP VIEW class, class_hlp;
QUIT;

Re: insert values using proc sql with conditionaly

Ksharp — Tue, 11 Apr 2023 11:54:08 GMT

You create a NEW dataset ,not insert into original dataset .

Re: insert values using proc sql with conditionaly

Oligolas — Tue, 11 Apr 2023 13:24:32 GMT

That's exactly what I do 🤗 and meet the requirement 🎉

I conditionally insert values in a dataset with PROC SQL

Re: insert values using proc sql with conditionaly

PGStats — Tue, 11 Apr 2023 17:51:57 GMT

That something can't or shouldn't be done is precious knowledge. And being told so is not convincing for some. I suspect that such is the purpose of this exercise.

Re: insert values using proc sql with conditionaly

Kurt_Bremser — Tue, 11 Apr 2023 18:46:23 GMT

@PGStats wrote:

That something can't or shouldn't be done is precious knowledge. And being told so is not convincing for some. I suspect that such is the purpose of this exercise.

True, true.

Re: insert values using proc sql with conditionaly

ballardw — Tue, 11 Apr 2023 20:17:00 GMT

@PGStats wrote:

That something can't or shouldn't be done is precious knowledge. And being told so is not convincing for some. I suspect that such is the purpose of this exercise.

I also wonder how well the poster is translating or understanding the original assignment.

Juola's metatheroem: You will seldom misunderstand a problem so as to make it simpler.

Dr. Robert Juola was my first professor in statistics and made this comment after several assignments ...