topic Re: SAS MAINFRAME in SAS Programming

SAS MAINFRAME

rohitkrishna — Mon, 04 Feb 2019 14:46:49 GMT

Hi , I new to the mainframe environment i basically sas programmer i currently working on both environment so i have few dought on compilation of the sas jcl program below the prg

//rohit2a job (998924) 'krishna',

// class=0,msgclass=x,notify=&sysuid

//saspgm exec sssas,

// work='150,100', region=8m,sort='100,100'

//saslist dd sysout=*

//work dd space=(23476,(5,1)),avgrec=k

//dsinput1 dd dsn=in.test.half,disp=shr

//dsoutput dd dsn=in.test.file2. disp=new,

// unit=sysda,space=(cyl,(10,10),rlse),

// dcb=(recfm=fb,lrecl=128,blksize=12800)

//sysin dd *

------------sas prg begins here-----------------------

data freq;

infile dsinput1 dsd;

input @3 id $char4.

name $char4.

surname $char8.;

proc sort data=freq out=dsoutput nodupkey;

by id;

proc print data=dsoutput;

run;

so here the my dought mainly i getting the maxxcc=0000 and my output will display on spoll but not went to outputfile so what is issue and give the sum coding part and some expls

Thanks & Regards

N rohitkrishna

Re: SAS MAINFRAME

rbetancourt — Mon, 04 Feb 2019 20:01:07 GMT

This job should fail with a JCL error. Try placing a comma (,) after in.test.file2 and not a period (.)

//dsoutput dd dsn=in.test.file2, disp=new,

Good Luck,

Randy

Re: SAS MAINFRAME

Astounding — Mon, 04 Feb 2019 20:36:00 GMT

It is unusual to specify dcb information for SAS data. Just omit that and let sas use default values.

Your program does not write anything to in.test.file2 ... it only writes a temporary sas data set named dsoutput. If you want a permanent sas data set named mydata, you would need to specify out=dsoutput.mydata. Permanent sas data sets use two part names where the first part of the name is the name of the DD statement and the second part of the name is the name you assign to the sas data set.

Re: SAS MAINFRAME

rohitkrishna — Tue, 05 Feb 2019 07:19:34 GMT

HI Astounding
thanks for you reply, and i used your syntax
out=DSOUTPUT.FREQ one is dd name other one is sas data set name but it shows maxcc=0008
and in spool it says "Libraray DSOUTPUT is not in a valid format for access method sase7"
that is error i am getting kindly give solution for that
Thanks & Regards
N rohitkrishna

Re: SAS MAINFRAME

Astounding — Tue, 05 Feb 2019 12:24:39 GMT

Re: SAS MAINFRAME

Astounding — Tue, 05 Feb 2019 12:31:21 GMT

When you ran the job the first time, the program created in.test.file2 with incorrect DCB information. A later program cannot change the structure of the existing data set. You need to remove the DCB parameter from the DD statement then manually delete in.test.file2 then re-run the job.

Re: SAS MAINFRAME

rohitkrishna — Tue, 05 Feb 2019 15:05:44 GMT

Thanks for replay
i am getting output but the thing is i am getting all records its not i am expeeting bez i am sorting the file so after sorting i getting unique records in saslog only not in outputfile
plz kindly give me the sum suggestions
Thanks & Regards
N muralikrishna

Re: SAS MAINFRAME

Astounding — Tue, 05 Feb 2019 16:05:17 GMT

You will have to show your latest program.

In general you should expect that PROC SORT will not change your original data set. When using the out= option, the original data set remains unchanged, while the out= data set contains the sorted, unique results.

Re: SAS MAINFRAME

rohitkrishna — Wed, 06 Feb 2019 06:56:08 GMT

HI, Astounding
I shown above prg in that i mention two differnt data sets one is for input data in that data will there and the other one is output put data so i mention out=output dataset name itself but still i am not getting the sorted data
Thanks & Regards
N muralikrishna

Re: SAS MAINFRAME

Astounding — Wed, 06 Feb 2019 07:58:13 GMT

For anyone to be able to help, you will have to post the log from your latest program.

Re: SAS MAINFRAME

Jebastin — Tue, 28 Jan 2020 04:18:59 GMT

Hey, You should give SASLIST a data set name instead of giving * ( * means, it will write in spool).

Please refer the link below,

https://documentation.sas.com/?docsetId=hosto390&docsetTarget=n0av74evu58bjnn1hhfdazc88lcd.htm&docsetVersion=9.4&locale=en

Sorry for the late reply..................... Cheers !!!!!!!!!!!!!