Search results for query: *

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...

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...

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

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

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

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...

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

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...

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...

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...

%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...

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...

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

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...

yes, I see it. Thanks so much

thx

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

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

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%...

Thanks so much. :)