Hi All I have a table with approximately 500 fields and 500000 records and I want to export it to excel, but when I used 'proc export' the following error occurred: ERROR: Error attempting to CREATE a DBMS table. ERROR: Execute: Too many fields defined.. Is there any way to export large-scale tables to excel sheets? Thanks
... View more
I have a table like this data concat; input name $; datalines; a b c d ; run; How can I turn values of culomn 'name' into a single string of a, b, c, d ?
... View more
another question: Does this code guarantee that we read the inserted record? I mean if another data inserted from another procedure while our proc sql is running, does it guarantee that the result is our record? this procedure lock the table while runing or not?
... View more
Dear Ksharp I read the values from table 'three' and insert it to 'one', how can I keep the rsult of (select *... ) in a table? It seems that it doesn't understand the code. my code is: data three; input name $ sex$ age@@ height@@ weight@@; cards; Patrick M 30 52.2 89.4 ; run; proc sql; insert into one (name, sex, age, height, weight) select name, sex, age, height, weight from three; select * from one except select * from two; quit; run;
... View more
Hi all I want to insert a record to a table in oracle and read its ID just after inserting it. I don't want to lose my record while so many records might be inserted at the time. How can I do that? Thanks a lot
... View more
Hi I have a data set like A B C D E 1 12 3.2 .... 1.5 10 4 1.3 11 5.6 . . . I want to extract name of correlated variables from it for example I want a result like this: A B C D E which means A&B are correlated, C&D are correlated and E in independent I used proc corr to have correlation matrix but I don't know how can I extract name of correlatd variables from it. Can anybody help me in this issue? Thanks a lot
... View more