About 14sas

14sas · ‎01-11-2016

how to preserve dropping zeros while opening an csv file in excel .

14sas · ‎01-11-2016

how proc import will help me can you quote me any example.Thanks

14sas · ‎01-11-2016

if i use proc import ,will it works if i ever do this FTP?

14sas · ‎01-11-2016

with proc import ?

14sas · ‎01-11-2016

this is my program : data_null_; filename abcd 'c:/sample.csv'; set sample; file abcd; delimiter=' ,' dsd 1rec1=350; if _n_=1 then do ; put ' date ' 'name' 'location' end; put date name location ; run; in output date variable appears as 1045 instead of 001045 .

14sas · ‎01-09-2016

If I don't include commas in header column , The output would be : Abcdf,9:9/2001,losangeles n so nn

14sas · ‎01-08-2016

they are not in prorper rows i ,e date is not under date coilumn and so on

14sas · ‎01-08-2016

name date place gender abcdef,09/09/2001,losangeles,male This how it appears when i try to open in word pad .

14sas · ‎01-08-2016

I need an output in csv ,and my program is : data_null_; filename; set; file delimiter=',' dsd 1rec1 = 350; if_n_1 = 1 then do ; put 'name' 'date' 'place' 'gender' ; end; put name date place gender ; run; now my issue is when i open the ouput file either in excel or word pad name date place gender abcdef,09/09/2001,losangeles,male how to arrange or reformat .,where there is no mention of size of variables in requiremnt .

14sas · ‎01-06-2016

Yes , there are but this is Wat my requirement is .

14sas · ‎01-06-2016

This is my program: proc sql; create table TEST as where relationship_cd ='s' then employee_id = "S"II ''II (employee_id) else trim (employee_id) end as employee_id from master_file ; quit;

14sas · ‎01-06-2016

when i try this ,emp_id for dependents coming up only with prefix instead of prefix+emp_id .

14sas · ‎01-06-2016

this wont be a new column ,just whenever your relationship_cd is dependent ,emp_id has to be prefix + emp_id .

14sas · ‎01-05-2016

I want employee_id for spouse as S+ employee_id of the spouse

14sas · ‎01-05-2016

The spouse column already exists as membership_cd as dependent , employee_id is numeric, in my desired output whenever membership_cd is dependent , in the employee_id it has to be Semployee_id , where s is the character adding to employee_id

Online Status	Offline
Date Last Visited	‎01-11-2016 09:59 PM

how to preserve from dropping zero ,while opening csv file in excel

Re: how to avoid dropping zeros in csv when i open in excel

Re: how to avoid dropping zeros in csv when i open in excel

Re: how to avoid dropping zeros in csv when i open in excel

how to avoid dropping zeros in csv when i open in excel

Re: output in csv format

Re: output in csv format

Re: output in csv format

output in csv format

Re: how to add prefix to a column

how to preserve from dropping zero ,while opening csv file in excel

Re: how to avoid dropping zeros in csv when i open in excel

Re: how to avoid dropping zeros in csv when i open in excel

Re: how to avoid dropping zeros in csv when i open in excel

how to avoid dropping zeros in csv when i open in excel

Re: output in csv format

Re: output in csv format

Re: output in csv format

output in csv format

Re: how to add prefix to a column

Re: how to add prefix to a column

Re: how to add prefix to a column

Re: how to add prefix to a column

Re: how to add prefix to a column

Re: how to add prefix to a column