Search results for query: *

Hello SAS gurus I am just wondering that, is there any way to read crystal report RPT files into a sas data set?

options missing=''; DATA Test; infile datalines; input sab yymmdd10. DOB yymmdd10.; datalines; 19901225 19661225 19960906 19960605 19960305 19970804 99999999 00000000 ; run; options missing=.; options missing=''; data _NULL_; set test; file "C:\Documents and...

Hello Guys, I need help for changing my date format. cards; 19901225 19960906 19960305 ; These date are in yyyymmdd format, I want to just flip that dates into mmddyyyy format. So, my output will be 12251990 09061996 03051996 Please help me out. Thanks!!

here is total code- data a1; set a; row = compress (row, '" " '); fdate= compress (fdate, '" " '); nav_pn= compress (nav_pn, '" "'); pdc= compress (pdc, '" "'); oldfcst= compress (oldfcst, '" "'); curfcst= compress (curfcst, '" "'); rcrdtype= compress (rcrdtype, '" "'); run; data a1; set a1...

And for periods you can use same method, instead of " " you should put .

Here is code, try this- data a1; set a; row = compress (row, '" " '); fdate= compress (fdate, '" " '); nav_pn= compress (nav_pn, '" "'); pdc= compress (pdc, '" "'); oldfcst= compress (oldfcst, '" "'); curfcst= compress (curfcst, '" "'); rcrdtype= compress (rcrdtype, '" "'); run;

Hello everyone, I am stuck in importing some .dbf files, can anyone please tell me that "if i want to choose some specific variables from .dbf file, like in .dbf file has 100 var and I want only 15 var and I want to select that 15 var while importing file into SAS ", How can i do that? Thanks...

We can use CATX function.

Hello all, I need some help about combining two variables like, zipcode will be P_zip+P_zip4 (Here P_zip and P_zip4 are 2 different variables containing null values too.) So, zipcode will be P_zip+P_zip4 and separated by hyphen. e.g. 1)P_zip = 1233 P_zip4= 1563 zipcode = 1233-1563...

It works, awesome!! Many many thanks for your help. Thanks again. :)

Hey klaz, thanks for helping, but I could not able to find the whole syntax for compress statement. Actually I am very new for this SAS programming. If possible to you then can you please send me whole syntax.... like Data "data name"... Thanks again

Can anyone help me? I stuck in removing commas from my sas dataset. Well, I wants to generate .csv file from my sas dataset but due to some commas are already existed in original dataset; it generates extra variable. Thanks in advance.

We can use proc SQL, like Alter table statement, because i got the answer but let me try the code of yours.

Well, I have already a dataset in which i wants to create multiple variables which are blank.

How can i create new variables but no data, like absolutely blank, no zero, no periods in SAS?

I am using put function for adding zero before the numeric Is there a way for it not to get lost when exporting to Excel or html?

Awesome jim... its really great :) I really appreciate for you guys Jim and Mike. thanks a lot!

Well that's great! But i want to do that automated; like if there are 1000000 files in ver 6.0 and i want to copy that all into 2x version then i really don't want to do it manually, So i need a macro which i can run only once and all files can be copied in 2x version.

I have one question that I want to copy some .dbf files from foxpro 6.0 to foxpro 2.0 always for use of some SAS programming. Do you have any idea about any macros written so there will be no need to write code again and again. Please help me out. Thanks & regards