But the problem is I cannot locate the file named Checking anywhere in my PC. ... View more

I did this >   %include '\act$\data2datastep.sas' /lrecl=1000; %data2datastep(check, Actshare,Checking, 100);   Then I got this in log   NOTE: The file "Checking" is: Filename=D:\sasconf\Config\Lev1\SASApp\Checking, RECFM=V,LRECL=32767,File Size (bytes)=0, Last Modified=10 August 2017 14:06:00, Create Time=10 August 2017 14:06:00 NOTE: 105 records were written to the file "Checking". The minimum record length was 4. The maximum record length was 39. NOTE: There were 100 observations read from the data set ACTSHARE.CHECK. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds     Now I am not getting what to do next ... View more

I used the macro  %data2datastep(cars,sashelp,,5) and created a new dataset but couldn't find it anywhere.   what should I do..?? ... View more

Is there a way I can send my DataSet.   I am using SAS EG 9.4.   ... View more

Sorry clicked on Accept as Solution by mistake.   Ya it should display one but it displays 1 for only first row and from second row onwards it display 0.99999.   can't understand why..?? ... View more

Sorry My Mistake.   data have; input first; cards;0.0328565628; run; Data have ; set have ; call symput('OBSERVEDAVGVAR',  First);  run ; Data Have2 ; Set have ; Second = &OBSERVEDAVGVAR ; Run ; Data have3 ; Set have2 ; Third = First/Second ; Run ; ... View more

data have; input first; cards;0.0328565628; run; Data have ; set have ; call symput('OBSERVEDAVGVAR',  ObservedAverages);  run ; Data Have2 ; Set have ; Second = &OBSERVEDAVGVAR ; Run ; Data have3 ; Set have2 ; Third = First/Second ; Run ;   ... View more

i have a column named FIRST with a value 0.0328565628 and I am storing this in a macro variable xyz and then this value is stored in another column named SECOND but when I am creating a third column named THIRD which is equal to FIRST/SECOND then it is giving a value of 0.999999 but I am expecting this to be complete 1 because logically both the columns FIRST and SECOND are exact same.   I can't understand the reason for this.  Hope someone can help. 🙂 ... View more