Hi, I have .csv file with 3 million records to create sas data set. In this file date values are mention as following: only year and month: 1999MAY 2001JAN 2002FEB 1979DEC how can I read this YYYYMMM date value to create SAS data set with mmddyyyy format as following: 05-01-1999 01-01-2001 02-01-2002 12-01-1979 Thanks,
... View more
Hi here is information..
proc format;
value gov 0 = 'Confirming'
1='notconforming'
;
value $age '1'='25-49'
'2'='50-69'
' 3'=' 70+'
;
data A;
set B;
format gover gov. age age.;
run;
Now I am using proc export to export data set A in Excel format... I want format values in my exported excel sheet. But I got same variables values which are in data set B, how can I get this format values in my excel sheet....I will appreciate your help..
... View more
Hi,
how can I permanently change variables values by using proc format...I want to create excle file.....but when I am trying to export file with formats it agains taking original variables values rathere then formats values.....
data temp.sample_final2;
set sample_final;
format govtn gov. age age.;
run;
Thanks....
... View more
Hi Scoot,
Thanks for your help..with your help I get this one:
data A;
input id name $ age score1 score2 score3;
cards;
222 robert 42 258 239 360
333 rob 28 308 246 218
444 gary 35 234 289 290
;
run;
data B;
input id name $ age score1 score2 score3 ;
cards;
222 robert 40 258 225 356 222
333 rob 28 301 246 218
444 gary 34 234 289 256
;
run;
proc compare data=A
compare=B
outnoequal
out=C
noprint
outcomp
outbase;
id
;
run;
OUTOUT:
_TYPE_ _OBS_ id name age score1 score2 score3
BASE 2 222 robert 42 258 239 360
COMPARE 2 222 robert 40 258 225 356
BASE 3 333 rob 28 308 246 218
COMPARE 3 333 rob 28 301 246 218
BASE 4 444 gary 35 234 289 290
COMPARE 4 444 gary 34 234 289 256
But still I want to compare data set A with data set B and if both values are same then I want missing/blank on that place of observation and if it's different then I want value of data set A by ID...will appreciate if any help...
Thanks....
... View more
data A
id name age score1 score2 score3 score4
111 tom 30 230 240 260 .
222 robert 42 258 239 360 .
333 rob 28 308 246 218 .
444 gary 35 234 289 290 .
data B
id name age score1 score2 score3 score4
111 tom 30 230 240 260
222 robert 40 258 225 356
333 rob 28 301 246 218
444 gary 34 234 289 256
I want to use proc compare and want output like this:
-> compare data A with data B and in output data set C
want missing value when values are same in both data sets
and wants values from data set A when values are different in
data A and data B.
Please give syntex and output if you can...
Thanks in advance for your help....
... View more
Hey KSHARP....
Yesterday I thought mail to you this one....I read your answers before in this forum....this work perfectelly fine.....you are the best...
Thanks,
... View more
I have data set like this:
data b;
input custid emp $ age;
cards;
01 emp1 20
01 emp2 30
01 emp3 40
02 emp1 50
02 emp2 60
02 emp3 70
03 emp1 80
03 emp2 90
03 emp3 20
;
run;
and I wan to make it like this:
custid emp1 emp2 emp3 ;
01 20 30 40
02 50 60 70
03 80 90 20
;
I don't want to use Proc transpose....how can I do this........Please give quary..
... View more
Hi can anybody tell me what precorsion I need to take when I work first time on Unix environment from window SAS environment......
Thanks
TOM
... View more
