Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. on818come

    Need help! my profile.catalog is locked

    NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead. NOTE: All registry changes will be lost at the end of the session. NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. NOTE: This...
  2. on818come

    How to add new observation to dataset based on original observations?

    Actually it derives from a stupid question. I have the data file like Ulti Part Tply 120.00 86.11 0.0064 119.00 84.22 0.0063 123.00 86.90 0.0065 117.00 83.11 0.0063 120.00 85.91 0.0062 I expect to get statistics...
  3. on818come

    How to write in a merged cell by DDE processing?

    Sorry, repeat the reply. Actually what I wanna know is how to import SAS data to merged cell, very important and not avoidable problem for me thanks a lot
  4. on818come

    How to write in a merged cell by DDE processing?

    So, please just tell me how to merge two cells in EXECL by DDE
  5. on818come

    How to write in a merged cell by DDE processing?

    So, just tell me how to merge two cells in EXCEL by DDE
  6. on818come

    How to write in a merged cell by DDE processing?

    filename title dde 'excel|[ASAP1.xls]INPUT DATA!r10c4:r10c4' notab lrecl=20000; data _null_; file title; put 'CTD'; run; But this cell is merged by two closed cells. I've got information like "Can't change part of a merged cell", and there is no answer in related tech document. Thanks for...
  7. on818come

    A simple question

    proc means data=sample.b CV; Var f15 f16 Avgtply NormUlti Norm2percent; Title 'Summary of PB1 final'; output out=sample.a; Run; My simple question is: How to output procedure data to dataset, with CV. Each time I get something like MEAN N STED... But no CV
  8. on818come

    How to stop during the loop to assign new value to variables

    Another foolish question, why I can't input character variable from keyboard by %windows macro, I can only input numbers. %window dialoguewindow icolumn=15 irow=10 columns=80 rows=20 "<Creat a summary sheet>" #3 @20 "Adjusted Table Format" #5 @15 "please enter information of tables" #7 @15...
  9. on818come

    How to stop during the loop to assign new value to variables

    The code is shown below: %macro append; DATA sample.export; %clipboard; Run; PROC APPEND BASE=sample.export1 DATA=sample.export FORCE; run; %mend append; %let vara=&TestProp; %macro merge(num); %do _i_ = 1 %to &num; data _null_; slept = sleep(10); run...
  10. on818come

    How to repeat macro in dataset?

    I'm really confused about macro and data step in SAS. Can I do like this? %macro append; DATA sample.export1; if &TestProp NE 100 then %clipboard; Run; PROC APPEND BASE=sample.export1 DATA=sample.export1 FORCE; run; %mend append; %macro merge; x=4; ulabel:x=x-1; %append if x GT 1...
  11. on818come

    How to repeat macro in dataset?

    %macro merge; DATA sample.export1; if &TestProp NE 100 then %clipboard; Run; PROC APPEND BASE=sample.export1 DATA=sample.export FORCE; run; %mend merge; %merge What I'm doing is merging several tables ( from 2 to 5)into a summary sheet. Each time get new list of observations from a clipboard...
  12. on818come

    A short question about %windows

    Hey, you guys!I encountered a small problem While I was seting a parameter-feedback window %window feedback icolumn=15 irow=10 columns=80 rows=20 "<Creat a summary sheet>" #3 @20 "Adjusted Table Format" #5 @15 "please enter information of tables" #7 @15 "The Testing Property" @40 TestProp 6...
  13. on818come

    Some question about modifying excel by DDE

    I got some idea after reviewing the instruction. but still expect some more detailed explanation. Thx :)
  14. on818come

    Some question about modifying excel by DDE

    I have read the instruction of DDE. It really helps. But still some question I can't figure out. 1. How to add content to one cell. 2. How to move the table entirely to some specific position in the sheet, or how to add empty columns and lines. 3. I want to keep some content in orginal template...
  15. on818come

    how to make the variable's name more descriptive

    yes, I see it. Thanks so much
  16. on818come

    Hw to create a new variable from old var.

    Another question: how to keep variable's label name in Excel sheet after exporting data.
  17. on818come

    Hw to create a new variable from old var.

    Hi. I have a variable with name "specimen#" given data format like A0N1A114A, I hope to get the fourth number(1 in the case) and create a new column. please help me. Thanks
  18. on818come

    How to change a variable?

    I have a question. When I input variables and define the format. SAS always puts characters variables together by changing th column order. Such as: f1 f18 f19 f2 f3 A0N1 77 F/ 65 % 2% 1 0.127 A0N1 77 F/ 65 % 2% 1 0.128 A0N1 77 F/ 65 % 2% 1 0.128 A0N1 77 F/ 65 % 2% 1 0.126 A0N1 77 F/ 65 % 2%...

Part and Inventory Search

Back
Top