@scott : i believe a little modification will do my need . not as per the missing value , lookin on taking the update from slave dataset or new dataset values to the master dataset . Thanks
... View more
Here is the scenario main_data name my_value A 20 A 50 new_data name my_value A 80 update via data step data main_data; update main_data new_data; by name; run; Output : name my_value A 80 A 50 update via proc sql proc sql; update main_data set my_value=(select my_value from new_data where main_data.name=new_data.name) ; run; output: name my_value A 80 A 80 Both the above update doesnt yeild the same result !!! y are'nt they both same ???????? I want the output as the proc sql way,how do i achieve this thru data step ???
... View more
you can try the below which is quite simple data temp; infile '/path/file.txt' scanover; input @'question' question $char100.; input @'a' a $char20.; input @'b' b $char20.; input @'c' c $char20.; input @'d' d $char20.; run;
... View more
Hi , if the raw file is the exactly in the form as you have mentioned you could try below code : date temp; infile '/path/temp.txt' DLM='09'x DSD MISSOVER; input mydata $ 50; run; data temp_new; lenght question $ 50 a $ 25 b $ 25 c $ 25 d $ 25 ; do i=1 to nobs/10; m=2+m; set temp point=m nobs=nobs; question=mydata; m=m+2; set temp point=m nobs=nobs; a=mydata; m=m+2; set temp point=m nobs=nobs; b=mydata; m=m+2; set temp point=m nobs=nobs; c=mydata; m=m+2; set temp point=m nobs=nobs; d=mydata; retain m; output; if nobs then; stop run; i believe this will do
... View more
I hope the sas is installed on window machine!!! you will first have to import the dataset into sas window environment, so that sas will be able to recognize the path. I am not sure if there is a plugin for it. try using a statement "run;" at the end..
... View more
