topic Re: How do you add a row with values? in SAS Data Management

How do you add a row with values?

akramaiya — Fri, 03 Oct 2014 18:32:12 GMT

Hello,

I need to add a row of data in my table. Could someone please tell me how i can do this? I tried proc sql but it didn't work.

Re: How do you add a row with values?

mohamed_zaki — Fri, 03 Oct 2014 20:56:02 GMT

Where is the problem? Share your code please. Or check : Inserting Rows into Tables

Re: How do you add a row with values?

akramaiya — Fri, 03 Oct 2014 21:08:11 GMT

I followed that with the following code but got an error:

*Add row with just age*;

proc sql;

insert into sql.fevdata

values (., 8, ., ., ., .);

run;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

42 ;

43 proc sql;

44 insert into sql.fevdata

45 values (., 8, ., ., ., .);

ERROR: Libref SQL is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

46 run;

NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.

47 ;

48 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

58 ;

Re: How do you add a row with values?

ballardw — Fri, 03 Oct 2014 21:39:41 GMT

What library is your FEVDATA dataset in?

End Proc SQL with QUIT; not RUN:

Re: How do you add a row with values?

akramaiya — Fri, 03 Oct 2014 21:41:52 GMT

FEVdata is in the work library.

Re: How do you add a row with values?

ballardw — Fri, 03 Oct 2014 21:49:42 GMT

Then

proc sql;

insert into work.fevdata

values (., 8, ., ., ., .);

quit;

proc sql;

insert into fevdata

values (., 8, ., ., ., .);

quit;

sql.fevdata was telling SAS to look for the dataset fevdata in the SQL library which you obviously did not have assigned. I suspect you copied some code from some examples where all the example data was in a library named SQL. Which could be a tad confusing working in Proc SQL.

Re: How do you add a row with values?

akramaiya — Fri, 03 Oct 2014 21:53:01 GMT

Thank you very much! It worked