Help using Base SAS procedures

Proc DSTrans example.

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Proc DSTrans example.

Hi,

 

while reading on Proc DS2, i came across a comment
which said PROC DSTRANS will help you by translating a subset of your DATA step code into DS2 code.
However i am not able to find a good documentation on this procedure.  some have put the code but not the result or log.
i use the same code and it does not work for me .. 

Could someone please guide me on this ... DS2 seems very promising.  (Fyi I am using sas 9.4 on Eg 7.1 in noprofile mode) 


so I created a dummy code like 

 

data side_L;
	SET Sashelp.geoexs;
		where side='L';
run;


data side_R;
	SET Sashelp.geoexs;
		where side='R';
run;

saved the code and then tried proc dstrans as follows 

 

PROC DSTRANS DS_TO_DS2  
	IN='F:\sas\sas statistic practise dsn/ds2_proc_dstrans.sas'
	OUTdir='F:\sas\sas statistic practise dsn/' 
	out='ds2_proc_dstrans_Converted.sas'  ;
RUN;
quit;

 

 

 

Here is the log - 

 

 

23         PROC DSTRANS DS_TO_DS2
24         IN='F:\sas\sas statistic practise dsn/ds2_proc_dstrans.sas'
25         OUTdir='F:\sas\sas statistic practise dsn/'
26         out='ds2_proc_dstrans_Converted.sas'  ;
27         RUN;

3          data side_L;
           ____
           180
4          	SET Sashelp.geoexs;
            ___
            180
5          		where side='L';
             _____
             180
9          data side_R;
           ____
           180
ERROR: Could not compile source code.
10         	SET Sashelp.geoexs;
            ___
            180
11         		where side='R';
             _____
             180
ERROR 180-322: Statement is not valid or it is used out of proper order.

Accepted Solutions
Solution
‎02-16-2016 01:12 PM
Community Manager
Posts: 2,954

Re: Proc DSTrans example.

Posted in reply to smijosimon

DSTRANS is used mainly by SAS solutions, such as SAS Decision Services, to convert DATA step to DS2 or C.  There are some references to it being documented as part of the DS2 Language Reference, but I don't see it there.  At best, I'd say this isn't a highly-documented procedure as it was designed to facilitate SAS-provided solutions -- pushing DATA step work into databases or creating parallelized data flows.

View solution in original post


All Replies
Super User
Posts: 19,799

Re: Proc DSTrans example.

Posted in reply to smijosimon

Can you post references to PROC DSTRANS?

I can't find anything either, except a random comment in someone's blog.

That type of code translation seems a bit too good to be true to me Smiley Happy

Occasional Contributor
Posts: 8

Re: Proc DSTrans example.

 

Here is the description that comes up on  SAS EG. However on clicking the product documentation links results in "no results found"
and some links say its explained in the "DS2 language reference guide", however i do not find any mention of it there too.

makes me wonder if it was an internal training procedure Smiley Very Happy

 

 

dstrans.png

 

 

dstrans2.PNG

Solution
‎02-16-2016 01:12 PM
Community Manager
Posts: 2,954

Re: Proc DSTrans example.

Posted in reply to smijosimon

DSTRANS is used mainly by SAS solutions, such as SAS Decision Services, to convert DATA step to DS2 or C.  There are some references to it being documented as part of the DS2 Language Reference, but I don't see it there.  At best, I'd say this isn't a highly-documented procedure as it was designed to facilitate SAS-provided solutions -- pushing DATA step work into databases or creating parallelized data flows.

Occasional Contributor
Posts: 8

Re: Proc DSTrans example.

Posted in reply to ChrisHemedinger
Thanks Chris. That makes sense.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 836 views
  • 0 likes
  • 3 in conversation