@Nasser_DRMCP your data step is missing a column on the input statement. data have ; length contrat classe_1 classe_2 classe_3 $15. ; input contrat $ classe_1 $ classe_2 $ classe_3 $ ; cards ; 123456789 PLNEXTIMP2 PLNEXT PLNEXT PLNEXT ; run; you have 4 fields being read by the input and 5 field values. how can it be working? ... View more

that is one of the thing you just have to deal with when using macros.  As @Reeza says keep it simple &&&&x.ed. macros are very useful but if you are having problems debugging your own macro think about the people coming in behind you.   ... View more

take a look at this solution and see if the char works for you https://communities.sas.com/t5/SAS-Programming/Check-Macro-character-variable-value-inside-a-if-condition/m-p/567407#M159555 ... View more

well @ambreen there are to many things wrong to point at just one. Try this and see if you can find out what you did wrong.   data fda; *set cdc.hw7; input gender occupation judgedpreviously age; cards; 1 1 1 21 1 1 1 48 2 2 1 54 2 1 2 35 ; PROC FORMAT; VALUE Gender 1= 'Female' 2 = 'Male'; VALUE Occupation 1= 'Mstudent' 2 = 'Nurse' 3-5 = 'Resident' 6-10 = 'Fellow'; VALUE JudgedPreviously 1= 'Yes' 2= 'No'; VALUE Age 20-29 = 'second' 30-39 = 'third' 40 - 49 = 'fourth' 50 - 59 = 'fifth'; RUN; PROC PRINT DATA= fda ;/*cdc.hw7;*/ FORMAT GENDER GENDER. Occupation Occupation. JudgedPreviously JudgedPreviously. AGE AGE.; run; The SAS System Obs gender occupation judgedpreviously age 1 Female Mstudent Yes second 2 Female Mstudent Yes fourth 3 Male Nurse Yes fifth 4 Male Mstudent No third   ... View more

leave the date the way it was if Date is a valid SAS date. then do something like this:   data temp; sasdate = "10NOV2009"d; day = day(sasdate); month = month(sasdate); year = year(sasdate); format sasdate date9.; run; proc print data = temp; run; ... View more

@JeffMeyers  when I use the macro and run it using this statement I get an error.   %data_specs(libn=sashelp,out=work);   how would I resolve this error?   ERROR: The text expression length (-30995) exceeds maximum length (65534). The text expression has been truncated to 65534        characters. ERROR:  An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [Submit] ERROR:  Write Access Violation Submit Exception occurred at (0599CE8C) Task Tracebac ... View more

@MariaD maybe you should call in and get assistance from SAS technical advisors.  If you pay for SAS and need assistance that help should be part of the purchase.     Like I noted at the beginning of this Q, test access using a real person access.  Can they make connection without using the tokens being passed?   You are the server admin?  Then call in a ticket. ... View more

Did you confirm the server is available via you personal access account??????????????? ... View more

it is acting wired but if you give it time it is working.   ... View more

your statement that it used to work and no longer does is not clear.  How do you know that it was working if you are unfamiliar with parsing? ... View more