i want to create a group which has A B C D in the last letter of word as one group and E, F, G H as other group in a variable
var2
DRA-04U-A
DRA-099Y-B
DRd-989-E
in this case i want to create a new variable which has A,B in one group and E in another group and so on
... View more
I have a variable and i want to extract data like example
var1
kjjhf-0fdf-dfed
asd-fdfk-dfcsf
I want to get data which is between the -
var1
0fdf
fdfk
... View more
i added the below code but still get error.
proc import datafile="&workdir./progplan.xlsm" out = import_progplan dbms = excelcs replace; sheet = "Programming Plan"; range='test1$a2:e21'n;
run;
ERROR: Server Name is invalid or missing.
... View more
i want to import .xlsm file using proc import.
when i did using the below code, i get the following error.
proc import datafile="&workdir./progplan.xlsm" out = import_progplan dbms = excelcs replace; sheet = "Programming Plan"; getnames=yes; mixed=no; run;
mixed=no; run; _____ 180
ERROR 180-322: Statement is not valid or it is used out of proper order.
ERROR: Statement or Option "GETNAMES" not valid for EXCELCS IMPORT.
Can anyone help me
... View more
Sorry for not being clear. In that case it removes all outliers but i have a range lower and upper(ex: 1.5 - 7) and if the the values are below or above these then these should not be seen
... View more
i need to create a box plot using sgplot and not disply the outliers in the graph but need to show the number of outliers(N=9) for ex.
Can any one help how can it be done
... View more
In my dataset i have a start date with both 20150912 and 22NOV2015 formats.
How do i convertthem into one format like 12OCT2015.
The variable is in NUM and format as date9. and informat 9. with length as 4
... View more
Thanks,
But in this case the drug date is in date9.(numeric) and start date is in char.
i get the below error
ERROR: The COALESCE function requires its arguments to be of the same data type.
... View more
