I have spss dataset which I imported into sas to convert it to sas dataset. I want to have the formats saved in permanent datasets. Is there any datastep which can be added to save the formats in the final dataset?
... View more
Datalines
ID P1 P2 P3 P4 ….
1 0 1 0 1
2 1 0 0 0
3 0 1 1 1
Output
ID P1 P2 P3 P4
1 2 1 2 1
2 1 2 2 2
3 2 1 1 1
I want to code all "0" to 2
As these are 15 vars like this. I don't want to use if multiple else statement
... View more
Hey,
I want to transpose two variable to columns. Can you help me getting the output as listed at the bottom
Datalines;
ID Date Report
1 3/12/16 20
1 4/13/16 30
1 5/16/16 40
2 6/15/16 50
Output :
ID Date 1 Date 2 Date 3 Report1 Report2 Report3
1 3/12/16 4/13/16 5/16/16 20 30 40
proc transpose data = test out = test2 ;
var Date Report;
by id ;
run;
2
... View more
Hi edu = FINDC(Education,"MD"); Datalines Ptid EDucation 1. MD,DO 2. MD 3. PHD How I want to code Ptid EDucation edu 1. MD,DO 1 2. MD 1 3. PHD 0 edu = Find(Education, "MD")
... View more
@ed_sas_member and statement does not seem to work output is giving me missing values. I am thinking and statement does not seem to work. Do you have any options
... View more
I am trying to create a variable based on two variables elig1 elig2 if elig1 or elig2 = . then elig3 = .;
else if elig1 = 1 then elig3 = 1;
else if elig2= 1 then elig3= 2 ;
else if elig2 or elig1 = 1 then elig3 = 3; elig1 and elig2 or both yes or no variables i want to have elig3 if both elig1 and elig2 are yes(1) but having trouble as output for elig3 just includes elig2 thanks,
... View more
