cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
R_A_G_
‎09-01-2015
  • 161 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: removing an observation

by Calcite | Level 5 in SAS Procedures
‎10-09-2012 05:24 PM
‎10-09-2012 05:24 PM
thank you Doc, it actually worked. PROC MEANS DATA=data(where=(people^='Jim' ));var item1; Run; ... View more

Re: removing an observation

by Calcite | Level 5 in SAS Procedures
‎10-09-2012 05:16 PM
‎10-09-2012 05:16 PM
I want to eliminate a specific observation from a specific sets of variable. Not really eliminate but rather exclude from the analysis. ... View more

removing an observation

by Calcite | Level 5 in SAS Procedures
‎10-09-2012 01:29 PM
‎10-09-2012 01:29 PM
Hello, I would like to find the mean for one of my variables, but that variable has one outlier observation. How can I find the mean of that variable without that one observation with PROC MEAN. Thank you ... View more

If-Then

by Calcite | Level 5 in SAS Procedures
‎10-06-2012 06:08 PM
‎10-06-2012 06:08 PM
would some one help with this code. Instead of 0 1 2 3 I get only 0's and 1's why? data IEEE.item_coded (drop=item1-item116 iii); set IEEE.item; array f_item(116); array item(*) item1-item116; do iii=1 to 116;   if item{iii}<0.000623175 then f_item{iii}=3;    else if item{iii} lt 0.002864969 then f_item{iii}=2;    else if item{iii} lt 0.013617708 then f_item{iii}=1;    else if item{iii} le 0.431834293 then f_item{iii}=0;   if item{iii} lt 0.001041523 then f_item{iii}=2;    else if item{iii} lt 0.008116862 then f_item{iii}=1;    else if item{iii} le 0.431834293 then f_item{iii}=0;   if item{iii} lt 0.002864969 then f_item{iii}=1;    else if item{iii} le 0.431834293 then f_item{iii}=0; end; run; ... View more

if-then follow up to renaming

by Calcite | Level 5 in SAS Procedures
‎10-06-2012 05:50 PM
‎10-06-2012 05:50 PM
I have a follow up question. I want to change these values but when I do it my values are only 0's and 1's. data IEEE.item_coded (drop=item1-item116 iii); set IEEE.item; array f_item(116); array item(*) item1-item116; do iii=1 to 116;   if item{iii}<0.000623175 then f_item{iii}=3;    else if item{iii} lt 0.002864969 then f_item{iii}=2;    else if item{iii} lt 0.013617708 then f_item{iii}=1;    else if item{iii} le 0.431834293 then f_item{iii}=0;   if item{iii} lt 0.001041523 then f_item{iii}=2;    else if item{iii} lt 0.008116862 then f_item{iii}=1;    else if item{iii} le 0.431834293 then f_item{iii}=0;   if item{iii} lt 0.002864969 then f_item{iii}=1;    else if item{iii} le 0.431834293 then f_item{iii}=0; end; run; ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-06-2012 05:23 PM
‎10-06-2012 05:23 PM
thanks didn't see the reply, please ignore the last question ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-06-2012 05:16 PM
‎10-06-2012 05:16 PM
Just curious to know why iii fixed the problem thanks ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-06-2012 03:29 PM
‎10-06-2012 03:29 PM
it worked but why? thanks ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-06-2012 03:05 PM
‎10-06-2012 03:05 PM
thanks for letting me know about the last problem. my code is: data new (drop=b--dm);   set old;   rename A=people;   label A=people;   array data_in(*) b--dm; array item(116); do i=1 to 116; item(i)=data_in(i); end; run; as for the log there is no sign of problems LOG: 140  data new (drop=b--dm); 141 142    set old; 143 144    rename A=people; 145 146    label A=people; 147 148    array data_in(*) b--dm; 149 150  array item(116); 151 152  do i=1 to 116; 153 154  item(i)=data_in(i); 155 156  end; 157 158  run; NOTE: There were 96 observations read from the data set WORK.OLD. NOTE: The data set WORK.NEW has 96 observations and 117 variables. NOTE: DATA statement used (Total process time):       real time           0.04 seconds       cpu time            0.04 seconds ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-06-2012 02:38 PM
‎10-06-2012 02:38 PM
I cannot figure out why but this new code does not work CODE: data want (keep=people item:);   set data;   array data_in(*) a--dq;   array item(116);   people=data_in(1);;   do i=1 to 116;     item(i)=data_in(i-1);   end; run; ERROR: All variables in array list must be the same type, i.e., all numeric or character. ERROR: All variables in array list must be the same type, i.e., all numeric or character Instead I just  added this( rename A=people; label A=people) did this and worked except...: But I have another problem on my hand now. after renaming the data I've noticed that one of the variables' value,"item 8 " is recorded as "8" not its real value. why is that? thanks ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-05-2012 04:28 PM
‎10-05-2012 04:28 PM
it worked, except that I had to rename and label it to people as well. thank you ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-05-2012 01:21 PM
‎10-05-2012 01:21 PM
Also this one does not work. data new;   set data;    rename col1=CE     col2-col117=item1-item116; run; Error: WARNING: The variable col1 in the DROP, KEEP, or RENAME list has never been referenced. WARNING: Not all variable names in the RENAME list col2-col117 were used. NOTE: There were 96 observations read from the data set DATA. ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-05-2012 01:10 PM
‎10-05-2012 01:10 PM
I tried the last code code but for some reason it's giving me this error: 2104  Proc import file="C:\Users\Roofia\Desktop\DATA\try.xls" out=IEEE.data dbms=excel replace; ERROR: DBMS type EXCEL not valid for import. ... View more

Re: import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-05-2012 10:24 AM
‎10-05-2012 10:24 AM
But I don't have any names for my variables to rename. the first variable has to be named people and the rest item1-item116 thanks ... View more

import data and naming the variable

by Calcite | Level 5 in SAS Procedures
‎10-05-2012 09:41 AM
‎10-05-2012 09:41 AM
Hello, I have a data set that I would like to import and name the variables. This code works but don't know how to name them thank you Proc import file="C:\try.xls" out=data dbm=xls replace; startrow=1; getnames=no; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links