How do you add a row with values?

[akramaiya]

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.

[mohamed_zaki]

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

[akramaiya]

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.

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 ;

[ballardw]

What library is your FEVDATA dataset in?

End Proc SQL with QUIT; not RUN:

[akramaiya]

FEVdata is in the work library.

[ballardw · Accepted solution]

Then

proc sql;

   insert into work.fevdata

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

quit;

or

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.

[akramaiya]

Thank you very much! It worked