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

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

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 # data _null_; slept = sleep(10); run...

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

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

Hi I'm trying to use the export procedure to create excel files. A little problem is how to keep label as variable names in Excel sheet. Who can help me to make the variable's name more descriptive. Proc export data=sample.export1 OUTFILE = 'C:\Jia\export.xls' REPLACE; RUN;

Hello, you guys. I'm trying to make new summary sheets, and modify a series of variables' name. First read files from Excel and change varible's name to the table's first line. Can anyone help me? Thanks so much