format date ddmmyy10. ... View more

I'm usung mobile , I couldn't find your attached dataset here,can u copy few observations from your dataset and paste here or can u provide few observations of your sample data and expected output here  ... View more

I'm unable to find your dataset here   Edit: Please unmark this from solution ... View more

Is the variable A from red and B from red 2 dataset??? ... View more

I hope this might help u  https://communities.sas.com/t5/SAS-ITRM/SAS-and-PGP-Encryption/td-p/172312?nobounce ... View more

When creating a new library in SAS OnDemandAcademics, check this checkbox -  Re-create this library at start-up (adds the library to the SAS autoexec file)     In OnDemandAcademics SAS Studio , check in your left pane (Expand Libraries) and check whether Orion exists or not,if it exist , u can expand it to view the datasets you can use the below code also   proc contents data=orion._all_ nods; run;   to display all data sets under orion library and in the top right , you can find list of menus near help menu    If your library does not exist then edit your autoexec , add the library there to run when the application starts. ... View more

Sort the dataset by X Then use the condition if first.X ne 1 and last.x ne 1; Output; Else x=' '; Output; ... View more

I hope this will help u  http://support.sas.com/kb/48/674.html ... View more

You mean u want to rotate the table and ignore the missing values of the value1,2,...n from table A and show only the columns which has values  If that's the case then this might help u , I haven't tested, data b(keep = id value); Set a; do I= 1 to n; array value{i}; If value{i} ne . then  Value=value{I}; End; Run; ... View more

@byeh2017 wrote: data practice.new; if ageyr <= 8 then young="Y"; else young="N"; run; data practice.new; - this statement creates a data set named 'new' in 'practice' library if practice.new is your source data u need to define practice.new in the SET statement so that SAS fetches data from it   ... View more