About CMilena

CMilena · ‎10-20-2011

I want send proc tabulate result to excel. Is it possible?

CMilena · ‎09-15-2011

Hi Mariek, The problem start from = symbol. You can try this step %Macro test (dx); proc sql; create table diag_heart as select patid, diag; from table1 where diag IN &dx; quit; %Mend test; %test (( "I05%","I06%","I07%"));

CMilena · ‎03-14-2011

Hi, I have csv file ex: id money 1 31803,03 I want read in sas db money whit format BEST12. ex: id money 1 31803.03 but the output is this: ex: id money 1 3180303000 money format = COMMA1 money informat = COMMA3. Why sas read the number in this way? Are there any option to set in proc import step? Can I change the money format? Message was edited by: CMilena

CMilena · ‎03-09-2011

The option putnames=no don't run. I read previous forum posting. In the end I use data _null_; set db ; file "P:\Risk Management\MORTGAGE\........."; put (_all_) (:);run; Thanks !!

CMilena · ‎03-08-2011

When I export txt file whit PROC EXPORT PROC EXPORT DATA= RATA_0_TXT OUTFILE= "P:\Risk Management\MORTGAGE\...............txt" DBMS=TAB REPLACE; RUN; I wouldn’t write the column's name . How can I do? Thanks in advance

CMilena · ‎03-08-2011

I never can find this solution Thank you very much!

CMilena · ‎03-08-2011

Hi. I have a very easy problem that i can't seem to google myself out of. I've searched the forums, but without luck. I want renames more sas dataset ex: current dataset names : x_2011, x_2010, x_2009, x_2008 ... new_manes: p_2011, p_2010, p_2009, p_2008 ... I can use PROC DATASETS LIBRARY=xxx; CHANGE db_old=db_new; QUIT;RUN; but I won't repeat db's name. How can I do? Thanks in advance ...

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Export - proc tabulate

handover a list in Proc SQL

Proc import csv

Re: PROC EXPORT file .txt

PROC EXPORT file .txt

Re: PROC DATASETS - CHANGE Statement

PROC DATASETS - CHANGE Statement