I have used the following code:   data people; input obs name$; cards; 1 Frank 2 Joan 3 Sui 4 Jose 5 Burt 6 Kelly 7 Juan ; run; data money; input name$ sal; cards; Frank 100 Joan 210 Sui 250 Jose 330 ; run; data work.empsalary; set work.people (in = inemp) work.money (in = insal); if insal and inemp; run; How can the observations be 0 when there are common variables in both sets. can anyone explain it to me. Thanks. ... View more

  data work.passengers; TransPassengers = 100; OrigPassengers = .; Totalusingoperator = OrigPassengers + TransPassengers; Totalusingfunction = Sum(OrigPassengers,TransPassengers); put Totalusingoperator; put Totalusingfunction; run; Please explain the logic of output why value of Totalusingoperator is . and Totalusingfunction is 100.   Thanks in Advance, Ayushmaan   ... View more

Hi Guys,   Can you please explain me why the data set test created is having Ruth idnum as 22 rather than 11 and Suey age as 40 rather than 30. This has been asked in certification exam, so I need the clarity for the answer. Following is the program:     data test; infile cards; input employee_name $ 1-4; if employee_name = 'Ruth' then input idnum 9-10; else input age 6-7; cards; Ruth 39 11 Jose 32 22 Suey 30 33 John 40 44 ; run;   Dataset created is :   employee_name    idnum    age Ruth                             22         . Suey                               .       40     Thanks in Advance 🙂 Ayushmaan   ... View more

Hello all,   Can I get a basic difference between the below SAS functions:   1. putn() 2. putc() 3. inputn() 4. inputc() ... View more

Hi can you help edit my code, I'm using below user defined format and informat to get my value in array, to store values of cards from "value" to "q" variable.   When i'm using declared varables array as shown below it is working fine, but when i'm changing it to unknown dimention it giving no data in the dataset.   array value{3} value1 value2 value3; array q{3}$ q1 q2 q3;   *Informat; Proc format; invalue $ informat 1 = 'True' 2 = 'False' 3 = 'None' 4 = 'Invalid'; run; *Format; proc format; value $ format 'True' = 101 'False' = 102 'None' = 103 'Invalid' = 104; run; data ds_user1; infile cards; retain id value1 value2 value3 q1 q2 q3; informat value1 value2 value3 $ informat.; input id$ value1 value2 value3; array value{*} _numeric_; array q{*} _character_; do i=1 to dim(value); q{i} = value{i}; end; format value1 value2 value3 $ format.; drop i; cards; a 1 2 3 b 2 4 1 c 3 1 4 d 3 3 2 ; run;   Thanks in advance, Ayushmaan   ... View more

Hi,   Is there a work around that I can use just one tranwrd function to replace all the special charaters in the string. I'm using below code to replace word by word using multiple variable.   data demo; string='run along&the$wall#mister miller'; newstring1=tranwrd(string,'#',' '); newstring2=tranwrd(newstring1,'&',' '); newstring3=tranwrd(newstring2,'$',' '); run; Thanks. ... View more

Hi guys can you help me with the querry  proc import datafile = 'C:\Documents and Settings\Administrator\Desktop\SAS\Excels_for_import\SASTopics_xls.xls' out = SasTopic DBMS = excel; range = "quick$"; run; data SasUpdate; set SasTopic; Estimateddate = input(Date,date9.); if Estimateddate < today() then Status = 'Complete'; else Status = 'incomplete'; format Estimateddate date9.; run; The log window error : Invalid argument to function INPUT at line 164 column 17 The estimateddate variable is not getting formatted and today() function is returning date of 27SEP1997 not today's date. Thanks in advance ... View more