hi, I had a couple of questions around ASCII file: Suppose i have 1000s of variables in an ASCII file and I do not want to define all of them separately. Can we define the variables in block in SAS, say blocks of 500 variables? While exporting the data file to ASCII format, it gives first row as variable names and also give "tab"s between the values? Is there any way to export the data from SAS to proper ASCII with correct column positions as the original file format (without variable names and without "tab"s) and also with a data map? I am currently using following code:      PROC EXPORT DATA=libname.data OUTFILE="D:\xyz\test.asc" DBMS=tab REPLACE; run; Any help will be appreciated! Thanks! ... View more

Hi all, I have worked more on SPSS than SAS. In SPSS, i know we can recode variables easily using following command: recode x (1=2) (else=copy). : to recode all the 1's as 2's in the same variable x OR recode y (9=sysmis). : to make all the 9's in x missing. I dont need to create a new variable in SPSS to do so, i can simple change some of the values in the original variable. How can the same be done in SAS? I tried using PROC FORMAT, but I think it just allows to assign some value labels for the values (1=Yes, 2= No). Please let me know if anyone has the solution. Thanks! ... View more

Hi all, I am very new to SAS and i have some basic questions. If i have only SAS Base, can I perform basic procedures like - PROC REG, PROC FACTOR, PROC RANK, PROC MI, PROC IMPORT, PROC EXPORT, PROC MEAN??? Or do I need to have SAS STAT for some of these??? Are there any limitations if I use SAS Base for these procedures??? Regards, MK ... View more