You can use FILENAME EXCEL "name_of_file.xls" ; DATA _NULL_; set your_dataset ; FILE EXCEL lrecl=25000 ; if _n_ = 1 then do ; PUT 'column1' '09'x 'column2' '09'x 'Column3' '09'x ...............'Columnn' '09'x ; end; PUT column1 '09'x column2 '09'x column3 '09'x ......... columnn '09'x ; RUN ; Use the numxwd. format to format your numeric values.
... View more
Hi, with your data, i suggested you to try this ... data nouv (drop=lstdat); retain lstdat; set have; by client; if first.client then lstdat=.; daysdifference=intck('days',lstdat,purchasedate); lstdat=purchasedate; run; FB.
... View more
Hi all, Finally I gone through this issue by using these options of the goptions statement. GOPTIONS NOPOLYGONCLIP NOPCLIP NOPOLYGONFILL; Thanks. More information here 639 - "0C4 abend in function GGCLPPG" with PROC GPLOT using the AREAS= option
... View more
Hi, this helps you get what you want... Assume that toto is your initial dataset proc sort data=toto out=titi; by id id1 id2 date1 date2 status; run; data tata; set titi; by id id1 id2 date1 date2 status; if last.date1; if status in ('PC', 'DE') then delete; run; BR.
... View more
Hi, I'm working in SAS 9.1.3 and When running my program in batch on a Linux machine, i have the following message : Recursive Segmentation Violations - system exiting System Exiting Status=803fc21d fin: erreur: 1 message: interrompu avant sa fin normale. I've tried the options nocodegen but it doesn't work. Can someone advice plz?
... View more
Hi,
Just to let you know how I finally gone through this problem.
I removed the multichoice parameter from the storedprocess and created instead in the MAP a filter allowing user to choice many values in a list.
Now it's ok.
... View more
Hi everyone,
I've created a storedprocess with a multichoice parameter named "organization" and it works correctly. When I use the storedprocess in an Information MAP, the MAP does'nt resolved the "organisation0" macro variable created by SAS when multiple entries are selected for the parameter "organisation" and thus doesn't give me the expected result.
Did anyone faced this before and how did you manage going through it?
Thanks in advance for your input.
... View more