Hi!   I need some help. I have a dataset with the follow structure(the are not the real name is only for exemple) and i want to order (descending) the Vble_B for each differnt value of Vble_A.   For exemple: I have this: Another variable 1 Another variable 2 Another variable 3 Vble_A Vle_B Another variable 4 Another variable 5 Another variable 6       XY 0,6             XY 0,3             XY 0,4             XY 0,12             XY 0,56             BV 0,18             BV 0,56             BV 1,2             BV 0,32             BV 0,8         And I want to get this :   Another variable 1 Another variable 2 Another variable 3 Vble_A Vle_B Another variable 4 Another variable 5 Another variable 6       BV 0,18             BV 0,32             BV 0,56             BV 0,8             BV 1,2             XY 0,12             XY 0,3             XY 0,4             XY 0,56             XY 0,6         I need do this to can choose then the higher 10%.   Do you have any idea to make that ? I tried with PROC sort and PROC sql/order by I can't get the right result.   Thank you very much!! ... View more

Hi!   I'm want to import a lot of CSV(DLM=';') files and  because I had problems with numeric and data variables, I did a Data step and  INFILE to can change the informat and the format. To know which informat choose in every variable, I did before an import with the sas's assistant for one file and I copied the program from the log and I modified thant a little.  The problem is: in this code there is a parameter 'LRECL' with a determinate value choosed by Sas but if I set the same value (or the default value) for all files the informat and format choosed do not work in the others files, and is very difficult to know which value set for every file because I have a lot of files. Do you know another way to make that?  I don't understand why the format and informat works in this situation and do not work in another.   I copy here the structure of my program. If you know a way to choose always the right informat I will be very grateful, I have often problem with that.   Thanks you very much! ... View more

Hi, Is my first time with SAS's macro and i want to import several csv file with a data step using INFILE (to can change the formats and informats). I tried this code but i don't know how to define a macro's variable to make variate the data set's name for each file imported. I think that the statement "(table_name=)" is wrong but i don't know how to specify this. I need your help, thank you very much!     %MACRO import (fichier=) (table_name=); DATA WORK.&table_name; INFILE "/data/XXX/Lignes/&fichier" LRECL=603 ENCODING="LATIN9" TERMSTR=CRLF DLM=';' FIRSTOBS=2 MISSOVER DSD ; INPUT 'VARIABLE A'n : $27. vARIABLE B: $34. FORMAT 'VARIABLE A'n $27. vARIABLE B $34. INFORMAT 'VARIABLE A'n $27. vARIABLE B $34. RUN; %MEND; %import (fichier=file_AB.csv); %import (table_name=table_sas_AB);   ... View more

Hi,    I have a beginner question. I have two databases in quarterly data. In one of them the variable quarterly is in format $8. (ex: 1991Q1, 1991Q2, 1991Q3 etc) and in the other is in format DDMMYY10 (ex: 01/01/1996 is the first quarter, 01/04/1996 the second, etc). I need both variables in the same format to make a Merge by the variable in quarterly. I tried that but it did not work, i get the numbers such 13149, 13240 and i don't undestand why.   DATA IPCH_trim ; set ipch_trim ; format trim $8. ; run ;   Can you help me to change the format please?. Ideally to change the variable in DDMMYY10  format to the format $8.   Thanks you very much ... View more