Hi, I'm not sure if I understand correctly the meaning of your question but I'll try to answer it. Maybe could you combine your Proc SQL with the macro facility ? That way you are able to conditionally add variables to a table: Proc sql; Create Table MyNewTable as select a.FirstVariable %IF (First condition) %THEN %DO; , 'ConditionIsTrue' as SecondVariable %END; %ELSE %DO; , 'ConditionIsFalse' as ThirdVariable %END; , 'DummyValue' as LastVariable from MyOldTable a; Quit; The problem is that this solution is not directly based on the value of other variables of your base table (excepted if you retrieve those values in previous steps by the mean of macro variable i.e...). I hope it helps. Regards, Florent ... View more

By using macro code, it can be done that way: %MACRO createFiles(number); /* MACRO definition */ %DO i= 1 %TO &number; /* Do loop */ data _NULL_; /* Creation of file */ file "d:\myfolder\datafile&i..dta"; run; %END; %MEND createFiles; %createFiles(5); /* Number of loops is defined as a parameter of the macro */ Hope it helps. Regards, Florent ... View more

Hello, Could you please provide us with more info about the following technical aspects: - Are the files being created based on one or many SAS datasets ? - What kind of files do you need to create ? (CSV, EXCEL, ... etc.) - What are the selection criteria to apply on your data before knowing in which file you'll write the data ? Regards, Florent ... View more

Hello, You could also use the combination of the COMPBL and COMPRESS functions. The first one will replace double blanks by a single blank whereas the second one will remove the single blanks from your variable. e.g: Data daset2; set Dataset1; locheight = compress(compbl(location || height)); run; Regards, Florent ... View more

Hello, The SAS dates are stored as numeric by default. You should have a look to the different formats that you can apply to dates. If you want to convert a SAS date into a character then I suggest you to use the put statement (refer to the online doc for more detailed informations). e.g. data test; set ; DateAsChar = put(DateVar, ddmmyy10.); run; I hope it helps. Regards, Florent ... View more

Hi, You can assign the status of the remote connection to a macro-variable by using the CMACVAR option within your SIGNON statement. You'll find more details about that option by reading the following documentation: http://support.sas.com/documentation/cdl/en/connref/61908/HTML/default/signon.htm Regards, Florent ... View more

Hi, Using the following statement will probably fit with your needs: sum(case when upcase(table.name) LIKE '%STOVE%' then 1 else 0 end) as TotalCount Regards, Florent ... View more

Ok 🙂 Could you try with the following statement ? Print_Header='&E Fichier audité : ' || "&fichierATraiter" Florent ... View more

Phil, What & are you talking about ? It doesn't appear in your first message. Florent ... View more

Hi, Couldn't you use the following statement ? Print_Header="&E Fichier audité : &fichierATraiter" Regards, Florent ... View more

Hi, I faced the same kind of issue and fixed it by forcing SAS to make the automatic conversion to a numeric variable. In your example, it becomes: if bal= put(((lagbal*-1)+lagbal2), best32.) then paid=0; I don't know what really is the problem with SAS (we are still using the version 😎 for such a situation and even don't know whether there is a fix to apply in order not having to implement such crappy solutions... Kind regards, Florent ... View more

Hi KevinC, You can use the following statement: if input(first_prin_bal2, ?? best.) > .z then second_prin_bal2=first_prin_bal2+0; Kind regards, Florent ... View more

Hi, I understand your problem and I'm pretty sure that the issue that you're facing with your third statement is related to the server name that you're using (following part: server = teradata). 3rd statement: libname tera server = teradata user='scott' password='tiger' slibref = test; You have to make sure that it corresponds to the server name that you specified when connecting to the remote SAS server (maybe could you provide me with the connection statement(s) after removing the username and password info from it ?). Here is an example of connection to a remote SAS server (where the part 'remote=SasHost' should be equal to 'remote=teradata' in your case): %let SasHost = ; options comamid=TCP remote=SasHost; signon username= password= ; It's also possible that you only have one statement to connect to your remote SAS server... I'm used to split it in 3 as you can see in the previous example. Kind regards, Florent ... View more

Emerald, You're welcome 🙂 When establishing the connection to your remote server (signon statement), do you define 'teradata' as remote session id (the 'remote=' part of your signon statement)? Libname statement has the following syntax: LIBNAME libref <'SAS-data-library'> SERVER=remote-session-id ; You have to make sure that the 'remote_session_id' that you use in your libname statement is the same that the one defined when establishing the connection to your remote server. Hope it helps. Kr, Florent ... View more