About GeorgeSAS

GeorgeSAS · ‎06-19-2017

%sysjpbid is the id of the job, not the job file. Thank you.

GeorgeSAS · ‎06-14-2017

Thank you Astounding,this does not work on mainframe,I think that is an UNIX way.

GeorgeSAS · ‎06-14-2017

Hello, I have question runing SAS on mainframe,but I am not sure what category of the topic belongs to for my question, so I choose General question as a Location,if you know please tell me.thanks. My SAS question on mainframe is : Is there an auto variable like &SYSDATE or &SYSJOBID. that can show the current JCL job file's full name in SAS log? i.e. the current full job file is "user.research.pds(test1)". I want call an auto variable in the curent program to show that in SAS log.I am not sure there was such an auto variable,please advise. Thank you!

GeorgeSAS · ‎06-08-2017

Hello, Could anyone tell me what is the difference of add semicolon or not after call a macro? Thanks! %macro test; %put a; %mend test; %test; %test

GeorgeSAS · ‎06-07-2017

Hello, Would you please tell me what's the difference of a1 and a2? Thanks data a1; set sashelp.class; where sex ne 'M'; run; data a2; set sashelp.class; if sex eq 'F'; run;

GeorgeSAS · ‎06-07-2017

Thank you all! %macro test; %put a; *%put b; %*put c; /*%put d;*/ %put abcd; %mend test; %test;

GeorgeSAS · ‎06-06-2017

I hope my question is clear, if not. please let me rephrase it: %testA is a user defined macro. I don't want it be executed, so I add a '*' *%testA; My question is how it compare with %*testA? Looks either way will not execute the macro(all works).

GeorgeSAS · ‎06-06-2017

How about *%testA;? Thanks

GeorgeSAS · ‎06-06-2017

Hello, When I trying to comment out a macro, do I use *% or %*? what difference? Thanks! %macro testA; *......; %mend testA; %*testA; *%testA; I hope my question is clear, if not. please let me rephrase it: %testA is a user defined macro. I don't want it be executed, so I add a '*' *%testA; My question is how it compare with %*testA? Looks either way will not execute the macro(all works).

GeorgeSAS · ‎05-15-2017

*----------------C:\temp\test\aa.txt--------------------------------; /*Program name newcode.sas*/ /*This SAS program will print sashelp.class*/ proc print data=sashelp.class; run; data a; set sashelp.class; run; *----------------------------------------------; data textdata; infile "C:\temp\test\aa.txt" truncover; input textline $100.; run; data textdata2; length z $200; set textdata; z=cat("put '",strip(textline),"';"); run; data textdata3; set textdata2; file "C:\temp\test\aa2.txt"; put z; run; data _null_; file 'C:\temp\test\aa3.sas'; %include "C:\temp\test\aa2.txt"; run; Thank you! Also thank Tom's good code,that works better: data _null_; file "c:\temp\newcode72.sas" ; input; put _infile_; cards4; /*Program name newcode.sas*/ /*This SAS program will print sashelp.class*/ proc print data=sashelp.class; run; data a; set sashelp.class; run; ;;;;

GeorgeSAS · ‎05-15-2017

If I use ftp transfer SAS data set from mainframe.I can only transfer the folder which I can't open in PC.

GeorgeSAS · ‎05-11-2017

Hello, I have a .txt file abc.txt: /*Program name newcode.sas*/ /*This SAS program will print sashelp.class*/ proc print data=sashelp.class; run; data a; "set sashelp.class; run; How I can read it in to SAS dataset? Thanks

GeorgeSAS · ‎05-11-2017

I want to create a new SAS program "c:\temp\newcode.sas" The full codes inside the file is: /*Program name newcode.sas*/ /*This SAS program will print sashelp.class*/ proc print data=sashelp.class; run; data a; set sashelp.class; run; My question is I can use data _null_ step to create the file? Thanks!

GeorgeSAS · ‎05-11-2017

Hello all; I want use data step generate external file. the put statment does not work(need to keep the enter between rows) and need to be revised. please help.(I don't want add "put" in each line, because the real program has hundreds lines of codes) Thank you! Filename need "c:\temp\newcode.sas"; data _null_; file need; *------------ the code below need to be print to external file "newcode.sas*"------------------; put " /*Program name newcode.sas*/ /*This SAS program will print sashelp.class*/ proc print data=sashelp.class; run; "; *-----------------------end -------------------------------; run;

GeorgeSAS · ‎05-10-2017

Hello, I use SAS in pc and mainframe. I have 3 JCL FILES at mainframe under AAAAAAAA.BBBBBBBB.MYLIBS.PDS I want to transfer the three jcl files(please note, I want transfer regular files, not SAS dataset) from mainframe to my pc. please help me on my code: LIBNAME pc_lib "C:\TEMP5"; %connect(...,...);/*a macro can connect to mainframe*/ rsubmit remote=abasa; libname M_lib "AAAAAAAA.BBBBBBBB.MYLIBS.PDS"; proc download inlib=M_lib outlib=pc_lib; run; endrsubmit; signoff; Thanks!

Online Status	Offline
Date Last Visited	‎08-17-2021 03:05 AM

move multiple 'or' statements into one statement

get notification when call system task finish

reduce output data

How to find SAS foundation location in UNIX

Re: get last 10 obs

get last 10 obs

Re: SAS EG increse project log size from 5 megabytes to more

SAS EG increse project log size from 5 megabytes to more

Re: what the " 'n " means?

Re: what the " 'n " means?

Re: move multiple 'or' statements into one statement

Re: How to find SAS foundation location in UNIX

Re: How to find SAS foundation location in UNIX

Re: get last 10 obs

Re: get last 10 obs

Re: Font size is huge in enhanced editor

SAS LOGPARM= option

Clean up memory usage of SAS base

call a macro end with semicolon?

download and exclude special format

Re: SAS on mainframe

Re: SAS on mainframe

SAS on mainframe

call a macro end with semicolon?

diffrence if and where in data step

Re: comment out a macro

Re: comment out a macro

Re: comment out a macro

comment out a macro

Re: data _null_ put "embed SAS code" in data step

Re: Transfer files from Mainframe to PC

how to read this .txt file into SAS

Re: data _null_ put "embed SAS code" in data step

data _null_ put "embed SAS code" in data step

Transfer files from Mainframe to PC