topic Re: Proc SQL Update in SAS Programming

Proc SQL Update

JHE — Thu, 08 Feb 2018 16:11:54 GMT

I have simple PROC SQL update, not sure why it dose not working.

PROC SQL;

UPDATE work.LOB2100_PF022_Summary

SET OHI_PLAN='Total Enrolled Health Plan';

QUIT;

Re: Proc SQL Update

RW9 — Thu, 08 Feb 2018 16:18:37 GMT

Not sure how we are supposed to tell from that. Are there observations in the dataset? Its telling you there was nothing to update. The syntax works fine to update all rows in the dataset,

data want;
  a="hello";
run;
proc sql;
  update want set a="Goodbye";
quit;

So either that dataset has no observations or you don't have permission to change it.

Re: Proc SQL Update

JHE — Thu, 08 Feb 2018 16:46:59 GMT

New table, just needs update value.

Re: Proc SQL Update

JHE — Thu, 08 Feb 2018 16:56:45 GMT

this is only can update one record, what f we need a list of records to be insert into the new table.

Re: Proc SQL Update

Reeza — Thu, 08 Feb 2018 16:57:02 GMT

@JHE wrote:

New table, just needs update value.

More words please. Not working doesn't tell us anything.

Re: Proc SQL Update

PGStats — Thu, 08 Feb 2018 18:39:11 GMT

To insert a new record in your table use:

PROC SQL;
INSERT INTO work.LOB2100_PF022_Summary
SET OHI_PLAN='Total Enrolled Health Plan';
QUIT;

Re: Proc SQL Update

RW9 — Fri, 09 Feb 2018 09:04:22 GMT

Due to the fact you don't want to use communication I will guess that your post means that there is no observations, hence update has nothing to update. If I was you I would start by learning Base SAS:

http://video.sas.com/#category/videos/how-to-tutorials

These will guide you on how to do all the various things in Base SAS - this is the language you are using so its good to have a thorough knowledge of it before adding additional sub components like SQL. Several of the early videos will show multiple ways of getting data into SAS datasets to work on.